Udemy – 2024 Mastering dbt (Data Build Tool) – From Beginner to Pro 2024-2

Published on: 2024-09-02 22:54:50

Categories: 28

Descriptions

2024 Mastering dbt (Data Build Tool) – From Beginner to Pro, This course runs through everything from the theory behind dbt to building an advanced dbt project (from scratch) and deploying it on dbt Cloud. I have over 8 years of experience across Analytics / Analytics Engineering / Data Science, including 4 years using dbt on a daily basis. I was also involved in the rollout of dbt in my time at Monzo Bank. In this course I’ve taken everything I’ve learnt over the past 4 years, and what I use on a daily basis, and condensed it to take anyone who knows SQL to an advanced level of dbt as quickly as possible. We’ll cover everything you need to know about dbt: from the basic data modelling right through to all of the advanced features such as creating custom tests and macros. We’ll be doing this step by step, and build from the basics upwards. It’s focused on practical outcomes – we won’t be spending ages on database theory, or going into lots of detail on the eCommerce dataset we’ll be using, instead we’ll be aiming to get you up to advanced dbt levels as quickly as possible. For every video where we’re writing code, I’ve created lesson attachments with the final outputs. This means you can either code as you go along, or watch the videos and look at the handouts afterwards! I’ve also included some theory with these handouts to help hammer home the points made in the videos.

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: staging, intermediate, and mart models – and naming conventions
How to version control changes to your code with GitHub and VSCode
Advanced dbt testing – creating your own custom singular & generic tests, setting severity, and setting warn/error thresholds
Advanced dbt data modelling – model materialisation and governance (access, contracts, and versions)
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

Who this course is for

Data Analysts
Data Scientists
Analytics Engineers
Data Engineers
BI Professionals
Anyone interested in getting into data!

Specificatoin of 2024 Mastering dbt (Data Build Tool) – From Beginner to Pro

Publisher : Udemy
Teacher : Jack Colsey
Language : English
Level : All Levels
Number of Course : 107
Duration : 7 hours and 26 minutes

Content of 2024 Mastering dbt (Data Build Tool) – From Beginner to Pro

2024 Mastering dbt (Data Build Tool) - From Beginner to Pro

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!)