SQL Programming and Procedural Logic

In this hands-on course, you will explore core SQL programming and procedural logic skills within Databricks, focusing on how to build modular, maintainable, and production-ready analytics workflows. You’ll start by learning about key SQL constructs—such as Common Table Expressions, temporary views, and User Defined Functions—that make your SQL development cleaner and more reusable. The course then guides you through advanced SQL scripting techniques using compound statements, variables, control flow, conditionals, loops, and robust error handling to create structured and flexible SQL processes. Finally, you’ll discover how to orchestrate and modernize complex workflows with Lakeflow Jobs and migration strategies, transforming legacy tasks into modular, automated pipelines that leverage the full capabilities of the Databricks platform.

Note: Hands-on training courses will be updated to reflect the newest product and feature announcements from Data + AI Summit in June 2026. 

Prerequisites

• Familiarity with the Databricks Data Intelligence Platform, including workspaces, SQL warehouses, and notebooks
• Experience with Databricks Lakehouse architecture, including Delta Lake and Unity Catalog
• Intermediate SQL experience, including stored procedures, dynamic queries, and data analysis in relational databases
• Familiarity with data pipeline orchestration and workflow management
• Working knowledge of data warehousing concepts, including ETL, schema design, data modeling, and BI reporting