Mastering Dbt (Data Build Tool) - From Beginner To Pro
https://DevCourseWeb.com
Published 4/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.98 GB | Duration: 6h 46m
Analytics Engineering Bootcamp to take you from beginner to advanced dbt, and get hands-on with dbt Cloud!
What you'll learn
How to build a complete dbt project from scratch
The main benefits of dbt, and a bit of background as to how it came about
All of the dbt fundamentals: sources, models, tests, documentation, snapshots, seeds, macros, hooks, and operations
How to structure a dbt project
How to version control changes to your code with GitHub
Advanced dbt testing - creating your own custom singular & generic tests, setting severity, and setting warn/error thresholds
Advanced dbt data modelling - including incremental and ephemeral models and what type to use (& when)
Advanced dbt commands - how to use different selectors, different profiles, tags, indirect test selection and building a local dbt documents site
Advanced dbt jinja & macros - creating your own macros to use in hooks / functions / operations, using jinja for loops and variables, and the target function
How to deploy your project on dbt Cloud, how to use the dbt Cloud UI, and using environment variables
How to use tests & macros from external packages to supercharge your dbt project
Best practises to use when running a dbt project (based on lots of experience!)
How to create a complete setup for Mac or Windows: installing all of the tools and getting a dbt specific VSCode setup!
Requirements
Basic SQL
No Python experience needed
Mac / Windows machine which is capable of installing Python, Git, and VSCode (we'll run through all of this in the course!)