What you'll learn:
- Setup Databricks SQL Warehouse Environment using Azure Databricks for hands-on Practice
- Getting Started with Databricks SQL for Data Analysis or Data Engineering
- Features of Databricks SQL Warehouse - Clusters, Query Editor, Visualizations and Dashboards, etc
- Overview of building reports and dashboards using Databricks SQL
- Creating Databases and Tables using Databricks SQL or Spark SQL
- Writing Basic Queries using Databricks SQL or Spark SQL
- DML to load data into Databricks SQL or Spark SQL Tables
- Advanced Operations such as Ranking and Aggregations using Databricks SQL or Spark SQL
- Processing Semi-Structured Data using Databricks SQL or Spark SQL
- In-depth Coverage about Delta Tables including all possible DML Operations such as Insert, Update, Delete, Merge, etc
- End to End Life Cycle of Data Analysis of Data in Files using Databricks (Uploading File to Databricks to Reports and Dashboards)
Databricks SQL Warehouse is relatively new technology to build Data Lakehouse or Data Warehouse leveraging powerful Apache Spark Engine where the analytics can be built at scale. As part of this comprehensive course, you will learn all key skills required to master Databricks SQL Warehouse including Spark SQL as the SQLin Databricks SQL Warehouse is based on Spark SQL.
This course also covers most of the curriculum relevant to clear the Databricks Certified Data Analyst Associate Exam offered by Databricks itself.
Here are the high-level details related to this course. This is a beginner level course where you will be able to not only learn syntax and semantics of Databricks SQLor Spark SQL, you will also understand the concepts of the same.
Setup Course Material and Environment for Databricks SQLWarehouse
Managing Databases using Databricks SQL Warehouse
Manage Delta Tables in Databricks SQLWarehouse
Setup Data Set for Databricks SQL Views and Copy Commands
Databricks SQLor Spark SQLQueries to Process Values in JSON String Columns
Copy Data into Delta Tables in Databricks SQL Warehouse
Insert or Merge Spark SQLor Databricks SQLQuery Results or View into Delta Tables
Merge Spark SQLor Databricks SQLQuery Results and Data from Delta Table with Delete into Delta Tables
Basic SQL Queries using Spark SQLor Databricks SQL
Performing Aggregations using Group By and filtering using Having leveraging Spark SQLor Databricks SQL
Aggregations using Windowing or Analytical Functions including Cumulative Aggregations using Spark SQLor Databricks SQL
Ranking using Windowing or Analytical Functions using Spark SQLor Databricks SQL
Dealing with different file formats such as parquet, json, csv, etc using Spark SQLor Databricks SQL
All Important types of Joins such as Inner, left or right outer, full outer using Spark SQLor Databricks SQL
Visualizations and Dashboards using Databricks SQL Warehouse
We have also provided quite a few exercises along with solutions with explanations through the course.
Key Takeaways of Mastering Databricks SQL and Spark SQLusing Databricks SQLWarehouse
Setup Environment to learn Databricks SQL and Spark SQLusing Azure
Support via Udemy Q&A backed by our expert team
Data Sets and Material via GitHub Repository along with instructions to practice Databricks SQLor Spark SQL
Life Time Access to High Quality Video Lectures to learn Databricks SQL and Spark SQL
