Data Warehousing with Databricks

This course is designed for data professionals who want to explore the data warehousing capabilities of Databricks. Assuming no prior knowledge of Databricks, it provides an introduction to leveraging Databricks as a modern cloud-based data warehousing solution. Learners will explore how use the Databricks Data Intelligence Platform to ingest, transform, govern, and analyze data efficiently using the industry-standard TCP-DI dataset as a reference. Learners will also explore Genie, an innovative Databricks feature that simplifies data exploration through natural language queries. By the end of this course, participants will be equipped with the foundational skills to implement and optimize a data warehouse using Databricks.

Languages Available: English | 日本語 | Português BR | 한국어

Skill Level

Associate

Duration

Prerequisites

- Basic understanding of SQL and data querying concepts

- General knowledge of data warehousing concepts, including tables, schemas, and ETL/ELT processes is recommended

- Some experience with BI and/or data visualization tools is helpful but not required

Outline

Data Warehousing with Databricks

Databricks Overview

Data Warehousing with Databricks
Unity Catalog Overview
Databricks SQL Warehouses
Demo: Databricks SQL Warehouses

Ingesting and Transforming Data

Data Ingestion Techniques
Data Transformation
Demo: Ingesting Data
Demo: Exploring Data

Orchestration

Introduction to Workflows
Demo: Exploring Workflow Capabilities

Monitoring

Tagging
System Tables
Cost Optimization

Visualization

Introduction to AI/BI
Demo: Creating and Managing a Dashboard
Lab: Creating a Dashboard Lab

Genie

Introduction to Genie
Demo: Creating Genie Spaces
Lab: Genie Spaces Lab

Power BI Integration

Power BI Integration
Star Schema Overview

Upcoming Public Classes

Date	Time	Your Local Time	Language	Price
Date	Time	Your Local Time	Language	Price	May 21	11 AM - 03 PM (Asia/Singapore)	-	English	$750.00
Jun 12	01 PM - 05 PM (Europe/London)	-	English	$750.00
Jun 16	08 AM - 12 PM (Asia/Kolkata)	-	English	$750.00
Jul 17	01 PM - 05 PM (Australia/Sydney)	-	English	$750.00
Jul 17	09 AM - 01 PM (America/New_York)	-	English	$750.00

Public Class Registration

If your company has purchased success credits or has a learning subscription, please fill out the Training Request form. Otherwise, you can register below.

Customer registration Partner registration

Private Class Request

If your company is interested in private training, please submit a request.

Request Private Training

See all our registration options

Upcoming Public Classes

Date	Time	Your Local Time	Language	Price
Date	Time	Your Local Time	Language	Price	May 21	11 AM - 03 PM (Asia/Singapore)	-	English	$750.00
Jun 12	01 PM - 05 PM (Europe/London)	-	English	$750.00
Jun 16	08 AM - 12 PM (Asia/Kolkata)	-	English	$750.00
Jul 17	01 PM - 05 PM (Australia/Sydney)	-	English	$750.00
Jul 17	09 AM - 01 PM (America/New_York)	-	English	$750.00

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

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: 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.

Building Reliable Conversational Agents with Genie

This course teaches you how to design, build, and maintain a Databricks Genie Space, a natural language interface that enables business users to ask questions about governed data and receive SQL-backed answers without writing code.

You will learn how Genie fits into the Databricks AI/BI product family and how it translates natural language into reliable SQL queries. The course focuses on what it takes to create a Genie Space that delivers accurate, consistent, and trustworthy results.

You will follow a complete end-to-end workflow, from understanding source data and defining benchmarks to configuring and refining a Genie Space using the full set of Knowledge Store curation tools. These include metadata, synonyms, prompt matching, SQL logic, example queries, and text instructions.

You will also learn how to share Genie Spaces with business users through Databricks One, understand how Unity Catalog governance is automatically enforced, and use monitoring and user feedback to continuously improve quality over time.

By the end of the course, you will be able to create and manage a production-ready Genie Space that delivers governed, self-service conversational analytics at scale.

Apache Spark Developer

Introduction to Apache Spark™

This course offers essential knowledge of Apache Spark, with a focus on its distributed architecture and practical applications for large-scale data processing. Participants will explore programming frameworks, learn the Spark DataFrame API, and develop skills for reading, writing, and transforming data using Python-based Spark workflows.

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