Snowflake and dbt Analytics Engineering Boot Camp

Master Snowflake, Airflow and dbt and become a powerful analytics engineer

Course syllabus

148 lessons • 96+ hours of content • 18 assignments

Bootcamp Kick off
1
Kick off
Airflow
1
How to build job orchestration that matters
2
Injecting quality into your Airflow DAG Lab
3
How to load data into Iceberg with Airflow
4
Backfilling with Airflow
Mastering Analytical Patterns
1
How to do Growth Accounting like Meta
2
Growth Accounting Lab
3
Mastering Change Data Capture (CDC)
4
Change Data Capture Lab
5
Snowflake and Glue Catalog Integration Lab
6
Understanding Read Streams and SCD Implementation Lab
dbt basics
1
Build your first pipeline with dbt
2
dbt basics Day1 Lab
3
dbt basics Day2 Lecture
4
dbt basics Day2 Lab
Advanced dbt
1
advanced dbt Day 1 Lecture
2
advanced dbt Day 1 Lab
3
advanced dbt Day 2 Lecture
4
advanced dbt Day 2 Lab
Advanced Snowflake
1
Advance Snowflake Day 1 Lecture
2
Advance Snowflake Day 1 Lab
3
Advance Snowflake Day 2 Lecture
4
Advance Snowflake Day 2 Lab
Q&A with Zach
1
Lesson 1
Tech Talks
1
Lesson 1
TA Office hours
1
Lesson 1
Capstone Project
1
Lesson 1

Also included

AnalyticsExpert logo
IncludedAnalyticsExpert
Master dbt, Snowflake, Iceberg, and Airflow — and become the analytics engineer every data team fights to hire.121 lessons

Kickoff

1Understanding Capstone Requirements
2Analytics Engineering Bootcamp Kickoff
3Capstone Requirements
4Data Expert.io Architecture
5Onboarding Guide for the Data and AI Engineering Bootcamp

Pre-Read - Data Modeling

1Complex Data Types Lecture
2Complex Data Types Lab
3Slowly Changing Dimensions Lecture
4Slowly Changing Dimensions Lab
5Graph Data Modeling Lecture
6Graph Data Modeling Lab
7Fact Data Modeling Lecture
8Fact Data Modeling Lab
9Data modeling with Date lists Lecture
10Data modeling with Date lists Lab

Week 1: dbt Basics

1dbt basics: How dbt works: sources, models, packages Lecture
2dbt basics: How dbt works: sources, models, packages Lab
3dbt basics: creating a full dbt project lecture
4dbt basics: creating a full dbt project lab
5Build your first pipeline with dbt
6Build your first pipeline with dbt Lab
7Creating a full dbt Project Lecture
8Creating a full dbt Project Lab

Week 2: Advanced dbt

1Advanced dbt: Understanding incremental models Lecture
2Advanced dbt: Understanding incremental models Lab
3Advanced pipelines: Blue-green and WAP with Airflow Lecture
4Advanced pipelines: Blue-green and WAP with Airflow Lab
5Advanced dbt: Jinja, Macros and variables Lecture
6Advanced dbt: Jinja, Macros and variables Lab
7Advanced dbt: Production Pipelines and dbt with Airflow Lecture
8Advanced dbt: Production Pipelines and dbt with Airflow Lab

Week 3: Data Modeling on Snowflake

1Snowflake Basics Day 1 Lecture
2Snowflake Basics Day 1 Lab
3Conceptual Data Modeling Lecture Day 1
4Conceptual Data Modeling Lab Day 1
5How to use Snowpark and Snowflake Optimizations Lecture Day 2
6How to use Snowpark and Snowflake Optimizations Lab Day 2
7Advanced Snowflake Data Modeling and UDFs Lecture Day 3
8Advanced Snowflake Data Modeling and UDFs Lab Day 3

Week 4: Advanced Snowflake

1Advanced snowflake: Deploying the Capstone dag Lecture
2Advanced snowflake: Deploying the Capstone dag Lab
3Advanced Snowflake: Data Modeling and UDFs Lecture
4Advanced Snowflake: Data Modeling and UDFs Lab
5Master Advanced Snowflake Data Modeling with the VARIANT data type
6How to connect Iceberg and Snowflake with Catalogs
7Advance Snowflake Day 2 Lecture
8Advance Snowflake Day 2 Lab

Week 5: Data Modeling on Iceberg

1Apache Iceberg: Big Data History Lecture
2Apache Iceberg: Partitioning, time travel for RCA and metadata Lab
3Apache Iceberg: Data Lake Architectures Lecture
4Apace Iceberg: Data Compression, Run length encoding Lab
5Apache Iceberg: Data Contracts Lecture
6Apache iceberg: WAP patterns and Querying branched Data Lab
7Apache Iceberg Lecture Day1
8Apache Iceberg Lab Day1
9Apache Iceberg Lecture Day2
10Apache Iceberg Lab Day2
11Apache Iceberg Lecture Day3
12Apache Iceberg Lab Day3

Week 6: Airflow & Pipeline Specs with Trino

1How to build job orchestration that matters
2Injecting quality into your Airflow DAG Lab
3How to load data into Iceberg with Airflow
4Airflow Day2 Lab
5Backfilling with Airflow
6Write a comprehensive pipeline spec document
7Orchestration and Airflow Fundamentals Day 1 Lecture
8Write a comprehensive pipeline spec document Lab
9Orchestration and Airflow Fundamentals Lecture
10Orchestration and Airflow Fundamentals Lab
11Orchestration and Airflow Fundamentals Day 1 Lab
12Hard Orchestration Lessons Day 2 Lecture
13Hard Orchestration Lessons Day 2 Lab
14Cumulative DAGs in Production Day 3 Lecture
15Cumulative DAGs in Production Day 3 Lab

Week 7: Analytical Patterns & CDC

1How to do Growth Accounting like Meta
2Growth Accounting Lab
3Mastering Change Data Capture (CDC)
4Change Data Capture Lab
5Snowflake and Glue Catalog Integration Lab
6Understanding Read Streams and SCD Implementation Lab
7Change Data Capture (CDC) and Snowflake basics Lecture
8Change Data Capture (CDC) and Snowflake basics Lab
9How to use snowpark and Snowflake optimization Lecture
10How to use snowpark and Snowflake optimization Lab
11Growth Accounting Models Lecture
12Growth Accounting Models Lab
13Grouping sets and Window functions Lecture
14Grouping sets and Window functions Lab

Week 8: Capstone Project

1Capstone Project Day 1 Lecture
2Capstone Project Day 1 Lab
3Capstone Project Day 2 Class
4Capstone Project Day 3 Class

Q&A with Zach

1Q&A with Zach Week 1
2Q&A with Zach Week 2
3Q&A with Zach Week 3
4Q&A with Zach Week 4
5Q&A with Zach Week1
6Q&A with Zach Week2
7Q&A with Zach Week3
8Q&A with Zach Week4
9Q&A with Zach Week5

Expert Guest Sessions

1Jess Ramos - Data Analyst
2Madison Schott - Analytics Engineer
3Ben Rogojan - Fractional Head of Data
4John Kutay - Director of Engineering at Rippling
5Carly Taylor - Field CTO at Databricks
6Vin Vashishtha - Author of From Data to Profit
7Parth Parekh - Director of Data Engineering at Meta
8Prasad Rao - Principal Solutions Architect
9Andrew Madson - Head of DevRel at Fivetran
10Gourav Khanijoe - Engineering Lead at HubSpot
11Carly Taylor - Field CTO at Databricks (2.0)
12Jess Ramos - Data Analyst (2.0)
13Madison Schott - Analytics Engineer (2.0)
14Vaishali Macwan - Senior Data Scientist
15Tim Chan - Data at OpenAI
16Joe Reis - Author of Fundamentals of Data Engineering
17Madison Schott - Analytics Engineer (3.0)
18Carly Taylor - Field CTO at Databricks (3.0)
19Raaid A. - AI, Data, & Product Strategy Leader
20Parth Parekh - Director of Data Engineering at Meta (2.0)

Before you join

Prerequisites

Some SQL and Snowflake exposure

Platform Access Included

DiscordDiscord
GitHubGitHub
SnowflakeSnowflake
anthropic
OpenAIOpenAI

Get updates for Snowflake and dbt Analytics Engineering Boot Camp

We'll notify you about updates, new content, and special offers.