Mastering Databricks SQL Warehouse and Spark SQL

A Comprehensive Course on Databricks SQL Warehouse and Spark SQL for Data Engineers, Data Analysts, BI Developers, etc

Created by: Durga Viswanatha Raju Gadiraju
CEO at ITVersity and CTO at Analytiqs, Inc

Created by: Pratik Kumar

Created by: Sathvika Dandu

Created by: Madhuri Gadiraju

Created by: Sai Varma

Created by: Phani Bhushan Bozzam
Aspiring Project Manager & Creative UI/UX Designer

Created by: Anushka Chakraborty

What Will I 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)

Requirements

• Basic SQL Skills and Data Analysis Skills
• Computer with decent configuration and Internet
• Valid Azure Account with Databricks (instructions provided to setup environment using Azure Databricks for hands on practice)

Target audience

• Data Analysts and BI Developers who want to understand Databricks SQL or Spark SQL Queries to analyze the data
• Data Engineers who would like to understand Databricks SQL
• QA Analysts or Engineers who would like to understand Databricks SQL for the validation of the data
• Business Analysts to analyze the Data in the Data Lake using Databricks SQL or Spark SQL Queries
• BI Developers who want to understand how to connect BI Tools to Databricks SQL Endpoint and develop required reports and dashboards