Learn about the reasons behind dbt's existence and how it's used to create data transformation projects.
Get into the true substance of dbt by working with data models and creating SQL based models within dbt. Learn about basic SQL models, define dependencies, update, and troubleshoot various model issues.
Learn to take advantage of data validation in dbt using tests. Apply default tests to various models and properties, then create custom tests to handle specialized logic validation. Learn to document various details of dbt models and generate lineage information automatically.
Utilize what you've learned about dbt with some added details to implement dbt in a production environment. We'll cover dbt seeds and snapshots, along with how to automate builds. Finally review what you've learned throughout the course and implement a dbt pipeline.