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!

Airflow Data Quality (Day 1 Lecture)

Airflow Data Quality (Day 2 Lecture)

Airflow Data Quality (Day 1 Lab)

Airflow Data Quality (Day 2 Lab)

Analytical Patterns (Day 2 Lecture)

Analytical Patterns (Day 2 Lab)

Advanced SQL and Applying Analytical patterns  (Day 1 Lecture)

Advanced SQL and Applying Analytical patterns  (Day 1 Lab)

Scala Dataset vs Dataframe API [Dec 15, 2023]

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

Live SQL Training January 15th

Staff Engineer Career Progression

CareerFlow.ai Orientation

V4 Boot Camp Kick-Off

V3 Boot Camp Kick-Off

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

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

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

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

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

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

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

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

dbt (Day 1 Lab)

dbt (Day 2 Lab)

dbt (Day 2 Lecture)

dbt (Day 1 Lecture)

Data Communication and Impact (Day 1 Lecture)

Data Visualization with tableau (Day 2 Lab)

Data Visualization with tableau (Day 2 Lecture)

Data Communication and Impact (Day 1 Lab)

Data Pipelines Maintenance (Day 1 Lecture)

Data Pipelines Maintenance (Day 1 Lab)

Conceptual Data Modeling (Day 3 Lecture)

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 Lab)

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

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 Lecture) - 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 - Core Elements in Data Modeling with Iceberg (Day 2 Lecture) - 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 Lab)

Data Accessibility and Privacy (Day 4 Lecture)

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

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

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

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

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

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

V4.1 Chat with Zach

V4.2 Chat with Zach 

V4.3 Chat with Zach

V4.4 Chat with Zach

V4.5 Chat with Zach

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

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

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

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

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

The Data Structures and Algorithms Interview

The SQL Interview

The Data Modeling Interview

The Data Architecture Interview

The Behavioral Interview

LLM-Driven Data Engineering Day 2 Lecture

LLM-Driven Data Engineering Day 1 Lecture

LLM-Driven Data Engineering Day 2 Lab

LLM-Driven Data Engineering Day 1 Lab

Monetizing Part 2: Sponsorship by Carly Taylor


How to write non-boring content by Carly Taylor


Monetizing Part 1: Brands & Coaching by Stephanie Nuesi


Monetizing Part 3: Products & Funnels  by Zach Wilson


Your story matters and how to tell it by Stephanie Nuesi

Build community, not content by Zach Wilson


LLMs - Using LLMs to provide business value Day 1 Lab

LLMs - Using LLMs to provide business value Day 1 Lecture

LLMs - Vector database for RAG applications Day 2 Lab

LLMs - Vector database for RAG applications Day 2 Lecture

Week 3: Fact Modeling Homework Queries & Docker Setup

TA Office Hour 6 (V4)

TA Office Hour 1 (V4)

Week 6: Homework Submission Discussion

Week 5: Spark Homework Discussion

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

Week 1: Data Modeling & Homework Submissions

Week 2: Fact Modeling & Homework Queries

TA Office Hour 5 (V4)

TA Office Hour 4 (V4)

TA Office Hour 3 (V4)

TA Office Hour 2 (V4)

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

Spark Fundamentals (Day 1 Lecture)

Spark Data Quality (Day 3 Lab)

Advanced Spark (Day 2 Lecture)

Advanced Spark (Day 2 Lab)

Spark Data Quality (Day 3 Lecture)

V2 Special Guests, Parth Parekh and Nick Singh [August 16, 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

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

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

V4 Tech Talk - Steve Huynh 

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

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

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

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

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

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

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

V2 Special Guests, Sundar Velayutham and Aishwarya Srinivasan [August 9, 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 Lecture)

Processing data with Apache Flink  (Day 2 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

Zach Wilson invites you to join DataExpert.io Academy!
Use code: ZACH15 at checkout for 15% off discount!
Please review our academy policies before buying

Zach Wilson invites you to join DataExpert.io Academy!

All-Access DataExpert.io Subscription

Zach Wilson invites you to join DataExpert.io Academy!Use code: ZACH15 at checkout for 15% off discount!Please review our academy policies before buying

Zach Wilson invites you to join DataExpert.io Academy!

All-Access DataExpert.io Subscription

Zach Wilson invites you to join DataExpert.io Academy!
Use code: ZACH15 at checkout for 15% off discount!
Please review our academy policies before buying