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.

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

Self-Paced

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

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

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.

Paid

Lab

Associate

Apache Spark Developer

Developing Applications with Apache Spark™

Master scalable data processing with Apache Spark in this hands-on course. Learn to build efficient ETL pipelines, perform advanced analytics, and optimize distributed data transformations using Spark’s DataFrame API. Explore grouping, aggregation, joins, set operations, and window functions. Work with complex data types like arrays, maps, and structs while applying best practices for performance optimization.

Apache Spark Developer

Stream Processing and Analysis with Apache Spark™

Learn the essentials of stream processing and analysis with Apache Spark in this course. Gain a solid understanding of stream processing fundamentals and develop applications using the Spark Structured Streaming API. Explore advanced techniques such as stream aggregation and window analysis to process real-time data efficiently. This course equips you with the skills to create scalable and fault-tolerant streaming applications for dynamic data environments.