What does the training include?
In this course, you will get a brief introduction to the modern ELT process, compared to the ETL process of the past. We will soon start building our own dbt project. You'll learn how dbt helps you structure SQL transformations, add tests, and generate documentation automatically. We'll discuss the differences between dbt Core and dbt Cloud, how to collaborate via git, and how dbt fits into CI/CD. Using practical exercises, you will build an end-to-end data model yourself and gain insight into how large organizations manage their analytics pipelines with dbt.
Global Program
Part 1: Introduction to the Modern Data Stack
Part 2: Your first dbt project (Setting up, configuring and running models).
Part 3: Testing and Documenting (Data Quality, Docs, and Lineage)
Part 4: Advanced features (Macros, Jinja, model dependencies.
Part 5: Integrating with git & CI/CD (Deployment and Collaboration)
Part 6: Best Practices & Q&A (Patterns, Tips and Next Steps)
For whom?
Data engineers, analytics engineers, BI specialists and data analysts who want to professionalize and automate their SQL transformations.
Basic knowledge of SQL
Some familiarity with data warehouses or data modeling is a plus.
