Skip to main content

Get Started with Databricks for Data Warehousing

This course provides a comprehensive, hands-on overview of Databricks' modern approach to data warehousing, highlighting how a data lakehouse architecture combines the strengths of traditional data warehouses with the flexibility and scalability of the cloud. Working end-to-end with a fictional retailer (Vintage Audio Co.), you will explore the workspace, query governed Unity Catalog tables, keep Unity Catalog managed tables fast for analytical reads, load data incrementally with Auto Loader, model a star schema, and deliver consistent insights through Unity Catalog metric views — all from a single, governed environment, with AI-driven features (Predictive Optimization, Genie Code) built in throughout.


You can create a Databricks Free Edition account and try the follow-along demos in a hands-on environment.


Languages Available: English | 日本語 | Português BR| 한국어 | Español | française

Skill Level
Onboarding
Duration
2h
Prerequisites

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

• Basic familiarity with the data warehousing domain (what a data warehouse, a table, and BI tools are).

• Working knowledge of SQL (SELECT with WHERE, GROUP BY, aggregate functions, and JOIN).

• No prior Databricks knowledge is assumed; Databricks-specific concepts (Unity Catalog, Delta Lake, SQL Warehouses, metric views) are introduced as they come up.

Outline

• Databricks Data Intelligence Platform

• Demo: Databricks Workspace Walkthrough

• Demo: Querying the Vintage Audio Warehouse

• Lab: Explore the Vintage Audio Tables

• Demo: Tuning Unity Catalog managed Tables for Analytical Queries

• Lab: Optimize the Products Table

• Demo: Loading Data into the Warehouse

• Lab: Incrementally Load New Orders

• Demo: Building a Star Schema

• Lab: Build a Store Dimension

• Demo: Deliver Insights with Metric Views

• Lab: Create a Metric View for Store Performance

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.

Private Class Request

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

See all our registration options

Registration options

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

Runtime

Self-Paced

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

Register now

Instructors

Instructor-Led

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

Register now

Learning

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

Scale

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

Catalog Management and Data Organization

In this course, you will learn how to design, implement, and govern catalog structures and large-scale data organization on the Databricks Data Intelligence Platform. It offers a comprehensive view of Unity Catalog as the centralized governance layer for an enterprise lakehouse. Divided into five modules, it begins by placing Unity Catalog within the cloud deployment model — covering the Account Console, metastore creation, and the administrator role hierarchy. You will then translate organizational topology (business units, regions, and dev/QA/prod environments) into a scalable catalog and schema design using naming conventions, ownership patterns, and MANAGE delegation. The course then covers secure storage integration with storage credentials, external locations, the managed-storage hierarchy, managed versus external tables, and UC Volumes for non-tabular data. Next, you will apply access patterns and isolation strategies — the three-level GRANT chain, workspace-catalog binding, and schema-level Attribute-Based Access Control (ABAC) policies — to enforce fine-grained data protection at scale. Finally, the course closes with best practices for catalog design, automation, least-privilege permissions, and group-based access management.

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.

Free
2h
Associate

Questions?

If you have any questions, please refer to our Frequently Asked Questions page.