All-Access DataExpert.io Subscription
Overview
Lessons
Credentials
This gets you access to all self-paced content and the discord community of highly motivated learners!
What You'll Learn
250+ Hours of Content
Build an awesome portfolio!
Join the dedicated community
This gets you access to all self-paced content and the discord community of highly motivated learners!
Prerequisites
Proficiency in Python and SQL
Basic understanding of Docker, Flink, and Kafka
Course Contents
1
Onboarding
Lessons
2
Speaker Events Archive
Other Included Cohorts
Data Engineer Interview Skills
3
Interview Skills
12 Lessons (5h 22m)
Lessons
The SQL Interview 34m
34mThe Data Modeling Interview 21m
21mThe Data Architecture Interview 35m
35mThe Behavioral Interview 25m
25mThe Data Structures and Algorithms Interview 24m
24mData Structures and Algorithms Interview *29m
29mProduct Sense Interview *41m
41mBehavioral Interview *32m
32mData Modeling Interview *20m
20mLive SQL Training January 25th, Window Functions and Common Table Expressions
Live SQL Training January 15th
Scala Dataset vs Dataframe API [Dec 15, 2023] 56m
56mLinkedIn Mastery Course
3
LinkedIn Masterclass
6 Lessons (6h 6m)
Lessons
Your story matters and how to tell it by Stephanie Nuesi 76m
76mHow to write non-boring content by Carly Taylor
43m
43mBuild community, not content by Zach Wilson
47m
47mMonetizing Part 2: Sponsorship by Carly Taylor
63m
63mMonetizing Part 1: Brands & Coaching by Stephanie Nuesi
63m
63mMonetizing Part 3: Products & Funnels by Zach Wilson
72m
72mFullStackExpert.io All-access Subscription
3
Fullstack Bootcamp Orientation
4
Web Dev Fundamentals
7 Lessons (5h 4m)
5
Intermediate Frontend Development
2 Lessons (3h 44m)
6
Fundamentals of Backend Development
2 Lessons (4h 2m)
7
Intermediate Backend Development
2 Lessons (4h 2m)
8
Advanced Backend Development
5 Lessons (4h 41m)
9
Advanced Frontend Development
5 Lessons (4h 48m)
Analytics Engineering Boot Camp starting October 2024
3
Bootcamp Kickoff
3 Lessons (2h 10m)
2 Assignments
4
Pipeline Spec Building + Airflow Fundamentals
4 Lessons (2h 48m)
1 Assignment
5
Change Data Capture (CDC) and Analytical Patterns
8 Lessons (5h 30m)
Lessons
Change Data Capture (CDC) and Snowflake basics Lecture *58m
58mChange Data Capture (CDC) and Snowflake basics Lab *40m
40mHow to use snowpark and Snowflake optimization Lecture *48m
48mHow to use snowpark and Snowflake optimization Lab *25m
25mGrowth Accounting Models Lecture *51m
51mGrowth Accounting Models Lab *38m
38mGrouping sets and Window functions Lecture *30m
30mGrouping sets and Window functions Lab *38m
38m6
dbt basics
4 Lessons (2h 36m)
1 Assignment
7
Advanced dbt
4 Lessons (2h 40m)
1 Assignment
8
Advanced Snowflake
4 Lessons (2h 38m)
1 Assignment
9
Passing Analytics Engineer Interviews
Lessons
10
Bonus
10 Lessons (6h 46m)
Lessons
Complex Data Types Lecture 48m
48mComplex Data Types Lab 30m
30mSlowly Changing Dimensions Lecture *46m
46mSlowly Changing Dimensions Lab *37m
37mGraph Data Modeling Lecture 38m
38mGraph Data Modeling Lab 42m
42mFact Data Modeling Lecture *46m
46mFact Data Modeling Lab *37m
37mData modeling with Date lists Lecture 38m
38mData modeling with Date lists Lab 39m
39m11
Tech Talk
7 Lessons (5h 40m)
12
TA Office Hours
4 Lessons (3h 56m)
2025 New Year Data Engineering Boot Camp starting January 6th
3
Airflow + Trino
5 Lessons (3h 13m)
1 Assignment
Lessons
Assignments
4
Snowflake + dbt Basics
6 Lessons (3h 30m)
1 Assignment
5
Databricks Basics
6 Lessons (2h 38m)
1 Assignment
Lessons
Assignments
6
Advanced Spark on Databricks
6 Lessons (3h 38m)
1 Assignment
Lessons
Apache Spark Shuffle Joins Day 1 Lecture *40m
40mApache Spark Shuffle Joins Day 1 Lab *34m
34mApache Spark Memory Turning, Partitioning Day 2 Lecture *38m
38mApache Spark Memory Turning, Partitioning Day 2 Lab *31m
31mApache Spark Unit Testing Day 3 Lecture *38m
38mApache Spark Unit Testing Day 3 Lab *35m
35mAssignments
7
Snowflake + Advanced dbt
6 Lessons (4h 6m)
1 Assignment
8
Analytical Patterns and Advanced SQL
6 Lessons (4h 3m)
1 Assignment
Lessons
Applying Analytical Patterns Day 1 Lecture *41m
41mApplying Analytical Patterns Day 1 Lab *38m
38mAdvanced SQL Patterns Day 2 Lecture *26m
26mAdvanced SQL Patterns Day 2 Lab *46m
46mAnalytical Patterns Recognizing Business Value Day 3 Lecture *62m
62mAnalytical Patterns Recognizing Business Value Day 3 Lab *27m
27m9
Real Time Data (Spark and Kafka Streaming)
6 Lessons (2h 11m)
1 Assignment
Lessons
Assignments
10
Bonus - LLMs
6 Lessons (4h 49m)
11
Career Development Sessions
5 Lessons (4h 30m)
12
Q&A with Zach Wilson
4 Lessons (2h 33m)
13
Guest Speaker Sessions
7 Lessons (6h 27m)
14
TA Office Hours
6 Lessons (6h 3m)
15
Capstone Showcase Jan 2025
1 Lesson (2h 1m)
2 Assignments
Boot Camp: Community Edition
3
Bootcamp Orientation
4
Dimensional Data Modeling
6 Lessons (4h 11m)
1 Assignment
Lessons
Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lecture *43m
43mDimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab *41m
41mDimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lecture *40m
40mDimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab *45m
45mDimensional Data Modeling: Graph Data Modeling Day 3 Lecture *34m
34mDimensional Data Modeling: Graph Data Modeling Day 3 Lab *46m
46m5
Fact Data Modeling
6 Lessons (3h 52m)
1 Assignment
Lessons
Fact Data Modeling: Core Concepts, Deduplication Day 1 Lecture *52m
52mFact Data Modeling: Practical Insights into Data Modeling Day 1 Lab *40m
40mFact Data Modeling: Core Elements in Data Modeling Day 2 Lecture *31m
31mFact Data Modeling: Compact Tables for Efficient Data Representation Day 2 Lab *45m
45mFact Data Modeling: Minimizing Shuffle and Reducing Facts Day 3 Lecture *32m
32mFact Data Modeling: Practical Guide to Formatting and Aggregating Data Day 3 Lab *30m
30mAssignments
6
Apache Spark Fundamentals
6 Lessons (3h 34m)
1 Assignment
Lessons
Apache Spark: Architecture, Optimization, and Best Practices Day 1 Lecture *48m
48mApache Spark: Hands-On for Broadcast and Hash Joins Day 1 Lab *26m
26mApache Spark: Managing Spark Jobs and Notebooks Day 2 Lecture *34m
34mApache Spark: User-Defined Functions and Broadcast Join Day 2 Lab *36m
36mUnit Testing Spark Jobs: Importance, Challenges, and Leadership Perspectives Lecture *41m
41mUnit Testing Spark Jobs: Mastering Spark and PySpark Testing Lab *27m
27mAssignments
7
Applying Analytical Patterns
4 Lessons (2h 45m)
1 Assignment
Lessons
Applying Analytical Patterns: Exploring SQL, Scaling Projects and Aggregation Analysis Day 1 Lecture *52m
52mApplying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab *34m
34mApplying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture *44m
44mApplying Analytical Patterns: Aggregations and Cardinality Reduction Day 2 Lab *33m
33mAssignments
8
Real-time pipelines with Flink and Kafka
5 Lessons (2h 48m)
1 Assignment
Lessons
Flink Lab Setup *7m
7mStreaming Pipelines: Mastering Streaming and Real-time Pipelines Day 1 Lecture 50m
50mStreaming Pipelines: Setting up Streaming Pipelines Day 1 Lab 40m
40mStreaming Pipelines: Exploring Data Collection and Processing Day 2 Lecture *31m
31mStreaming Pipelines: Kafka, Postgres, Spark Integrations and Parallelism Day 2 Lab 39m
39mAssignments
9
Data Visualization and Impact
4 Lessons (1h 49m)
1 Assignment
Lessons
Data Visualization and Impact: Mastering Data Engineering Day 1 Lecture *39m
39mData Visualization and Impact: Hands-On with the CSV files Day 1 Lab *8m
8mData Visualization and Impact: Insights and Best Practices Day 2 Lecture *23m
23mData Visualization and Impact: Exploring Data Visualization and Aggregation Techniques Day 2 Lab *37m
37mAssignments
10
Data Pipeline Maintenance
2 Lessons (2h 24m)
1 Assignment
11
KPIs and Experimentation
3 Lessons (2h 37m)
1 Assignment
Lessons
Assignments
12
Data Quality Patterns
3 Lessons (1h 46m)
Spring Data Engineering Boot Camp Starting May 26th
3
Data Lakes with Delta Table
6 Lessons (2h 10m)
1 Assignment
4
Databricks and Advanced Spark
7 Lessons (3h 47m)
1 Assignment
Lessons
Apache Spark Shuffle Joins Day 1 Lecture *40m
40mApache Spark Shuffle Joins Day 1 Lab *34m
34mApache Spark Memory Turning, Partitioning Day 2 Lecture *38m
38mApache Spark Memory Turning, Partitioning Day 2 Lab *31m
31mApache Spark Unit Testing Day 3 Lecture *
Apache Spark Unit Testing Day 3 Lab *35m
35mSetting Up CI/CD and Unit Testing in Databricks for Reliable Data Pipelines *46m
46mAssignments
5
Structured Streaming Kafka to Delta Live Table
1 Assignment
6
Managing Unstructured Data
1 Assignment
7
Q&A with Zach May 2025
6 Lessons (3h 40m)
8
Bonus - Azure
5 Lessons (5h 37m)
9
Tech Talks May 2025
10
TA Office Hours
8 Lessons (2h 48m)
Analytics Engineering Boot Camp starting April 14th
3
Data Modeling on Iceberg
7 Lessons (5h 36m)
1 Assignment
4
Data Modeling on Snowflake
6 Lessons (5h 11m)
1 Assignment
Lessons
Conceptual Data Modeling Lecture Day 1 *57m
57mConceptual Data Modeling Lab Day 1 *51m
51mHow to use Snowpark and Snowflake Optimizations Lecture Day 2 *52m
52mHow to use Snowpark and Snowflake Optimizations Lab Day 2 *45m
45mAdvanced Snowflake Data Modeling and UDFs Lecture Day 3 *47m
47mAdvanced Snowflake Data Modeling and UDFs Lab Day 3 *58m
58mAssignments
5
Snowflake + dbt basics
4 Lessons (3h 50m)
1 Assignment
6
Advanced dbt
4 Lessons (3h 46m)
1 Assignment
7
End-to-End Project Hacking
4 Lessons (4h 54m)
2 Assignments
8
Q&A With Zach Wilson
4 Lessons (3h 21m)
9
TA Office Hours
6 Lessons (5h 39m)
10
Tech Talks
8 Lessons (7h 19m)
11
Career Development
AI Engineering Boot Camp Starting on July 7th
3
Prompt Engineering
5 Lessons (3h 52m)
1 Assignment
Lessons
Assignments
4
Understanding RAG
4 Lessons (3h 53m)
1 Assignment
5
Advanced RAG and Agentic AI
4 Lessons (2h 56m)
1 Assignment
6
MLOps
5 Lessons (2h 31m)
1 Assignment
Lessons
Day 1 Lecture: Trusting your workflows (evaluation metrics and guardrails) *27m
27mDay 1 Lab: Setting up CI/CD for an AI application *48m
48mDay 2 Lecture: Understanding LLM Reasoning traceability *34m
34mDay 2 Lab: Tracing LLM reasoning with LangChain + LangSmith *42m
42mSupplemental lab session on GuardrailsAI
Assignments
7
Building end-to-end AI Application
4 Lessons (3h 20m)
2 Assignments
Lessons
8
Tech Talks July 2025
5 Lessons (2h 54m)
9
Career Dev Sessions
3 Lessons (1h 20m)
10
Book Club
4 Lessons (1h 56m)
Building Pipelines with Iceberg and Airflow
3
Data Modeling with Iceberg and Trino
6 Lessons (3h 51m)
Ready to Start Your Journey?
Join thousands of students who have already transformed their careers with this program.