The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero

Become a dbt professional with this ALL-IN-ONE COURSE covering both theory and practice through a real-world project!

Created by: Zoltan C. Toth
Data Analytics Architecture Expert

Created by: Miklos (Mike) Petridisz
Data Engineer & Solutions Architect Expert

What Will I 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
• Test your knowledge with certification preparation question
• Listen to real-world use-cases from industry professionals
• Learn dbt Orchestration Best Practices Hands On

Requirements

• Basic SQL experience
• No previous programming language experience required
• Working computer (Mac/Windows/Linux)
• Network access whitelist to snowflake(.com) and GitHub if you work behind a firewall or VPN
• Git and Python (We are linking to the installation instructions of these tools in the course)

Target audience

• Analytics Engineers
• Data Analysts
• BI Analysts
• Data Scientists
• Data Engineers