Why this course?

Description

Learn Databases like Cassandra and Deltalake

 

We will learn:

1) Apache Cassandra

• Overview
• NoSQL

2) Apache Cassandra Installation

• On Ubuntu

3) Cassandra Query Language (CQL)

• Data Type
• User Defined Types
• Create, Use, Alter, Drop - KeySpace
• Create, Alter, Drop, Truncate - Table
• Select, Insert, Update, Delete and Batch Statement
• Arithmetic Operators
• Secondary Indexes
• Functions - Scalar and Aggregate

4) Apache Cassandra - Architecture Overview

• Storage Engine
• Guarantees
• Snitch

Cassandra provides:

• Fault-Tolerant
• Focus on Quality
• Performant
• You’re In Control
• Security and Observability
• Distributed
• Scalable
• Elastic
• Hybrid

 

Topics Included in the Delta Lake Courses

• Introduction to Delta Lake
• Introduction to Data Lake
• Key Features of Delta Lake
• Introduction to Spark
• Free Account creation in Databricks
• Provisioning a Spark Cluster
• Basics about notebooks
• Dataframes
• Create a table
• Write a table
• Read a table
• Schema validation
• Update table schema
• Table Metadata
• Delete from a table
• Update a Table
• Vacuum
• History
• Concurrency Control
• Optimistic concurrency control
• Migrate Workloads to Delta Lake
• Optimize Performance with File Management
• Auto Optimize
• Optimize Performance with Caching
• Delta and Apache Spark caching
• Cache a subset of the data
• Isolation Levels
• Best Practices
• Frequently Asked Question in Interview