The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero
Learn Analytics Engineering with this dbt™ course covering theory & practice through a real-world Airbnb use case.
Created by Zoltan C. Toth, Miklos (Mike) Petridisz | 6 hours on-demand video course
Become a dbt professional from scratch with this single course, solving a real-world problem step by step! We cover both theory and hands-on practice! Delivered by an instructor with 20+ years of Data Engineering experience
Greetings to the MOST COMPLETE, CONTINUOUSLY UPDATED independent dbt™ (Data Build Tool) software course in the world – as of 2024! This The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero course is the TOP RATED and the BESTSELLER dbt course on Udemy!
Thank you for joining us for The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero – we are super excited to have you in the course!
The Complete dbt (Data Build Tool) Bootcamp Course
The structure of the course is designed to have a top-down approach. It starts with the Analytics Engineering Theory – all you need to know is to put dbt (Data Build Tool) in context and to have an understanding of how it fits into the modern data stack. We start with the big picture; then, we go deeper and deeper. Once you learn about the pieces, we are going to shift to the technicalities – a practical section -, which will focus on putting together the dbt “puzzle”. The practical section will cover each and every single dbt feature present today through the construction of a complete, real-world project; Airbnb. This presents an opportunity for us to show you which features should be used at what stage in a given project, and you will see how dbt is used in the industry.
Fully pastable course materials on GitHub and lecture notes added about common pitfalls in dbt setup – Jan 2023
Added Great Expectations and test debugging sections – Sep 2022
Radically simplified Windows installation instructions (no WSL needed anymore) – Sep 2022
The course is tested in dbt cloud – Aug 2022
Added Modern Data Stack overview – Jun 2022
What you’ll learn
- Learn to use the dbt™ platform professionally through the creation of an exhaustive, real-world, hands-on dbt – Airbnb project covering both Theory and Practice
- Set up the complete development environment on Mac & Windows, Connect to Snowflake and BI, Configure dbt profile, extend the IDE with dbt tools
- Learn core dbt concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses, write complex SQL queries
- Understand the dbt project structure and learn about dbt tips & tricks, advanced techniques and best practices, extend dbt with your own / third-party macros
- Implement singular and generic dbt tests, work with additional arguments and default config values, customize dbt built-in tests
- Document your models and pipeline, customize the dbt docs page, Explore and analyse dependencies between transformation steps
- Understand how dbt fits into the modern data stack, learn about the stages of the Data-Maturity Model, and well functioning Data Architectures
- Master ETL/ELT procedures, Data Transformations, Modern Data Stack, Slowly Changing
- Dimensions, Common Table Expressions and Analytics Engineering
- Understand what is a Data Warehouse, Data Lake, or Data Lakehouse and when to use which, handle Data Collection, Data Wrangling and Data Integrations
- See how advanced testing works using dbt-expectations, a Great Expectations inspired testing framework
Recommended dbt (Data Build Tool) Course
2024 Mastering dbt (Data Build Tool) – From Beginner to Pro
dbt Data Build Tool Masterclass – Complete Guide to dbt
dbt (Data Build Tool): Go PRO in 4 hours
Who this course is for:
- Analytics Engineers
- Data Analysts
- BI Analysts
- Data Scientists
- Data Engineers