Data Warehousing Practitioner

DATB-SQLPPL : SQL Programming and Procedural Logic

Course Duration

3 Hours

Delivery

ILT/VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

In this 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.

What You'll Learn

SQL Constructs in Databricks
SQL Scripting in Databricks
Procedural Logic in Databricks

Who Should Attend

Prerequisites

The content was developed for participants with these skills/knowledge/abilities:

A fundamental understanding of SQL workspaces, data warehouses, and Databricks notebooks (SQL, Python, and markdown)
Experience working with the Databricks Lakehouse architecture, including Delta Lake and Unity Catalog for data management and governance
Familiarity with creating and managing workflows for data pipelines and orchestration
Prior experience querying and analyzing data with SQL in relational databases, including use of stored procedures and dynamic or parameterized queries
A working knowledge of data migration or modernization projects, covering core data warehousing concepts such as ETL, schema design, data modeling, and BI Reporting
Awareness of data pipeline orchestration and compliance best practices, and understanding of ANSI SQL standards

Learning Journey

Coming Soon...

SQL Constructs in Databricks

Common Table Expressions (CTEs)
Temporary Views
SQL User Defined Functions (UDFs)
Execute Immediate
Parameterized SQL
SQL Constructs

SQL Scripting in Databricks

Compound Statements
Variables
Conditional Logic
Control Flow with Looping Constructs
Error and Exception Handling
SQL Scripting

Procedural Logic in Databricks

Introduction to Lakeflow Jobs
Lakeflow Jobs
Stored Procedure Migration Strategies

Frequently Asked Questions (FAQs)

None

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By Databricks

Browse All Courses

Data Engineer

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name

Phone

I'm inquiring for

Myself

Company

Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.