dbt Fundamentals

Learn the Fundamentals of dbt including modeling, sources, testing, documentation, and deployment.

Welcome to dbt Fundamentals (4 minutes)

Welcome! Frequently Asked Questions

Who is an analytics engineer? (20 minutes)

Learning Objectives Traditional Data Teams ETL and ELT Analytics Engineer The modern data stack and dbt Overview of an exemplar project Review

Set up dbt Cloud (17 minutes)

Learning Objectives dbt, databases, and version control Loading training data into your warehouse Create dbt Cloud account and GitHub repository Connect to your warehouse and repository dbt Cloud IDE Overview Overview of dbt Cloud UI Review

Models (28 minutes + exercise)

Learning Objectives What are models? Building your first model What is modularity? Modularity and the ref functions Quick history of data modeling Naming conventions Reorganize your project Practice Exemplar Review

Sources (12 minutes + exercise)

Learning Objectives What are sources? Configure and select from sources Source freshness Practice Exemplar Review

Tests (17 minutes + exercise)

Learning Objectives Why testing? What is testing? Generic tests Singular tests Testing sources Practice Exemplar Review

Documentation (16 minutes + exercise)

Learning Objectives (16 minutes) Why is documentation important? What is documentation? Writing documentation and doc blocks Documenting sources Generate and view documentation Practice Review

Deployment (11 minutes + exercise)

Learning Objectives What is deployment? Setting up a dbt Cloud job Reviewing a dbt Cloud job Review

Quiz, Survey, and Next Steps (30 minutes)

Preparing for the quiz Quiz Quick Survey Congratulations on completing dbt Learn Fundamentals

Get started

Start free Schedule a demo

*