2025 Mastering dbt (Data Build Tool) - From Beginner to Pro

Overview

A complete course to help anyone with basic SQL skills learn advanced dbt, a key tool for Analytics Engineering!

Syllabus

• Introduction to dbt
Overview of dbt and its place in the modern data stack
Installation and setup
Basic concepts: models, seeds, sources
• dbt Fundamentals
Understanding the dbt workflow
Project structure and creating your first dbt models
Using the dbt command line interface
• SQL and Jinja Basics
SQL review and best practices for Analytics Engineering
Introduction to Jinja templating in dbt
Variables and macros
• Building Models
Creating and managing models in dbt
Materializations: table, view, and ephemeral
Configuring incremental models
• Testing and Documentation
Writing and managing tests in dbt
Configuring and generating documentation
Using dbt docs and exposure
• Data Validation and Quality
Implementing data tests for accuracy and reliability
Custom data testing frameworks
• Advanced dbt Features
Using snapshots for slowly changing dimensions
Modularity with packages and refactoring projects
Deployment best practices and version control
• Debugging and Optimization
Identifying and resolving performance bottlenecks
Advanced debugging techniques
• dbt Cloud and CI/CD
Setting up and configuring dbt Cloud
Continuous Integration & Continuous Deployment workflows
Managing dbt environments
• Real-world Use Cases
Case studies across industries
Networking and community best practices
• Capstone Project
Designing and implementing a complete dbt workflow
Presentation and peer review of projects

Taught by

Jack Colsey

Subjects

Business