dbt Fundamentals

Learn the Fundamentals of dbt including modeling, sources, testing, documentation, and deployment. (approximately 5 hours)

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 Check for Understanding - Analytics Engineer

Set up dbt Cloud (17 minutes)

Learning Objectives dbt, data platforms, and version control Setting up dbt Cloud and your data platform dbt Cloud IDE Overview Overview of dbt Cloud UI Review CFU - Set up dbt Cloud

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 CFU - Models

Sources (12 minutes + exercise)

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

Tests (17 minutes + exercise)

Learning Objectives Why testing? What is testing? Generic tests Singular tests Testing sources The dbt Build command Practice Exemplar Review CFU - Tests

Documentation (16 minutes + exercise)

Learning Objectives Why is documentation important? What is documentation? Writing documentation and doc blocks Documenting sources Generate and view documentation Practice Review CFU - Documentation

Deployment (11 minutes + exercise)

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

Survey and Next Steps (30 minutes)

Quick Survey Congratulations on completing dbt Learn Fundamentals

Get started

Start free Schedule a demo