Course Outline
DBT is an open-source command line tool designed for data transformation in the context of data warehousing. This course equips data professionals with the skills to build and manage robust data pipelines using DBT, to achieve efficient data transformation and optimized ETL processes. Through lectures and hands-on exercises, participants will gain a comprehensive understanding of the core concepts, methodologies, and practical applications of DBT.
Upcoming Meetings
There are no upcoming meetings for this course. Contact us to schedule this course, which will be customized specifically for your organization.
info@hackerupro.comModules
Introduction to DBT
- Introduction to DBT
- key concepts
- Installation
- DBT project structure and environmentModeling with DBT
Modeling with DBT
- Models
- Materialization
- jinja
- Macros
- Hooks
- Seeds
- snapshots
Advanced Topics in DBT
- Testing
- Sources
- Variables
- Packages
- DBT run options
Prerequisites
- SQL – must
- Python – nice to have.
- Git – nice to have.