Share Description
In this course, you will :
- Learn how to utilise the dbtTM platform professionally by creating a comprehensive, real-world, hands-on dbt - Airbnb project that covers both Theory and Practise.
- Install the complete development environment on both Mac and Windows. Connect to Snowflake and Business Intelligence. Configure the dbt profile and add dbt tools to the IDE.
- Learn key dbt concepts like Models, Materialisation, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, and Analyses, as well as how to write complicated SQL queries.
- Learn about dbt tips and tricks, advanced approaches and best practises, and how to extend dbt using your own / third-party macros.
- Implement singular and generic dbt tests, deal with extra parameters and default config values, and customise built-in dbt tests.
- Document your models and pipeline, personalise the dbt docs page, and investigate and understand transformation step dependencies.
- Learn about the stages of the Data-Maturity Model and well-functioning Data Architectures, as well as how dbt fits into the current data stack.
- ETL/ELT procedures, Data Transformations, Modern Data Stack, Slowly Changing Dimensions, Common Table Expressions, and Analytics Engineering are all covered.
- Understand the differences between a Data Warehouse, Data Lake, and Data Lakehouse and when to utilise each, as well as how to handle Data Collection, Data Wrangling, and Data Integrations.
- See how advanced testing works using dbt-expectations, a testing framework inspired by Great Expectations.
Syllabus :
- Theory - The Data Maturity Model
- Theory - Data Warehouses, Data Lakes and Lakehouses
- Theory - The Modern Data Stack
- Theory - Slowly Changing Dimension (SCD)
- Intro to the practical sessions: dbt and the Airbnb use-case
- Practice - Setup
- Models
- Materializations
- Seeds and Sources
- Snapshots
- Tests
- Macros, Custom Tests and Packages
- Documentation
- Analyses, Hooks and Exposures
- dbt Hero
- Debugging Tests and Testing with dbt-expectations
- Best Practices for Introducing and Using dbt in your Company
- dbt Certification Exam Preparation Guide
- Supplementary Materials
