Course curriculum

    1. Accessing Lab Environment

    2. Setup VS Code for DBT Development

    3. Validate Redshiift Database Access

    4. Overview of Information Schema or Data Dictionary in Redshift

    5. Review Datasets and Validate AWS s3 Access

    1. Introduction to DBT (Features, Use Cases and Implementation Patterns)

    2. Setup AWS s3 for first DBT Model using Redshift

    3. Setup DBT and Build first Model

    1. Sources & External Data Documentation

    2. Advanced Testing with dbt_utils

    3. Documentation & Lineage with dbt docs

    1. Staging Models (Bronze Layer)

    2. Intermediate Models (Silver Layer)

    3. Dimensional Models (Silver Layer)

    4. Analytics Models (Gold Layer)

    1. Understanding Complete E2E Pipeline

    2. DBT Seeds (Reference Data Management)

    3. DBT Snapshots (SCD Type 2 Implementation)

    4. DBT Hooks (Operational Improvements)

    1. Quiz

About this course

  • Free
  • 20 lessons
  • 0 hours of video content

Discover your potential, starting today

Enroll today