Building ETL Pipelines with SQL

This course teaches how to build production-ready ETL pipelines using pure SQL on the Databricks Data Intelligence Platform. Students learn Streaming Tables with Auto Loader for incremental ingestion, Materialized Views with incremental refresh for Silver-to-Gold transformations, AUTO CDC (FLOW AUTO CDC) for declarative SCD Type 1 and Type 2 dimension management, and Lakeflow Jobs with SQL File tasks for production orchestration. The course follows a realistic retail dataset through the medallion architecture (Bronze → Silver → Gold).

Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Skill Level

Associate

Duration

Prerequisites

In this course, the content was developed for participants with these skills/knowledge/abilities:

• Navigating the Databricks workspace (sidebar, Catalog Explorer, SQL Editor)

• Unity Catalog basics (catalogs, schemas, tables, volumes)

• Intermediate SQL (SELECT, JOIN, GROUP BY, CAST, COALESCE, CREATE TABLE)

• Data warehousing concepts (fact/dimension tables, star schemas, medallion architecture)

• Basic understanding of ETL workflows

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Customer registration Partner registration

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Blended Learning

Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase

Purchase now

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

Monitoring and Observability with System Tables

Comprehensive auditing, monitoring, and observability using system tables, query history analysis, and proactive alerting for DBSQL environments.

Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures. You can access the lecture notebooks in the Vocareum lab environment.

Free

Associate

Lakebase Architecture Deep Dive

Opens the hood on Lakebase. Built on the lecture-demo pattern (teach a concept, immediately run it), the course explains the compute/storage split, why it yields a ~5x write gain by eliminating Full Page Writes, how copy-on-write branching is an O(1) operation, and how the five-level object hierarchy organizes real deployments. It is the architectural foundation the rest of the Lakebase pathway builds on.

Free

Associate

Data Warehousing Practitioner

Building Semantic Models in Databricks with UC Metric Views

In this course, you’ll learn how to empower your data consumers to get validated business insights with less burden on you and the rest of your enterprise's data and AI team. Through building a semantic layer on top of your gold layer, you'll offer decision makers and business analysts the opportunity to explore key business performance indicators in novel ways, while still maintaining efficient data operations and enterprise-vetted metrics.

Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Languages Available: English | 日本語 | 한국어

Free

Associate