Hear from some of our learners

  

”
As a Data Analytics Manager aspiring to transition into Analytics Engineering, this dbt course was incredibly useful, offering a great mix of theoretical knowledge and hands-on application. It provided a comprehensive overview of dbt and its powerful capabilities, giving me the essential skills to confidently advance in the field. I highly recommend it for anyone looking to learn more about dbt and hit the ground running in analytics engineering.
Moritz Fernholz

 

”
Thank you, Rahul. This course gave me foundational knowledge of building a data warehouse from scratch to enable business intelligence. I was able to follow the course and was completely immersed and made sure to understand all that was taught. I love the experience. Thank you for the effort you put into organizing and putting this boot camp course together.
Chisom N

 

”
Such a great course. I have been able to apply a lot of these methods in my day to day responsibilities at work as a supply chain analyst. This course shows you why it's important to model your data and document your process.
Cristian R.

 

”
I didn't know much about dbt before starting this course, but after going through it I now know so much about it, including best practices and how dbt works in real life. It really helped me at my job Thanks Rahul :)
NH

 

”
The introduction and course overview sections presented was excellent! Am confident that this course provide 100x much more value than the cost of the course.
Lai Kim Lung

 

Career Advancement

Equip yourself with in-demand skills that employers are actively seeking. Learn to build and manage dbt projects from scratch, mirroring real-world applications.

Master Data Build Tool (dbt)

Discover the ins and outs of dbt with our comprehensive masterclass. From basics to advanced techniques, become a dbt pro in no time with our production-ready strategy.

Get Practical Skills

Master the skills you need to excel in your career. Enroll now enhance your productivity to unlock your full potential.

data build tool masterclass tier one pricing

Jumpstart - For learners testing the waters.

- Full access to the dbt Masterclass - 59 Chapters (327 Lessons) - 350 quizzes to practice - Step by step real-world scenarios - Proven techniques to help you build clean, efficient, and scalable data models - Hands-on sessions - Pro tips & best practices to avoid common pitfalls

Data build tool masterclass tier 2 pricing

Growth Mode - The best of both worlds.

- Full access to the dbt Masterclass - 59 Chapters (327 Lessons) - 350 quizzes to practice - Step by step real-world scenarios - Proven techniques to help you build clean, efficient, and scalable data models - Hands-on sessions - Pro tips & best practices to avoid common pitfalls - 3 Months free access to dbt practice test packs 2 & 3 - CV Review 

data built tool masterclass tier 3 pricing

Career Accelerator - Best value long-term career transformation.

- 2 day free trial - Full access to the dbt Masterclass - 59 Chapters (327 Lessons) - 350 quizzes to practice - Step by step real-world scenarios - Proven techniques to help you build clean, efficient, and scalable data models - Hands-on sessions - Pro tips & best practices to avoid common pitfalls - 3 Months free access to dbt practice test packs 2 & 3 - CV Review  - Recruiter Referral - 1 on 1 Free Session*

Meet Your Instructor: Rahul Prasad

"I'm here to guide you through the world of data transformation and help you harness the power of dbt. Let's embark on this journey together and revolutionise the way you work with data."

What You'll Learn in Our DBT Masterclass

59 Chapters · 328 Lessons

  1. 1

    Introduction to dbt masterclass

    1. (Included in full purchase)

      📌 Welcome to dbt masterclass

    2. (Included in full purchase)

      Tips on getting the best out of this course

    3. (Included in full purchase)

      Important: Refund Policy and Access to GitHub Repository

    4. (Included in full purchase)

      Important: Access to Slides and Proprietary Materials

  2. 2

    Course Resources

    1. (Included in full purchase)

      Important Please Read - Course Resources

    2. (Included in full purchase)

      Level 1 - Module 3 - Setup & Installation (Resources)

    3. (Included in full purchase)

      Level 1 - Module 3 - Setting Up BigQuery Environment (Resource)

    4. (Included in full purchase)

      Level 1 - Module 4 - Seeds source file (Resource)

    5. (Included in full purchase)

      Level 2 - Module 5 - BigQuery Scripts for Materialisation (Resources)

    6. (Included in full purchase)

      Level 2 - Module 8 - BigQuery Scripts for Use-Case Implementation (Resources)

    7. (Included in full purchase)

      Level 3 - Module 10 - Production Deployment Workflow Diagram (Resources)

  3. 3

    Level 1 - Building the Foundations: Data Concepts & dbt Basics

    1. (Included in full purchase)

      Introduction to Level 1 & Modules

  4. 4

    Level 1 - Module 1 - Introduction

    1. (Included in full purchase)

      Module 1 - Fundamental Concepts (Introduction)

  5. 5

    Level 1 - Module 1 - Introduction to Databases & Data Warehouses

    1. (Included in full purchase)

      Database vs DataWarehouse

    2. (Included in full purchase)

      Benefits of Data Warehouse

    3. (Included in full purchase)

      Introduction to BigQuery

    4. (Included in full purchase)

      BigQuery Interface Walkthrough

    5. (Included in full purchase)

      Quiz - Level 1 -Module 1

  6. 6

    Level 1 - Module 1 - SQL Basics

    1. (Included in full purchase)

      What is SQL?

    2. (Included in full purchase)

      Basic SQL Structure

    3. (Included in full purchase)

      Important SQL Commands

    4. (Included in full purchase)

      SQL JOINS Introduction

    5. (Included in full purchase)

      DML Merge Explained

    6. (Included in full purchase)

      DML Merge Example

    7. (Included in full purchase)

      Quiz - Level 1 - Module 1 - SQL Basics

  7. 7

    Level 1 - Module 1 - Data Modelling & Architecture

    1. (Included in full purchase)

      Data Model vs Data Modelling Overview

    2. (Included in full purchase)

      Data Warehouse Architecture

  8. 8

    Level 1 - Module 1 - Command-Line Basics

    1. (Included in full purchase)

      Terminal Introductions

    2. (Included in full purchase)

      What is Terminal

    3. (Included in full purchase)

      Important Terminal Commands

    4. (Included in full purchase)

      Terminal Hands-On Explained

    5. (Included in full purchase)

      Quiz - Level 1 - Module 1 - Command-Line Basics

  9. 9

    Level 1 - Module 1 - Version Control with Git

    1. (Included in full purchase)

      Version Control Introduction

    2. (Included in full purchase)

      Version Control Scenarios

    3. (Included in full purchase)

      Version Control Summary

    4. (Included in full purchase)

      What is Git?

    5. (Included in full purchase)

      Git Explained

    6. (Included in full purchase)

      Git Core Concepts

    7. (Included in full purchase)

      Git Important Commands

    8. (Included in full purchase)

      Git Hands-on

    9. (Included in full purchase)

      Git Strategy Intro

    10. (Included in full purchase)

      Git Workflow Intro

    11. (Included in full purchase)

      Git Branching Strategies

    12. (Included in full purchase)

      Git Flow

    13. (Included in full purchase)

      Git Trunk Based Development

    14. (Included in full purchase)

      Github Flow

    15. (Included in full purchase)

      Git Strategy Summary

    16. (Included in full purchase)

      Quiz - Level 1 - Module 1 - Version Control with Git

  10. 10

    Level 1 - Module 1 - Introduction to CI/CD

    1. (Included in full purchase)

      CI/CD Introductions

    2. (Included in full purchase)

      CI/CD Explained

    3. (Included in full purchase)

      CI/CD Workflow

    4. (Included in full purchase)

      CI - Continuous Integration

    5. (Included in full purchase)

      CD - Continuous Deployment

    6. (Included in full purchase)

      CICD - dbt CI

    7. (Included in full purchase)

      CICD Summary

    8. (Included in full purchase)

      Quiz - Level 1 - Module 1 - Introduction to CI/CD

  11. 11

    Level 1 - Module 1 - ETL, ELT & Modern Data Workflows

    1. (Included in full purchase)

      ETL / ELT Introductions

    2. (Included in full purchase)

      ETL - Extract Transform Load

    3. (Included in full purchase)

      ELT - Extract Load Transform

    4. (Included in full purchase)

      Reverse ETL Introduction

    5. (Included in full purchase)

      Reverse ETL Explained

    6. (Included in full purchase)

      Reverse ETL Process

    7. (Included in full purchase)

      Reverse ETL Advantages & Challenges

    8. (Included in full purchase)

      Reverse ETL Summary

    9. (Included in full purchase)

      Quiz - Level 1 - Module 1 - ETL, ELT & Modern Data Workflows

  12. 12

    Level 1 - Module 1 - Modern Data Stack (MDS)

    1. (Included in full purchase)

      Modern Data Stack (MDS) Introduction

    2. (Included in full purchase)

      Modern Data Stack (MDS) Overview

    3. (Included in full purchase)

      Modern Data Stack (MDS) Core Components

    4. (Included in full purchase)

      Modern Data Stack (MDS) Core Principles

    5. (Included in full purchase)

      Modern Data Stack (MDS) Operational Benefits

    6. (Included in full purchase)

      Modern Data Stack (MDS) Summary

    7. (Included in full purchase)

      Quiz - Level 1 - Module 1 - Modern Data Stack (MDS)

  13. 13

    Level 1 - Module 2 - Introduction

    1. (Included in full purchase)

      Module 2 - Understanding Data Build Tool (dbt) (Introduction)

  14. 14

    Level 1 - Module 2 - Introduction to dbt

    1. (Included in full purchase)

      dbt Overview

    2. (Included in full purchase)

      dbt-core vs dbt cloud Explained

    3. (Included in full purchase)

      dbt-core Overview

    4. (Included in full purchase)

      dbt-cloud Overview

    5. (Included in full purchase)

      Key Features of dbt

    6. (Included in full purchase)

      dbt-core vs dbt-cloud Comparison

    7. (Included in full purchase)

      dbt Documentation Walkthrough

    8. (Included in full purchase)

      Quiz - Level 1 - Module 2 - Introduction to dbt

  15. 15

    Level 1 - Module 2 - Analytics Engineering

    1. (Included in full purchase)

      What is Analytics Engineering?

    2. (Included in full purchase)

      Analytics Engineer Skills

    3. (Included in full purchase)

      Quiz - Level 1 - Module 2 - Analytics Engineering

  16. 16

    Level 1 - Module 3 - Introduction

    1. (Included in full purchase)

      Module 3 - Setup & Installation

  17. 17

    Level 1 - Module 3 - Setting up your environment

    1. (Included in full purchase)

      Google Cloud Project (GCP) Setup

    2. (Included in full purchase)

      BigQuery Data Warehouse Setup

    3. (Included in full purchase)

      BigQuery Tables Setup

  18. 18

    Level 1 - Module 3 - Installing Tools & Software

    1. (Included in full purchase)

      Visual Studio Code (VSCode) Setup

    2. (Included in full purchase)

      GitHub Setup

    3. (Included in full purchase)

      mac Users Setup

    4. (Included in full purchase)

      Google SDK Setup

  19. 19

    Level 1 - Module 3 - Setting up Git & dbt

    1. (Included in full purchase)

      Git Local Setup

    2. (Included in full purchase)

      Git Access Token Setup

    3. (Included in full purchase)

      dbt-core Installation Setup

  20. 20

    Level 1 - Module 4 - Introduction

    1. (Included in full purchase)

      Module 4 - Running Your First dbt Model (Introduction)

  21. 21

    Level 1 - Module 4 - Understanding dbt Project Structure

    1. (Included in full purchase)

      dbt directory structure

    2. (Included in full purchase)

      yml extension Explained

    3. (Included in full purchase)

      profiles.yml Explained

    4. (Included in full purchase)

      dbt_project.yml Explained

    5. (Included in full purchase)

      Quiz - Level 1 - Module 4 - Understanding dbt Project Structure

  22. 22

    Level 1 - Module 4 - Working with Configuration Files

    1. (Included in full purchase)

      sources.yml Explained

    2. (Included in full purchase)

      schema.yml & properties.yml Explained

    3. (Included in full purchase)

      Quiz - Level 1 - Module 4 - Working with Configuration Files

  23. 23

    Level 1 - Module 4 - Building Your First dbt Model

    1. (Included in full purchase)

      SQL extension Explained

    2. (Included in full purchase)

      Creating our first dbt-model (Hands-on)

  24. 24

    Level 1 - Module 4 - Additional Features & Commands

    1. (Included in full purchase)

      Resources - seeds

    2. (Included in full purchase)

      Important dbt Commands

  25. 25

    Level 2 - Intermediate dbt

    1. (Included in full purchase)

      Introduction to Level 2 & Modules

  26. 26

    Level 2 - Module 5 - Introduction to Resources, Configurations & Properties

    1. (Included in full purchase)

      Module 5 Introduction

    2. (Included in full purchase)

      dbt Resources Explained

    3. (Included in full purchase)

      How to define Configs?

    4. (Included in full purchase)

      How to define Properties?

    5. (Included in full purchase)

      Hierarchy - (Resources, Configs, Properties)

    6. (Included in full purchase)

      General Configs & Properties

    7. (Included in full purchase)

      Quiz - Level 2 - Module 5 - Introduction to Resources, Configurations & Properties

  27. 27

    Level 2 - Module 5 - Resource-Level Configurations

    1. (Included in full purchase)

      Configs - database (Resource Level)

    2. (Included in full purchase)

      Configs - schema (Resource Level)

    3. (Included in full purchase)

      Configs - tags (Resource Level)

    4. (Included in full purchase)

      Configs - alias (Resource Level)

    5. (Included in full purchase)

      Configs - enabled (Resource Level)

  28. 28

    Level 2 - Module 5 - Source, Models & Materializations

    1. (Included in full purchase)

      Resources - Source

    2. (Included in full purchase)

      Resources - Models

    3. (Included in full purchase)

      Model - Configuration & Properties

    4. (Included in full purchase)

      Materialization Types Explained

    5. (Included in full purchase)

      Materialization Types - Table

    6. (Included in full purchase)

      Materialization Types - View

    7. (Included in full purchase)

      Materialization Types - Incremental

    8. (Included in full purchase)

      Materialization Types - Ephemeral

    9. (Included in full purchase)

      Materialization Types - Materialized Views

    10. (Included in full purchase)

      Materialization Types Summary

    11. (Included in full purchase)

      Materialization (Hands-on) - Prep & Intro

    12. (Included in full purchase)

      Materialization (Hands-on) - View

    13. (Included in full purchase)

      Materialization (Hands-on) - Ephemeral

    14. (Included in full purchase)

      Materialization (Hands-on) - Table

    15. (Included in full purchase)

      Materialization (Hands-on) - Materialized View

    16. (Included in full purchase)

      Quiz - Level 2 - Module 5 - Resources & Materializations

  29. 29

    Level 2 - Module 5 - Incremental Models

    1. (Included in full purchase)

      Incremental Models - Introduction

    2. (Included in full purchase)

      Incremental Models - Key Elements

    3. (Included in full purchase)

      Incremental Models - Configuration

    4. (Included in full purchase)

      Incremental Strategy - Introduction

    5. (Included in full purchase)

      Incremental Strategy - Append

    6. (Included in full purchase)

      Incremental Strategy - Merge

    7. (Included in full purchase)

      Incremental Strategy - Delete+Insert

    8. (Included in full purchase)

      Incremental Stategy - Insert Overwrite

    9. (Included in full purchase)

      Macro - is-incremental()

    10. (Included in full purchase)

      Incremental Model Config - unique_key

    11. (Included in full purchase)

      Incremental Model - Full Refresh

    12. (Included in full purchase)

      Incremental Model Config - on_schema_change()

    13. (Included in full purchase)

      Materialization (Hands-on) - Incremental - Insert Overwrite

    14. (Included in full purchase)

      Materialization (Hands-on) - Incremental - Merge

    15. (Included in full purchase)

      Materialization (Hands-on) - Incremental - Append

    16. (Included in full purchase)

      Materialization (Hands-on) - Incremental - Merge - Merge Strategy Config

    17. (Included in full purchase)

      Materialization (Hands-on) - Incremental - Merge - on_schema_change

    18. (Included in full purchase)

      Materialization (Hands-on) - Incremental - Full Refresh

    19. (Included in full purchase)

      Quiz - Level 2 - Module 5 - Incremental Models

  30. 30

    Level 2 - Module 5 - BigQuery Configuration

    1. (Included in full purchase)

      BigQuery dbt Configuration - Introduction

    2. (Included in full purchase)

      BigQuery Config - Partition & Clustering Introduction

    3. (Included in full purchase)

      BigQuery - Partitioning

    4. (Included in full purchase)

      BigQuery - Clustering

    5. (Included in full purchase)

      Quiz -Level 2 - Module 5 - Snapshots & Slowly Changing Dimensions (SCDs)

  31. 31

    Level 2 - Module 5 - Templating & Macros

    1. (Included in full purchase)

      What is Templating?

    2. (Included in full purchase)

      JINJA Templating - Introduction

    3. (Included in full purchase)

      JINJA Templating - Examples

    4. (Included in full purchase)

      Macro - Introduction

    5. (Included in full purchase)

      JINJA Templating - Delimiters

    6. (Included in full purchase)

      JINJA Templating - {% set %} Expression & Context Method

    7. (Included in full purchase)

      Macro - Basic Syntax

    8. (Included in full purchase)

      Macro - generate_database_name()

    9. (Included in full purchase)

      Macro - generate_schema_name()

    10. (Included in full purchase)

      Multiple Environments Explained

    11. (Included in full purchase)

      Macro - Custom Macro

    12. (Included in full purchase)

      Macro - Debuging & Testing

    13. (Included in full purchase)

      Macro - Best Practices

    14. (Included in full purchase)

      Quiz - Level 2 - Module 5 - Templating & Macros

  32. 32

    Level 2 - Module 5 - Snapshots & Slowly Changing Dimensions (SCDs)

    1. (Included in full purchase)

      Resources - Snapshots (Introduction)

    2. (Included in full purchase)

      Slowly Changing Dimensions (SCD) - Introductions

    3. (Included in full purchase)

      SCD - Type 0

    4. (Included in full purchase)

      SCD - Type 1

    5. (Included in full purchase)

      SCD - Type 2

    6. (Included in full purchase)

      SCD - Type 3

    7. (Included in full purchase)

      SCD - Type 4

    8. (Included in full purchase)

      Snapshots in dbt

    9. (Included in full purchase)

      Snapshots - Example

    10. (Included in full purchase)

      Snapshot - Configuration

    11. (Included in full purchase)

      Snapshot - Hashing Explained

    12. (Included in full purchase)

      Quiz - Level 2 - Module 5 - Snapshots & Slowly Changing Dimensions (SCDs)

  33. 33

    Level 2 - Module 5 - Testing in dbt

    1. (Included in full purchase)

      Testing Life Cycle

    2. (Included in full purchase)

      Types of Testing

    3. (Included in full purchase)

      Unit Tests

    4. (Included in full purchase)

      Data Tests

    5. (Included in full purchase)

      Assertions

    6. (Included in full purchase)

      Tests in dbt (Introduction)

    7. (Included in full purchase)

      Types of Tests in dbt

    8. (Included in full purchase)

      Generic Data Tests (dbt)

    9. (Included in full purchase)

      Generic Schema Tests (dbt)

    10. (Included in full purchase)

      Generic Custom Tests (dbt)

    11. (Included in full purchase)

      Singluar Data Tests (dbt)

    12. (Included in full purchase)

      Unit Tests (dbt)- Introduction

    13. (Included in full purchase)

      Unit Tests (dbt) - Data Format Fixtures

    14. (Included in full purchase)

      Unit Tests (dbt) - When Not to Use

    15. (Included in full purchase)

      Unit Tests (dbt) - Summary

    16. (Included in full purchase)

      dbt Tests - Comparison

    17. (Included in full purchase)

      Test - Best Practices

    18. (Included in full purchase)

      Quiz - Level 2 - Module 5 - Testing in dbt

  34. 34

    Level 2 - Module 6 - Introduction (Enhance Your Code)

    1. (Included in full purchase)

      Module 6 - Enhance Your Code (Introduction)

  35. 35

    Level 2 - Module 6 - Working with dbt Packages

    1. (Included in full purchase)

      dbt Packages Explained

    2. (Included in full purchase)

      Using Macro from a Package

    3. (Included in full purchase)

      Packages (Hands-on)

    4. (Included in full purchase)

      Quiz - Level 2 - Module 6 - Working with dbt Packages

  36. 36

    Level 2 - Module 6 - Using Variables in dbt

    1. (Included in full purchase)

      Variables Explained

    2. (Included in full purchase)

      Using dbt Variables in SQL

    3. (Included in full purchase)

      Variable Scope Precedence

    4. (Included in full purchase)

      dbt Variables Summary

    5. (Included in full purchase)

      dbt Variables (Hands-on)

    6. (Included in full purchase)

      Quiz - Level 2 - Module 6 - Using Variables in dbt

  37. 37

    Level 2 - Module 6 - Introduction to Hooks

    1. (Included in full purchase)

      Hooks - Introduction

    2. (Included in full purchase)

      Types of Hooks - pre-hook

    3. (Included in full purchase)

      Types of Hooks - post-hooks

    4. (Included in full purchase)

      Macros in Hooks - Pre & Post Hooks

    5. (Included in full purchase)

      Execution Order - Pre & Post Hook

    6. (Included in full purchase)

      Hooks - on-run-start

    7. (Included in full purchase)

      Hooks - on-run-end

    8. (Included in full purchase)

      Hooks - on-run-start/end Summary

    9. (Included in full purchase)

      Hooks - Summary

    10. (Included in full purchase)

      Hooks (Hands-On)

    11. (Included in full purchase)

      Quiz - Level 2 - Module 6 - Introduction to Hooks

  38. 38

    Level 2 - Module 6 - Exposures in dbt

    1. (Included in full purchase)

      Exposures

    2. (Included in full purchase)

      Exposures (Hands-On)

    3. (Included in full purchase)

      Quiz - Level 2 - Module 6 - Exposures in dbt

  39. 39

    Level 2 - Module 6 - Analysis in dbt

    1. (Included in full purchase)

      Analyses

    2. (Included in full purchase)

      Analysis (Hands-On)

  40. 40

    Level 2 - Module 7 - Introduction (Data Discoverability)

    1. (Included in full purchase)

      Module 7 - Data Observability (Introduction)

  41. 41

    Level 2 - Module 7 - Data Lineage Fundamentals

    1. (Included in full purchase)

      Data Lineage Introduction

    2. (Included in full purchase)

      Importance of Data Lineage

    3. (Included in full purchase)

      Data Lineage vs Tracebility

    4. (Included in full purchase)

      Data Lienage - Provenance Governance

    5. (Included in full purchase)

      Types of Data Lineage

    6. (Included in full purchase)

      Quiz - Level 2 - Module 7 - Data Lineage Fundamentals

  42. 42

    Level 2 - Module 7 - dbt Docs & DAGs

    1. (Included in full purchase)

      dbt docs - Introduction

    2. (Included in full purchase)

      dbt docs - Table / Column Level Lineage

    3. (Included in full purchase)

      DAGs Explained

    4. (Included in full purchase)

      dbt docs generate

    5. (Included in full purchase)

      dbt docs serve

    6. (Included in full purchase)

      Quiz - Level 2 - Module 7 - dbt Docs & DAGs

  43. 43

    Level 2 - Module 7 - Documentaion Best Practices

    1. (Included in full purchase)

      Data Lineage - Best Practices

    2. (Included in full purchase)

      Importance of Documentation

    3. (Included in full purchase)

      Enhancing Documentation with Descriptions

    4. (Included in full purchase)

      Using Docs Blocks for Detailed Descriptions

    5. (Included in full purchase)

      dbt docs - Custom Overview

    6. (Included in full purchase)

      dbt Data Lineage Summary

    7. (Included in full purchase)

      Quiz - Level 2 - Module 7 - Documentaion Best Practices

  44. 44

    Level 2 - Module 8 - Introduction (Hands-On Use Case Build)

    1. (Included in full purchase)

      Module 8 - Hands On (Introduction)

  45. 45

    Level 2 - Module 8 - Use Case Setup

    1. (Included in full purchase)

      Northwind Dataset Explained

    2. (Included in full purchase)

      Use Case - Sales Overview

    3. (Included in full purchase)

      Northwind Dataset Tables Explained

  46. 46

    Level 2 - Module 8 - Dimensional Modeling

    1. (Included in full purchase)

      Dimensional Modelling - Key Concepts

    2. (Included in full purchase)

      Start Schema & Data Flow of Use-Case Explained

    3. (Included in full purchase)

      Quiz - Level 2 - Module 8 - Dimensional Modeling

  47. 47

    Level 2 - Module 8 - Hands-On dbt Modeling

    1. (Included in full purchase)

      Hands-on dbt Modelling Introduction

    2. (Included in full purchase)

      Hands-on Pre-requisites

    3. (Included in full purchase)

      Hands-on dbt Setup Resources VSCode

    4. (Included in full purchase)

      Hands-on Building dbt model Part 1

    5. (Included in full purchase)

      Hands-on Building dbt model Part2

    6. (Included in full purchase)

      Hands-on Building dbt model Part 3 (Source Freshness)

    7. (Included in full purchase)

      Hands-on Building dbt model Part 4 (Snapshots)

    8. (Included in full purchase)

      Hands-on Building dbt model Part 5

    9. (Included in full purchase)

      Hands-on Building dbt model Part 6 (Answering Use-Case Questions)

    10. (Included in full purchase)

      Hands-on Building dbt model Part 7 (dbt-invoke)

    11. (Included in full purchase)

      Hands-on Building dbt model Part 8 (dbt-tests)

    12. (Included in full purchase)

      Hands-on Building dbt model Part 9 (dbt-docs)

    13. (Included in full purchase)

      Quiz - Level 2 - Module 8 - Hands-On dbt Modeling

  48. 48

    Level 3 - Advanced dbt Concepts & Production Deployment

    1. (Included in full purchase)

      Introduction to Level 3

  49. 49

    Level 3 - Module 9 - Introduction to Data Mesh

    1. (Included in full purchase)

      DataMesh - Introduction

    2. (Included in full purchase)

      DataMesh - Concepts

    3. (Included in full purchase)

      DataMesh - The Need for Data Mesh

    4. (Included in full purchase)

      DataMesh - Before & After

    5. (Included in full purchase)

      DataMesh - Architecture

    6. (Included in full purchase)

      DataMesh - 4 Key Principles

    7. (Included in full purchase)

      Quiz - Level 3 - Module 9 - Introduction to Data Mesh

  50. 50

    Level 3 - Module 9 - Exploring Data Mesh Principles

    1. (Included in full purchase)

      DataMesh - Domain Ownership

    2. (Included in full purchase)

      DataMesh - Data as a Product

    3. (Included in full purchase)

      DataMesh - Self-Serve Data Platform

    4. (Included in full purchase)

      DataMesh - Federated Governance

    5. (Included in full purchase)

      DataMesh - Summary

  51. 51

    Level 3 - Module 9 - Debugging dbt Projects

    1. (Included in full purchase)

      Debugging - Introduction

    2. (Included in full purchase)

      What is Debugging?

    3. (Included in full purchase)

      Understanding dbt Workflow

    4. (Included in full purchase)

      Common Error Types in dbt

    5. (Included in full purchase)

      Quiz - Level 3 - Module 9 - Debugging dbt Projects

  52. 52

    Level 3 - Module 9 - Debugging Runtime Errors

    1. (Included in full purchase)

      Debugging - Runtime Error

    2. (Included in full purchase)

      Debugging - Runtime Error (Not a dbt Project)

    3. (Included in full purchase)

      Debugging - Runtime Error (Could Not Find Profile)

    4. (Included in full purchase)

      Debugging - Runtime Error (Failed to Connect)

    5. (Included in full purchase)

      Debugging - Runtime Error (Invalid dbt_project.yml file)

  53. 53

    Level 3 - Module 9 - Debugging Compilation Errors

    1. (Included in full purchase)

      Debugging - Compilation Error

    2. (Included in full purchase)

      Debugging - Compilation Error (Invalid ref Function)

    3. (Included in full purchase)

      Debugging - Compilation Error (Invalid JINJA)

    4. (Included in full purchase)

      Debugging - Compilation Error (Invalid YAML)

    5. (Included in full purchase)

      Debugging - Compilation Error (Incorrect YAML specification)

  54. 54

    Level 3 - Module 9 - Other Debugging Scenarios

    1. (Included in full purchase)

      Debugging - Database errors

    2. (Included in full purchase)

      Debugging - Database Errors (SQL Compilation Error)

    3. (Included in full purchase)

      Quiz - Level 3 - Module 9 - Other Debugging Scenarios

  55. 55

    Level 3 - Module 9 - Data Security & Access Control

    1. (Included in full purchase)

      Data Security & Access Control Introduction

    2. (Included in full purchase)

      Access Control - Role Level Security

    3. (Included in full purchase)

      Access Control - Role Level Security (Hands-on)

    4. (Included in full purchase)

      Access Control - Column Level Security

    5. (Included in full purchase)

      Access Control - Column Level Security (Hands-On)

    6. (Included in full purchase)

      Data Security & Access Control Best Practices

    7. (Included in full purchase)

      Quiz - Level 3 - Module 9 - Data Security & Access Control

  56. 56

    Level 3 - Module 10 - Introduction to Production Deployment

    1. (Included in full purchase)

      Production Deployment - Introduction

    2. (Included in full purchase)

      What is DevOps?

    3. (Included in full purchase)

      Google Cloud Services

    4. (Included in full purchase)

      Popular Orchestration Services

    5. (Included in full purchase)

      Quiz - Level 3 - Module 10 - Introduction to Production Deployment

  57. 57

    Level 3 - Module 10 - Deployment Architecture & Pre-requisites

    1. (Included in full purchase)

      Deployment Architecture - Overview

    2. (Included in full purchase)

      Production Deployment (Hands-on) - Pre-requisites

    3. (Included in full purchase)

      Quiz - Level 3 - Module 10 - Deployment Architecture & Pre-requisites

  58. 58

    Level 3 - Module 10 - Hands-On: Continuous Delivery (CD)

    1. (Included in full purchase)

      Production Deployment (Hands-on) - CD - Cloud Build Manual - Part 1

    2. (Included in full purchase)

      Production Deployment (Hands-on) - CD - Cloud Build Manual - Part 2

    3. (Included in full purchase)

      Production Deployment (Hands-on) - CD - Cloud Workflow Manual

    4. (Included in full purchase)

      Production Deployment (Hands-on) - CD - Automated

    5. (Included in full purchase)

      Quiz - Level 3 - Module 10 - Hands-On: Continuous Delivery (CD)

  59. 59

    Level 3 - Module 10 - Hands-On: Continuous Integration (CI)

    1. (Included in full purchase)

      Production Deployment (Hands-on) - CI - Create CI Trigger

    2. (Included in full purchase)

      Production Deployment (Hands-on) - CI - SQLFluff

    3. (Included in full purchase)

      Production Deployment (Hands-on) - CI - Fixing Lint Issues

    4. (Included in full purchase)

      Production Deployment (Hands-on) - Cl - Build Trigger Success E2E

    5. (Included in full purchase)

      Quiz - Level 3 - Module 10 - Hands-On: Continuous Integration (CI)

Got Questions?

We've got the answers.  Check out our FAQ page for more details or contact us: [email protected]

Ready to Master Data Build Tool?

Join our dbt Masterclass today and take the first step towards becoming a data transformation expert. Limited-time 77% off applies at checkout using code 'endssoon'.

Enroll Now