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	Language	Price
Date	Time	Language	Price	Jul 24	01 PM - 05 PM (America/New_York)	English	$750.00
Aug 19	09 AM - 01 PM (America/New_York)	English	$750.00
Aug 20	09 AM - 01 PM (Europe/London)	English	$750.00
Aug 21	01 PM - 05 PM (Australia/Sydney)	English	$750.00
Sep 02	01 PM - 05 PM (America/New_York)	English	$750.00
Sep 03	09 AM - 01 PM (Europe/London)	English	$750.00
Sep 04	09 AM - 01 PM (Asia/Kolkata)	English	$750.00
Sep 29	01 PM - 05 PM (Europe/London)	English	$750.00
Sep 30	01 PM - 05 PM (Asia/Kolkata)	English	$750.00
Oct 01	09 AM - 01 PM (Asia/Kolkata)	English	$750.00
Oct 01	09 AM - 01 PM (America/New_York)	English	$750.00
Oct 02	09 AM - 01 PM (Europe/London)	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

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

Data Engineer

Databricks Performance Optimization

In this course, you’ll learn how to optimize workloads and physical layout with Spark and Delta Lake and and analyze the Spark UI to assess performance and debug applications. We’ll cover topics like streaming, liquid clustering, data skipping, caching, photons, and more.

Note: This course is part of the 'Advanced Data Engineering with Databricks' course series.

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

Data Analysis with Databricks

This course provides a comprehensive introduction to Databricks SQL. Learners will ingest data, write queries, produce visualizations and dashboards, and configure alerts. This course will prepare you to take the Databricks Certified Data Analyst Associate exam.

This course consists of two four-hour modules.

SQL Analytics on Databricks

In this course, you'll learn how to effectively use Databricks for data analytics, with a specific focus on Databricks SQL. As a Databricks Data Analyst, your responsibilities will include finding relevant data, analyzing it for potential applications, and transforming it into formats that provide valuable business insights.

You will also understand your role in managing data objects and how to manipulate them within the Databricks Data Intelligence Platform, using tools such as Notebooks, the SQL Editor, and Databricks SQL.

Additionally, you will learn about the importance of Unity Catalog in managing data assets and the overall platform. Finally, the course will provide an overview of how Databricks facilitates performance optimization and teach you how to access Query Insights to understand the processes occurring behind the scenes when executing SQL analytics on Databricks.

AI/BI for Data Analysts

In this course, you’ll learn how to use the features Databricks provides for business intelligence needs: AI/BI Dashboards and AI/BI Genie. As a Databricks Data Analyst, you will be tasked with creating AI/BI Dashboards and AI/BI Genie Spaces within the platform, managing the access to these assets by stakeholders and necessary parties, and maintaining these assets as they are edited, refreshed, or decommissioned over the course of their lifespan. This course intends to instruct participants on how to design dashboards for business insights, share those with collaborators and stakeholders, and maintain those assets within the platform. Participants will also learn how to utilize AI/BI Genie Spaces to support self-service analytics through the creation and maintenance of these environments powered by the Databricks Data Intelligence Engine.

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

Apache Spark Developer

Monitoring and Optimizing Apache Spark Workloads on Databricks

This course explores the Lakehouse architecture and Medallion design for scalable data workflows, focusing on Unity Catalog for secure data governance, access control, and lineage tracking. The curriculum includes building reliable, ACID-compliant pipelines with Delta Lake. You'll examine Spark optimization techniques, such as partitioning, caching, and query tuning, and learn performance monitoring, troubleshooting, and best practices for efficient data engineering and analytics to address real-world challenges.

Languages Available: English | 日本語