Mini dbt Bootcamp Starting on August 5th

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, and Airflow. Ideal for analysts, engineers, and data professionals ready to take their dbt skills to the next level.

• Recorded sessions (the live sessions already happened)
• Quizzes and Weekly homeworks to reinforce learning
• 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

Platform Access Included:

Discord

GitHub

PrerequisitesCurriculaSchedule

• Basic SQL Knowledge
• Snowflake Account (Trial is fine)
• Text Editor (VSCode or Cursor)

• Basic SQL Knowledge
• Snowflake Account (Trial is fine)
• Text Editor (VSCode or Cursor)

Main Content

Week 1: Foundations of dbt (6h)

• Day 1 - Analytics Engineering & Data Modeling (1h)
• Day 1 – What is dbt? + Quiz (1h)
• Day 2 – dbt Models, Macros & Seeds - part 1 (1h)
• Day 2 – dbt Models, Macros & Seeds - part 2 + Quiz (1h)
• Day 3 – Sources, Snapshots & Docs - part 1 (1h)
• Day 3 – Sources, Snapshots & Docs - part 2 + Quiz (1h)
• Aug 11th - Tech Talk - Jimish Kadakia (Snowflake)

Week 2: Testing, Incrementals & Production (6h)1.9 hrs

• Day 4 – Testing & Observability - part 1 (1h)
• Day 4 – Testing & Observability - part 2 + Quiz (1h)
• Day 5 – Incremental Models & WAP - part 1 (1h)
• Day 5 – Incremental Models & WAP - part 2 + Quiz (1h)
• Day 6 – dbt in Production - part 1 (1h)
• Day 6 – dbt in Production - part 2 + Quiz (1h)
• Aug 18th - Tech Talk - Zach Wilson