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

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
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 29380
    حجم: 2138 مگابایت
    مدت زمان: 399 دقیقه
    تاریخ انتشار: 25 دی 1402

    45,900 تومان
    افزودن به سبد خرید