A practical two day course for participants who are new to dbt and want to understand the foundations of SQL based data transformation. The agenda introduces the dbt workflow, project structure, models, sources, dependencies, testing, documentation, and basic development practices. The course focuses on building a clear understanding of how dbt organizes transformation logic and supports more structured and maintainable analytics workflows.
You will learn how dbt is used to transform data with SQL and organize transformation logic into clear, reusable models. You will understand how projects, sources, dependencies, tests, and documentation work together in a basic dbt workflow. You will also learn the core commands and development habits needed to create, run, validate, and maintain a simple dbt project.
*We customize the course outline and content to your specific needs and relevant use cases.
Module 1: Introduction to dbt and the transformation workflow
Module 2: Setting up and navigating a dbt project
Module 3: Creating your first dbt models
Module 4: Dependencies, ref(), and basic materializations
Module 5: Working with data sources
Module 6: Basic testing and data quality checks
Module 7: Documentation and project understanding
Module 8: Basic dbt development workflow
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.