The Complete dbt Bootcamp

Learn how to build, test, and deploy data models with dbt from scratch. This hands-on course covers everything from fundamentals to production workflows like testing, CI/CD, and Airflow. Ideal for analysts, engineers, and data professionals ready to take their dbt skills to the next level.

Bruno Souza de Lima

Taught by Bruno Souza de Lima

Data Engineer at phData

What you'll learn

Live sessions with recordings available
Certificate of completion
Weekly homeworks to reinforce learning
Q&A sessions
Access to an exclusive dbt community on Discord
Data Modeling and dbt Basics
Data quality with tests, unit tests and source freshness
Production workflows with state selectors, Airflow, and GitHub Actions

Learn directly from the experts

Bruno Souza de Lima

Bruno Souza de Lima

Data Engineer at phData

Course syllabus

8 lessons

Week 1 – Data Modeling and dbt Basics
1
Day 1: Data Modeling & Introduction to dbt
2
Day 2: dbt Models & Macros
Week 2 – dbt Basics (cont'd) and Data Quality
1
Day 1: Sources & Seeds & Snapshots
2
Day 2: dbt Tests
Week 3 – Incremental models & Observability
1
Day 1: Incremental Models & WAP
2
Day 2: Docs & Observability
Week 4 – dbt in production
1
Day 1: Orchestrating dbt with Airflow
2
Day 2: State & CI/CD

Before you join

Prerequisites

Basic SQL knowledge
Snowflake account (Trial account is ok)
Text Editor (VSCode or Cursor if possible)