The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero

سرفصل های دوره

Become a dbt professional with this ALL-IN-ONE COURSE covering both theory & practice through a real-world project!

01 - Course Introduction

001 Instructors Introduction

002 Welcome

003 Complete-dbt-Bootcamp-slides.pdf

003 Course Structure Overview

02 - Theory - The Data Maturity Model

001 Introduction - Maslows Pyramid of Data

002 The Data Maturity Model

003 ETL and ELT

03 - Theory - Data Warehouses, Data Lakes and Lakehouses

001 Data Warehousing - a short introduction

002 External Tables and Cloud Data Warehouses

003 Data Lakes

004 Data Lakehouse

04 - Theory - The Modern Data Stack

001 The Modern Data Stack

05 - Theory - Slowly Changing Dimension (SCD)

001 The Basics of Slowly Changing Dimensions

002 Type 0 - Retain Original

003 Type 1 - Overwrite

004 Type 2 - Add New Row

005 Type 3 - Add New Attribute

06 - Intro to the practical sessions dbt and the Airbnb use-case

001 dbt Overview

002 Use-case and Input Data Model Overview

07 - Practice - Setup

001 How to use github and the courses resources.html

002 Snowflake Registration

003 A note on the Snowflake data import.html

004 010-snowflake-setup.zip

004 Importing Airbnb Data into Snowflake

005 READ ME! Setup instructions and Prerequisites.html

006 Optional - Installing Python and pip on Windows

007 Optional - Setting up a Python Virtualenv on Windows

008 Optional - Setting up Python and pip on a Mac

009 dbt Installation (All Platforms)

010 Creating a dbt 1.5 project and connecting it to Snowflake using dbt init

011 READ ME - dbt project structure - data folder vs. seeds folder.html

012 Overview of the dbt Project Structure

013 The dbt Power User Extension for VSCode.html

014 Introduction to the dbt Power User VSCode Extension (optional)

015 Install and Configure the dbt Power User Extension (optional)

016 A note on the DEV schema.html

017 Datasets and Data Flow Overview

external-links.txt

08 - Models

001 Learning Objectives - Models

002 Models Overview

003 Theory CTE - Common Table Expressions

004 Creating our first model Airbnb listings

004 Models.md.pdf

005 dbt Power User - Working with Models, Autocomplete and Query Results

09 - Materializations

001 Learning Objectives - Materializations

002 Materializations Overview

003 Materializations.md.pdf

003 Model Dependencies and dbts ref tag

004 Table type materialization & Project-level Materialization config

005 Incremental materialization

006 Ephemeral materialization

10 - Seeds and Sources

001 Learning Objectives - Seeds and Sources

002 Seeds and Sources Overview

003 Seeds

003 Sources-and-Seeds.pdf

003 seed-full-moon-dates.csv

004 Sources

005 Source Freshness

11 - Snapshots

001 Learning Objectives - Snapshots

002 Snapshots Overview

003 Creating a Snapshot

003 Snapshots.md.pdf

12 - Tests

001 Learning objectives - Tests

002 Tests Overview

003 Generic Tests

003 Tests.md.pdf

004 Singular Tests

13 - Macros, Custom Tests and Packages

001 Learning Objectives - Macros, Custom Tests and Packages

002 Macros Overview

003 Creating our First Macro

003 Macros-CustomTests-Packages.md.pdf

004 Writing Custom Generic Tests

005 README updated versions of packages.html

006 Installing Third-Party Packages

14 - Documentation

001 Learning Objectives - Documentation

002 Documentation Overview

003 Documentation.md.pdf

003 Writing and Exploring Basic Documentation

004 Markdown-based Docs, Custom Overview Page and Assets

004 input-schema.zip

005 The Linage Graph (Data Flow DAG)

006 dbt Power User - Lineage and Documentation

15 - Analyses, Hooks and Exposures

001 Learning Objectives - Analyses, Hook and Exposures

001 analyses-hooks-exposures.pdf

002 Analyses

003 Hooks

004 Setting up a BI Dashboard in Snowflake and Preset

005 Exposures

16 - dbt Hero

001 Welcome to Hero

002 Have your say in the courses roadmap.html

17 - Debugging Tests and Testing with dbt-expectations

001 A note on the dbt-expectations setup.html

002 Great Expectations Overview

002 great-expectations.pdf

003 Comparing row counts between models

004 Looking for outliers in your data

005 Implementing test warnings for extremal items

006 Validating column types

007 Monitoring categorical variables in the source data

008 Debugging dbt tests and Working with regular expressions

18 - Accelerate dbt Development Using dbt Power User

001 How to Get an API Key for the Advanced Features

002 Use AI to Generate Documentation

003 Generate dbt Model from Source Definition or SQL

004 Working with Column-Level Lineage

005 Find Problems in your dbt Project with Health Check

006 Use AI to Interpret Queries via Query Explanations

19 - Best Practices for Introducing and Using dbt in your Company

001 An interview with the Data Utilization Head of the Vienna Insurance Group

20 - dbt Certification Exam Preparation Guide

001 How to prepare for the certification exam An interview with Muizz Lateef

001 quiz.pdf

21 - Supplementary Materials

001 Supplementary Material - Installing dbt on Windows with Windows Linux Filesystem

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy