Query and Explore Data in Databricks SQL
UPPER() and LOWER() — case normalization.
This training addresses a concrete problem that every data team encounters: the data lives in the lakehouse, and the team needs answers. Before Databricks SQL, the typical workflow looked like this: export the data to CSV, open it in Excel, build formulas, and get a basic answer 30 minutes later. The next day, someone asks the same question with a different filter — and it starts again.
Databricks SQL offers a straightforward alternative: write standard SQL directly against Delta tables, get results in seconds from the lakehouse, and save these queries for the entire team to reuse.
Sign in to read this course
A free account unlocks all 514 courses. 20 are readable without one.
What's inside
8 sections- 1 Table of Contents
- 2 Training overview
- 3 Understanding query execution in Databricks SQL
- 4 Writing SQL queries for analysis
- 5 Organizing data for repeatable workflows
- 6 Demo Database Schema
- 7 Complete demo query reference
- 8 Summary of key concepts
More Azure Databricks & Spark courses
View all 14Administering Clusters and Configuring Policies with Databricks
Databricks architecture, cluster types and runtimes, autoscaling, cluster policies, pools and init scripts.
ETL Pipelines with Azure Databricks and Data Factory
Build ETL with Spark and PySpark, Unity Catalog governance, Delta Lake and Databricks vs Data Factory.
Manage Data with Azure Databricks and Azure Data Lake
Connect Databricks to ADLS Gen2 securely, ingest with Auto Loader and govern with Unity Catalog.
Optimize Storage and Performance with Delta Lake
Delta Lake internals, ACID, OPTIMIZE, Z-Order, liquid clustering, caching and Photon acceleration.
Real-Time Data Processing with Azure Databricks
Spark Structured Streaming with Event Hubs — windowing, stateful processing and real-time anomaly detection.
Machine Learning with Azure Databricks
The Databricks ML lifecycle: MLflow tracking, tuning with Ray, the model registry, serving and AutoML.
Interested in this course?
Contact us to book it or get a custom training plan for your team.