AboutTeamsPricing
New content added weeklyLive

Master dbt with Adaptive AI.

Master dbt across 14 topics - Foundations, Intermediate Patterns, and Production and Advanced - guided by Leyaa's adaptive intelligence.

3Parts
14Topics
86Patterns
20hEst. duration
Start Learning Free
dbt
dbt Course
3 - part learning journey
Beginner
Foundations
5 topics · 31 patterns
Beginner
Intermediate
Intermediate Patterns
5 topics · 31 patterns
Intermediate
Advanced
Production and Advanced
4 topics · 24 patterns
Advanced
Begin Part 1: Foundations
✦ Course Structure

Your dbt Journey in 3 Parts

Each part builds on the last - a deliberate progression from beginner to advanced.

Beginner
Beginner
Part 1: Foundations
Covers dbt Fundamentals, Models, Sources and Seeds and 2 more topics.
5Topics
31Patterns
View topics
Intermediate
Intermediate
Part 2: Intermediate Patterns
Covers Jinja in dbt, Incremental Models, Advanced Testing and 2 more topics.
5Topics
31Patterns
View topics
Advanced
Advanced
Part 3: Production and Advanced
Covers Production Deployment, Performance Optimization, Advanced Patterns and 1 more topic.
4Topics
24Patterns
View topics
Curriculum

Everything You'll Learn

Explore every topic and pattern in the course.

dbt

3 parts · 14 topics · 86 patterns
Beginner
Part 1: Foundations5 topics · 31 patterns
Beginner
01
dbt Fundamentals
6 patterns
What is dbt
Why dbt transformed data transformation workflows
dbt Core vs dbt Cloud
How dbt works (SQL + Jinja + YAML)
dbt project structure
Installing and initializing a dbt project
02
Models
7 patterns
Why models are the core of dbt
Creating your first model
ref() function for model dependencies
Materializations (view, table, incremental, ephemeral)
Model naming conventions
Organizing models in directories
Building a DAG of models
03
Sources and Seeds
6 patterns
Why sources define raw data contracts
Configuring sources in YAML
source() function for raw tables
Source freshness checks
Seeds for static reference data
Loading CSV seeds
04
Testing
6 patterns
Why testing ensures data quality
Built-in tests (unique, not_null, accepted_values, relationships)
Custom singular tests
Testing model outputs
Running tests with dbt test
Test severity levels
05
Documentation
6 patterns
Why documentation makes data discoverable
Documenting models in YAML
Column descriptions
Generating documentation site
Doc blocks for reusable descriptions
dbt docs serve
Intermediate
Part 2: Intermediate Patterns5 topics · 31 patterns
Intermediate
01
Jinja in dbt
7 patterns
Why Jinja makes SQL dynamic
Variables and control flow
if/else logic in models
For loops for dynamic SQL
Macros for reusable SQL logic
Calling macros across projects
Built-in Jinja context variables
02
Incremental Models
6 patterns
Why incremental models save time and cost
is_incremental() macro
Unique key for merge behavior
Incremental strategies (append, merge, delete+insert)
Handling late-arriving data
Full refresh vs incremental
03
Advanced Testing
6 patterns
Why advanced testing catches subtle data issues
Generic tests with parameters
dbt-utils package tests
dbt-expectations for data quality
Unit testing dbt models
Store test failures for analysis
04
Packages and Reusability
6 patterns
Why packages accelerate dbt development
Installing packages with packages.yml
dbt-utils (surrogate_key, pivot, unpivot)
dbt-date for date spine
Creating your own dbt package
Version pinning and updates
05
Project Organization
6 patterns
Why project structure scales with team size
Staging, intermediate, and marts pattern
One model per source table rule
Naming conventions at scale
Tags and selectors for partial runs
dbt_project.yml configuration
Advanced
Part 3: Production and Advanced4 topics · 24 patterns
Advanced
01
Production Deployment
6 patterns
Why production dbt needs automation
dbt Cloud deployment
Orchestrating dbt with Airflow
dbt in CI/CD pipelines
Slim CI with state comparison
Environment management (dev, staging, prod)
02
Performance Optimization
6 patterns
Why optimization reduces warehouse costs
Materializations strategy
Clustering and partitioning
Query profiling and optimization
Model dependencies and parallelism
Warehouse-specific optimizations
03
Advanced Patterns
6 patterns
Why advanced patterns solve complex analytics
Slowly changing dimensions (SCD Type 2)
Snapshot tables for historical tracking
Semi-structured data handling (JSON)
Multi-source fan-in patterns
Metric definitions and semantic layer
04
Governance and Collaboration
6 patterns
Why governance ensures data trust
Model contracts and access controls
Group-based ownership
PR review workflows for dbt changes
Data mesh patterns with dbt
Cross-team model sharing
Why Leyaa

Not just a course. A learning intelligence.

Leyaa doesn't just deliver content - it understands where you are, what you need, and how to get you there fastest.

Adaptive Diagnostics
Adaptive Diagnostics
Leyaa identifies which of the 86 patterns you've mastered and which need work - before you waste time on what you already know.
Pattern-Level Precision
Pattern-Level Precision
Every pattern gets a verdict - Learn, Practice, or Skip - so your study time goes exactly where it counts.
Intelligent Pacing
Intelligent Pacing
Leyaa reads your velocity across the whole course and adapts your focus list dynamically, keeping you in the optimal learning zone.
Before & After Visibility
Before & After Visibility
Every assessment creates a snapshot. Retake anytime to see exactly how much you've grown - topic by topic, pattern by pattern.
Learner Autonomy
Learner Autonomy
Leyaa recommends, never restricts. Override any suggestion and explore at your own pace - the system tracks everything regardless.
Clear Learning Path
Clear Learning Path
Foundations → Intermediate Patterns → Production and Advanced - a structured journey where each part sets you up perfectly for the next.
dbt

Ready to master dbt?
Start your journey today

Start your diagnostic now. Build mastery across all 14 topics in under 15 minutes.

14 Topics
86 Patterns
Personalized roadmap
Leyaa Swift Bird