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!

Advanced SQL and Applying Analytical patterns  (Day 1 Lab)

Advanced SQL and Applying Analytical patterns  (Day 1 Lecture)

Analytical Patterns (Day 2 Lab)

Analytical Patterns (Day 2 Lecture)

Live SQL Training January 15th

Staff Engineer Career Progression

Scala Dataset vs Dataframe API [Dec 15, 2023]

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

CareerFlow.ai Orientation

V3 Boot Camp Kick-Off

V4 Boot Camp Kick-Off

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

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

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

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

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

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

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

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

Capstone Showcase with Billy Switzer

Capstone Showcase with Jesse Charbneau

Data Communication and Impact (Day 1 Lecture)

Data Communication and Impact (Day 1 Lab)

Data Visualization with tableau (Day 2 Lab)

Data Visualization with tableau (Day 2 Lecture)

Data Pipelines Maintenance (Day 1 Lab)

Data Pipelines Maintenance (Day 1 Lecture)

Airflow Data Quality (Day 1 Lecture)

Airflow Data Quality (Day 2 Lecture)

Airflow Data Quality (Day 1 Lab)

Airflow Data Quality (Day 2 Lab)

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

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

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

Conceptual Data Modeling (Day 3 Lecture)

Conceptual Data Modeling (Day 3 Lab)

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

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

Fact Data Modeling - Practical Guide to Formatting and Aggregating Data with Iceberg (Day 3 Lab) - 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 - Core Concepts, Deduplication Techniques, and Retention Considerations with Iceberg (Day 1 Lab) - 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 Elements in Data Modeling with Iceberg (Day 2 Lecture) - Pre-recorded from V3

Data Accessibility and Privacy (Day 4 Lab)

Data Accessibility and Privacy (Day 4 Lecture)

V4.5 Chat with Zach

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

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

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

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

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

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

V4.2 Chat with Zach 

V4.3 Chat with Zach

V4.4 Chat with Zach

V4.1 Chat with Zach

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

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

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

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

The Data Modeling Interview

The Data Architecture Interview

The Data Structures and Algorithms Interview

The SQL Interview

The Behavioral Interview

LLMs - Using LLMs to provide business value Day 1 Lab

LLMs - Vector database for RAG applications Day 2 Lecture

LLMs - Using LLMs to provide business value Day 1 Lecture

LLMs - Vector database for RAG applications Day 2 Lab

LLM-Driven Data Engineering Day 1 Lab

LLM-Driven Data Engineering Day 2 Lecture

LLM-Driven Data Engineering Day 1 Lecture

LLM-Driven Data Engineering Day 2 Lab

Your story matters and how to tell it by Stephanie Nuesi

Monetizing Part 1: Brands & Coaching by Stephanie Nuesi


Build community, not content by Zach Wilson


Monetizing Part 2: Sponsorship by Carly Taylor


How to write non-boring content by Carly Taylor


Monetizing Part 3: Products & Funnels  by Zach Wilson


TA Office Hour 2 (V4)

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

Week 6: Homework Submission Discussion

Week 2: Fact Modeling & Homework Queries

TA Office Hour 3 (V4)

TA Office Hour 1 (V4)

TA Office Hour 6 (V4)

Week 5: Spark Homework Discussion

TA Office Hour 5 (V4)

Week 1: Data Modeling & Homework Submissions

Week 3: Fact Modeling Homework Queries & Docker Setup

TA Office Hour 4 (V4)

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

V4 Tech Talk

V4.5 Tech Talk - Carly Taylor

V4 Tech Talk - Joe Reis

V4 Tech Talk - Stephanie Nuesi

V4 Tech Talk - Parth Parekh

V4 Tech Talk - Steve Huynh 

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

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]

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

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

V3.1 Special Guest, Vin Vashishta [Nov 17, 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]

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)

Spark Data Quality (Day 3 Lecture)

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

Advanced Spark (Day 2 Lab)

Advanced Spark (Day 2 Lecture)

Spark Data Quality (Day 3 Lab)

Spark Fundamentals (Day 1 Lecture)

dbt day 2 lab

dbt day 1 lecture

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