Data Modeling Strategies

This course walks practitioners through the full spectrum of data modelling approaches on the Databricks Data Intelligence Platform - from classical data warehouse techniques (Inmon, Kimball, Data Vault 2.0), through Feature Store-driven ML use cases, to productising data via Data Products on Unity Catalog.

Each modelling approach is introduced with a lecture, then reinforced with a hands-on demo against a shared dataset (TPC-H samples). The course finishes with a comprehensive end-to-end lab that exercises ERM, dimensional modelling, Data Vault 2.0, and the Feature Store in a single integrated workflow.

Note:

1. The course includes practice labs that the learners should perform after going through the entire course.

2. 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 | 日本語 | Português BR | 한국어

Skill Level

Associate

Duration

Prerequisites

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

• Working knowledge of SQL and relational database concepts

• Familiarity with Databricks fundamentals (workspaces, notebooks, Unity Catalog basics)

• Conceptual understanding of OLTP vs OLAP and the medallion architecture

• Basic exposure to Python and PySpark is helpful but not required

• Awareness of dimensional modelling concepts is helpful but not required

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

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.

Paid & Subscription

Lab

Associate

Data Warehousing Practitioner

Data Interoperability with Unity Catalog

This course explores how to achieve data interoperability between systems using Databricks Unity Catalog as a unified governance layer, using both Delta and Iceberg open table formats. Participants will learn to implement, manage and optimize a data environment where tables can be accessed by both Delta and Iceberg clients, enabling cross-platform analytics and eliminating data silos.

This course is designed for Data Engineers, Platform Administrators, and Analytics Engineers responsible for implementing and managing multi-format data architectures. You will gain the skills to use Unity Catalog for unified governance across Delta and Iceberg table formats and across federated external systems.

Paid & Subscription

Lab

Associate

Architecting Data Warehouses for Large-Scale Deployments

This course covers performance optimization, cost control, and security for large-scale data warehousing deployments.This course is designed for Data Warehousing practitioners responsible for managing Databricks environments serving hundreds or thousands of users across multiple business units. You will gain the skills necessary to efficiently scale data warehousing operations while maintaining high performance, cost-effectiveness, and compliance with security standards.

Paid & Subscription

Lab

Associate