MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 94 Lectures ( 6h 43m ) | Size: 2.1 GB
Become a dbt™ professional with this ALL-IN-ONE COURSE covering both theory & practice through a real-world project!
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
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)
