Learning Series | SQL Programming and Procedural Logic

Tushar_Parekar — Mon, 10 Aug 2026 08:45:42 GMT

Databricks Academy offers the free SQL Programming and Procedural Logic course to help data warehousing practitioners build more modular and maintainable SQL workflows on the Databricks Data Intelligence Platform. It covers reusable SQL constructs, procedural scripting, transactions, stored procedures, and workflow orchestration for production-ready data processes.

You’ll learn to:

Build reusable SQL logic: Use CTEs, including recursive CTEs, temporary views and tables, and User Defined Functions to make SQL development clearer and easier to maintain.
Write structured SQL scripts: Apply variables, control flow, conditionals, loops, and error handling to create more flexible multi-step processes.
Manage consistency and reusable procedures: Use multi-statement transactions and SQL Stored Procedures to organize logic and help keep data changes consistent.
Modernize and orchestrate workflows: Use Lakeflow Jobs and migration strategies to turn legacy tasks into modular, automated Databricks workflows.

Recent updates:

Added coverage of temporary tables, multi-statement transactions, SQL Stored Procedures, and recursive CTEs
Moved exercises into comprehensive end-of-module practical sessions
Updated compute to use Serverless and SQL Warehouses
Made exercises compatible with the Databricks Free Edition

Designed for:

Data warehousing practitioners who want to strengthen their SQL programming skills on Databricks
Users with working knowledge of SQL, Databricks notebooks, Delta Lake, and Unity Catalog
Learners familiar with data pipelines, orchestration, stored procedures, and modernization projects

Course format & details:

Syllabus: 3 sections | 10 lessons
Duration: 2 hours
Skill level: Associate
Cost: Free
Includes labs: No
Role: Data Warehousing Practitioner

Important note:

For SCORM lecture files, close the SCORM window after completing the content. Do not click Next Lesson, as this may prevent the module from being marked complete.