Intermediate Level

Databricks Certified Databricks SQL for Data Analysts

★ 4.8 (300 learners) 60 hrs total 8 modules

Microsoft Azure Databricks Delta Lake Apache Spark Unity Catalog

Only 4 seats left · Next batch starts 5 Sept 2026

Download Curriculum

60 hrs: of content
8 modules: in curriculum
16 projects: hands-on builds
Intermediate: difficulty

Curriculum covers

Frameworks you'll master

5 tools & frameworks

Microsoft Azure Databricks Delta Lake Apache Spark Unity Catalog

Course Curriculum

8 modules · 60 hours · 24 live sessions

SetUp and Overview of Databricks 3 sessions

Introduction to Big Data (Optional)
Apache Spark Ecosystem (Optional)
Overview of Databricks
Azure Account Set Up
Azure Portal Overview
Cost Management and Billing
Important Databricks Access Issue: Solution for Azure Personal Domains
Creating a Databricks Premium Workspace
Databricks Workspace User Interface
Unity Catalog Overview
Enabling Unity Catalog Overview
ADLS Overview and Storage Creation
Access Connector for Databricks
Global Administrator Prerequisite Check
Enabling Unity Catalog
Creating a SQL Warehouse

Introduction to Databricks Lakehouse Platform 1 sessions

Your First Query
Switching Catalogs and Schemas
Scheduling Queries
Adding Comments to Queries

Catalogs, Schemas, Tables and Views 3 sessions

Creating Catalogs
Creating Schemas
Data Types in Databricks SQL
Overview of Tables in Databricks
Creating Managed Tables with SQL
Creating Managed Tables in Hive Metastore
Creating Managed Tables using the Data Explorer
Creating an External Storage Location
Creating External Tables
Overriding Unity Catalog’s Default Managed Table Storage Location
Truncate Table
Alter Table
Drop Tables, Schemas and Catalogs

Data Analysis with SQL 6 sessions

Select Statement Recap
Select Distinct
Note on the JC_BIKE_DATA_22 Table
Filtering Records with the WHERE Clause
Filtering Records Based on Multiple Conditions
Filtering Records with the IN and LIKE Operators
Deleting Records
Databricks SQL Built In Functions Overview
String Functions
Numerical Functions
Date and Timestamp Functions
Converting Strings to Dates/Timestamps
Conditional Functions
Aggregate Functions
Group By Clause
Filtering Aggregated Tables with the Having Clause
Joining Tables Overview
Joining Tables Demo
Order By and Limit Clauses
SQL Order of Execution
Subqueries
Views
Set Operators
SQL Challenge 1
SQL Challenge 2
SQL Challenge 3
SQL Challenge 4
SQL Challenge 5

Delta Lake 1 sessions

Medallion Architecture and Last Mile ETL
Medallion Architecture Demo
Benefits of Delta File Format
Upsert / Merge Into
Table Audit History and Time Travel

Query Alerts and Monitoring 1 sessions

Query History and Profile
Query Caching in Databricks SQL
Query Alerts

Visualizations and Dashboards in Databricks SQL 7 sessions

Visualizations and Dashboards Overview
Our First Chart in Databricks SQL
Line and Area Charts
Combo Chart
Pie Chart
Scatter and Bubble Plots
Histograms
Box Plots
Heatmaps
Sankey Charts
Tables
Pivot Tables
Counters
Additional Guidance on Charts in Databricks SQL
Exploratory Data Analysis Challenge
Adding Missing Data to the JC_BIKE_DATA_22 Table
Creating a View to Simplify Upcoming Demos
Query Filters
Query Parameters
Query Parameters (Dates)
Dashboards in Databricks
Introduction to Dashboards
Creating a Dataset Using SQL
Adding Parameters to Dashboards
Adding Filters to Dashboards
Text Boxes
Seasonal Analysis by Rider Type Challenge
Legacy Dashboards
Legacy Introduction to Dashboards
Legacy Adding Parameters to Dashboards
Legacy Adding Filters to Dashboards
Legacy Trip Duration Analysis Challenge
Legacy Rider Type Analysis Challenge

Access Control, Data Governance and Unity Catalog 2 sessions

Administrative Roles in Databricks
Adding a New User to our Azure Account
Adding a New User to our Databricks Environment
Workspace Admin Settings
Workspace Object Access Control
SQL Warehouse Access Control
Folder Access Control
Query Access Control
Dashboard Access Control
Workspace Object Access Control Summary
Unity Catalog Securable Objects and Privileges
Granting and Revoking Privileges with SQL (Unity Catalog)
Granting and Revoking Privileges via the Data Explorer (Unity Catalog)
Redacting Data with Dynamic Views (PII)
Data Discovery
Data Lineage
Delta Sharing Overview
Databricks to Databricks Delta Sharing
Open Delta Sharing

Download Full Curriculum

Batch Schedule

⚡ Seats filling fast — only 4 remaining across all batches

Available Batches
Batch Type	Schedule	Duration	Next Start Date	Availability
Weekend	Sat & Sun, 10am–1pm	10 weeks	5 Sept 2026	Available
Weekday	Mon–Fri, 7–9pm	8 weeks	7 Sept 2026	Available
Fast-track	Mon–Sun, 6 hours/day	2 weeks	14 Sept 2026	Only 4 seats left

Ready to Get Started?

Download the curriculum to see every module, batch dates and fees. Book a free 30-minute session with our advisors to get your questions answered.

Book Free Demo

Download the Full Curriculum

See every module, capstone project, and tool covered — free, instant access.

Similar Courses You Might Like

View Course →

Data Engineering

data engineering

AWS GLUE Lambda Certification

★ 4.8 · 300 learners · Intermediate

Starts 8 Aug 2026 · ~1–2 months

View Course →

Data Engineering

data engineering

Databricks - Master Databricks for Data Engineers

★ 4.8 · 300 learners · Intermediate

Starts 15 Aug 2026 · ~1–2 months

View Course →

Data Engineering

data engineering

Databricks Certified Data Engineer Associate

★ 4.8 · 300 learners · Intermediate

Starts 22 Aug 2026 · ~1–2 months

View Course →

Data Engineering

data engineering

Databricks Certified Data Engineer Professional

★ 4.8 · 300 learners · Advanced

Starts 29 Aug 2026 · ~1–2 months

Book Free Demo