Courses
Level up your dbt™ skills on your own time with dbt Fundamentals.
dbt Fundamentals
Learn the Fundamentals of dbt including modeling, sources, testing, documentation, and deployment. (approximately 5 hours)
Semantic Layer
Learn how to define metrics with the dbt Semantic Layer and query the dbt Semantic Layer in downstream tools to optimize governance and productivity for your data and business teams. (approximately 2.5 hours)
Tableau BETA: Querying the Semantic Layer
Learn how to query the dbt Semantic Layer in Tableau to optimize governance and productivity for your data and business teams. (approximately 45 min)
Mode: Querying the Semantic Layer
Learn how to query the dbt Semantic Layer in Mode to optimize governance and productivity for your data and business teams. (approximately 45 min)
Hex: Querying the Semantic Layer
Learn how to query the dbt Semantic Layer in Hex to optimize governance and productivity for your data and business teams. (approximately 45 min)
Webhooks
Learn how to accelerate and automate workflows using webhooks with dbt Cloud (approximately 1 hour)
Jinja, Macros, Packages
Extend the functionality of dbt with Jinja/macros and leverage models and macros from packages. (approximately 2 hours)
Advanced Materializations
Learn about the advanced materializations built into dbt Core - ephemeral models, incremental models, and snapshots. (approximately 2 hours)
Refactoring SQL for Modularity
Learn with the analytics engineers of dbt Labs how to migrate legacy transformation code into modular dbt data models. Useful if you're porting stored procedures or SQL scripts into your dbt project. (approximately 3.5 hours)
Analyses and Seeds
Leverage analyses for ad hoc queries with dbt code and seeds for incorporating version controlled CSV data in your project. (approximately 1 hour)
Advanced Testing
Learn more about the theory of data testing and the practice of creating custom generic tests, leveraging tests in packages, and applying test configurations. (approximately 4 hours).
Advanced Deployment with dbt Cloud
Learn how to deploy your dbt Cloud project with advanced functionality including continuous integration, orchestrating conflicting jobs, and customizing behavior by environment. (approximately 4 hours)
dbt Cloud and BigQuery for Developers
Get the right role in BigQuery, join a dbt Cloud project, and start developing! (approximately 40 mins).
dbt Cloud and Databricks for Developers
Get the right role in Databricks, join a dbt Cloud project, and start developing! (approximately 40 mins)
dbt Cloud and Snowflake for Developers
Get the right role in Snowflake, join a dbt Cloud project, and start developing! (approximately 40 mins)
dbt Cloud and Redshift for Developers
Get the right role in Redshift, join a dbt Cloud project, and start developing! (approximately 40 mins).
dbt Cloud and BigQuery for Admins
Set up BigQuery, dbt Cloud, and Github, and add new developers to dbt Cloud projects. (approximately 60 minutes)
dbt Cloud and Databricks for Admins
Set up Databricks, dbt Cloud, and Github, and add new developers to dbt Cloud projects. (approximately 60 mins)
dbt Cloud and Snowflake for Admins
Set up Snowflake, dbt Cloud, and Github, and add new developers to dbt Cloud projects. (approximately 60 minutes)
dbt Cloud and Redshift for Admins
Set up Redshift, dbt Cloud, and Github, and add new developers to dbt Cloud projects. (approximately 1 hour)