Join the ultimate data engineering academy to take your career to the next level!

I have led teams of data engineers and software engineers at Airbnb, Facebook, and Netflix. My next goal is to upskill as many data knowledge workers as I can!

Zach Wilson

This gets you access to all self-paced content and the discord community of highly motivated learners!

Analytical Patterns (Day 2 Lab)

Analytical Patterns (Day 2 Lecture)

Advanced SQL and Applying Analytical patterns  (Day 1 Lecture)

Advanced SQL and Applying Analytical patterns  (Day 1 Lab)

Advanced snowflake: Deploying the Capstone dag Lecture

Advanced Snowflake: Data Modeling and UDFs Lecture

Advanced Snowflake: Data Modeling and UDFs Lab

Advanced snowflake: Deploying the Capstone dag Lab

Advanced pipelines: Blue-green and WAP with Airflow Lab

Advanced dbt: Understanding incremental models Lecture

Advanced dbt: Understanding incremental models Lab

Advanced pipelines: Blue-green and WAP with Airflow Lecture

Growth Accounting Models Lab

Change Data Capture (CDC) and Snowflake basics Lab

Change Data Capture (CDC) and Snowflake basics Lecture

How to use snowpark and Snowflake optimization Lecture

Grouping sets and Window functions Lab

How to use snowpark and Snowflake optimization Lab

Growth Accounting Models Lecture

Grouping sets and Window functions Lecture

Product Sense Interview

Data Modeling Interview

Behavioral Interview

Data Structures and Algorithms Interview

Orchestration and Airflow Fundamentals Lecture

Fact Data Modeling Lab

Slowly Changing Dimensions Lecture

Write a comprehensive pipeline spec document Lab

Slowly Changing Dimensions Lab

Orchestration and Airflow Fundamentals Lab

Fact Data Modeling Lecture

Write a comprehensive pipeline spec document

Tech talk with Tim Chan

Tech talk with Andrew Madson

Tech talk with Carly Taylor

Tech talk with Gourav Khanijoe

Tech talk with Jess Ramos

Tech talk with Madison Schott

Tech talk with Vaishali Macwan

dbt basics: creating a full dbt project lab

dbt basics:  How dbt works: sources, models, packages Lecture

dbt basics:  How dbt works: sources, models, packages Lab

dbt basics: creating a full dbt project lecture

Staff Engineer Career Progression

Scala Dataset vs Dataframe API [Dec 15, 2023]

Live SQL Training January 25th, Window Functions and Common Table Expressions

Live SQL Training January 15th

V4 Boot Camp Kick-Off

CareerFlow.ai Orientation

V3 Boot Camp Kick-Off

V2.1 Career Q&A with Sarah Floris [July 21, 2023]

V2.2 Career Q&A with Sarah Floris [July 28, 2023]

V3.1 Career Q&A with Sarah Floris [Nov 17, 2023]

V3.2 Career Q&A with Sarah Floris [Dec 1, 2023]

V3.5 Career Q&A with Sarah Floris [Dec 22, 2023]

V3.3 Career Q&A with Sarah Floris [Dec 15, 2023]

V2.3 Career Q&A with Sarah Floris [Aug 4, 2023]

V2.5 Career Q&A with Sarah Floris [Aug 18, 2023]

Capstone Showcase with Billy Switzer

Capstone Showcase with Jesse Charbneau

Data Visualization with tableau (Day 2 Lab)

Data Visualization with tableau (Day 2 Lecture)

Data Communication and Impact (Day 1 Lab)

Data Communication and Impact (Day 1 Lecture)

Data Pipelines Maintenance (Day 1 Lab)

Data Pipelines Maintenance (Day 1 Lecture)

Airflow Data Quality (Day 2 Lab)

Airflow Data Quality (Day 1 Lab)

Airflow Data Quality (Day 1 Lecture)

Airflow Data Quality (Day 2 Lecture)

Dimensional Data Modeling - Slowly-changing Dimensions and Idempotent Queries in Iceberg (Day 2 Lecture) - Pre-recorded from V3

Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab) - Pre-recorded from V3

Conceptual Data Modeling (Day 3 Lab)

Dimensional Data Modeling - Slowly-changing Dimensions and idempotent queries with Trino (Day 2 Lab) - Pre-recorded from V3

Conceptual Data Modeling (Day 3 Lecture)

Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lecture) - Pre-recorded from V3

Fact Data Modeling - Compact Tables for Efficient Data Representation with Iceberg (Day 2 Lab) - Pre-recorded from V3

Fact Data Modeling - Practical Guide to Formatting and Aggregating Data with Iceberg (Day 3 Lab) - Pre-recorded from V3

Data Accessibility and Privacy (Day 4 Lecture)

Data Accessibility and Privacy (Day 4 Lab)

Fact Data Modeling - Core Concepts, Deduplication Techniques, and Retention Considerations with Iceberg (Day 1 Lecture) - Pre-recorded from V3

Fact Data Modeling - Core Elements in Data Modeling with Iceberg (Day 2 Lecture) - Pre-recorded from V3

Fact Data Modeling - Minimizing Shuffle and Reducing Facts with Iceberg (Day 3 Lecture) - Pre-recorded from V3

Fact Data Modeling - Core Concepts, Deduplication Techniques, and Retention Considerations with Iceberg (Day 1 Lab) - Pre-recorded from V3

V4.1 Chat with Zach

V4.4 Chat with Zach

V4.3 Chat with Zach

V4.2 Chat with Zach 

V3.2 Chat with Zach [Nov 15, 2023]

V3.4 Chat with Zach [Dec 14, 2023]

V2.1 Chat with Zach [July 20, 2023]

V2.5 Chat with Zach [Aug 17, 2023]

V3.1 Chat with Zach [Nov 8, 2023]

V3.3 Chat with Zach [Nov 30, 2023]

V2.4 Chat with Zach [Aug 10, 2023]

V2.6 Chat with Zach [Aug 24, 2023]

V2.3 Chat with Zach [Aug 3, 2023]

V2.2 Chat with Zach [July 27, 2023]

V4.5 Chat with Zach

The Data Architecture Interview

The Data Structures and Algorithms Interview

The Data Modeling Interview

The Behavioral Interview

The SQL Interview

LLMs - Vector database for RAG applications Day 2 Lab

LLMs - Using LLMs to provide business value Day 1 Lecture

LLMs - Using LLMs to provide business value Day 1 Lab

LLMs - Vector database for RAG applications Day 2 Lecture

LLM-Driven Data Engineering Day 2 Lecture

LLM-Driven Data Engineering Day 2 Lab

LLM-Driven Data Engineering Day 1 Lab

LLM-Driven Data Engineering Day 1 Lecture

Build community, not content by Zach Wilson


How to write non-boring content by Carly Taylor


Your story matters and how to tell it by Stephanie Nuesi

Monetizing Part 3: Products & Funnels  by Zach Wilson


Monetizing Part 1: Brands & Coaching by Stephanie Nuesi


Monetizing Part 2: Sponsorship by Carly Taylor


Week 5: Spark Homework Discussion

TA Office Hour 1 (V4)

Week 3: Fact Modeling Homework Queries & Docker Setup

Week 1: Data Modeling & Homework Submissions

Week 6: Homework Submission Discussion

Week 4: Kafka, Docker, Flink, and SQL Discussion

Week 2: Fact Modeling & Homework Queries

V3.5 Special Guest, Madison Schott [Recorded Dec 22, 2023]

V4.5 Tech Talk - Carly Taylor

V2 Special Guests, Carly Taylor and Ben Rogojan [July 19, 2023]

V3.1 Special Guest, Vin Vashishta [Nov 17, 2023]

V2 Special Guests, Sundar Velayutham and Aishwarya Srinivasan [August 9, 2023]

V2 Special Guests, Jitender Aswani and Bill Inmon [August 23, 2023]

V3.3 Special Guest, Joe Reis [Recorded Dec 8, 2023]

V3.2 Special Guest, Ben Rogajan [Dec 1, 2023]

V4 Tech Talk - Steve Huynh 

V2 Special Guests, Stephanie Nuesi and Joe Reis [July 26, 2023]

V3.4 Special Guest, Joseph Machado [Dec 15,2023]

V2 Special Guest, Alex Freberg [August 2, 2023]

V4 Tech Talk - Joe Reis

V4 Tech Talk - Stephanie Nuesi

V4 Tech Talk - Parth Parekh

V2 Special Guests, Parth Parekh and Nick Singh [August 16, 2023]

Kafka Fundamentals, consumer APIs with Confluent (Day 1 Lecture)

Kafka Fundamentals, consumer APIs with Confluent (Day 1 Lab)

Processing data with Apache Flink  (Day 2 Lab)

Processing data with Apache Flink  (Day 2 Lecture)

Advanced Spark (Day 2 Lecture)

Advanced Spark (Day 2 Lab)

Spark Fundamentals (Day 1 Lecture)

Spark Fundamentals Spark Lab on REST API consumption (Day 1 Lab)

Spark Data Quality (Day 3 Lecture)

Spark Data Quality (Day 3 Lab)

dbt day 1 lecture

dbt day 2 lab

dbt day 2 lecture

dbt day 1 lab

All-Access DataExpert.io Subscription

Join DataExpert.io Academy

Bruno Souza de Lima

Julio Suriano

Thy Anh Bui

Scott DeGeest

Miguel Jimeno 

Mitali Gupta

Abhishek Anand

Lalit Sharma

Kalatheeswaran Thiru Meganathan

Vitali Malochka

Join DataExpert.io with 30% off! Less than 15 seats left in Jan 2025 boot camp!
Use code: BLACKFRIDAY at checkout for 30% off!
Please review our academy policies before buying

Join DataExpert.io with 30% off! Less than 15 seats left in Jan 2025 boot camp!

All-Access DataExpert.io Subscription

Join DataExpert.io with 30% off! Less than 15 seats left in Jan 2025 boot camp!Use code: BLACKFRIDAY at checkout for 30% off!Please review our academy policies before buying

Join DataExpert.io with 30% off! Less than 15 seats left in Jan 2025 boot camp!

All-Access DataExpert.io Subscription

Join DataExpert.io with 30% off! Less than 15 seats left in Jan 2025 boot camp!
Use code: BLACKFRIDAY at checkout for 30% off!
Please review our academy policies before buying