All-Access DataExpert.io Subscription
This gets you access to all self-paced content and the discord community of highly motivated learners!
Status
Not Enrolled
What You'll Learn
- 250+ Hours of Content
- Build an awesome portfolio!
- Join the dedicated community
Prerequisites
- Proficiency in Python and SQL
- Basic understanding of Docker, Flink, and Kafka
Program Structure
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
The Data Modeling Interview
21m
The Data Architecture Interview
35m
The Behavioral Interview
25m
The Data Structures and Algorithms Interview
24m
Data Structures and Algorithms Interview
29m
Product Sense Interview
41m
Behavioral Interview
32m
Data Modeling Interview
20m
Live SQL Training January 25th, Window Functions and Common Table Expressions
Live SQL Training January 15th
Scala Dataset vs Dataframe API [Dec 15, 2023]
56m
LinkedIn Mastery Course
3
LinkedIn Masterclass
6 Lessons•6h 6m
Lessons
Monetizing Part 1: Brands & Coaching by Stephanie Nuesi
63m
Monetizing Part 3: Products & Funnels by Zach Wilson
72m
Your story matters and how to tell it by Stephanie Nuesi
76m
Build community, not content by Zach Wilson
47m
How to write non-boring content by Carly Taylor
43m
Monetizing Part 2: Sponsorship by Carly Taylor
63m
FullStackExpert.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
Change Data Capture (CDC) and Snowflake basics Lab
40m
How to use snowpark and Snowflake optimization Lecture
48m
How to use snowpark and Snowflake optimization Lab
25m
Growth Accounting Models Lecture
51m
Growth Accounting Models Lab
38m
Grouping sets and Window functions Lecture
30m
Grouping sets and Window functions Lab
38m
6
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
Complex Data Types Lab
30m
Slowly Changing Dimensions Lecture
46m
Slowly Changing Dimensions Lab
37m
Graph Data Modeling Lecture
38m
Graph Data Modeling Lab
42m
Fact Data Modeling Lecture
46m
Fact Data Modeling Lab
37m
Data modeling with Date lists Lecture
38m
Data modeling with Date lists Lab
39m
11
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
4
Snowflake + dbt Basics
6 Lessons•3h 30m
1 Assignment
5
Databricks Basics
6 Lessons•2h 38m
1 Assignment
6
Advanced Spark on Databricks
6 Lessons•3h 38m
1 Assignment
Lessons
Assignments
7
Snowflake + Advanced dbt
6 Lessons•4h 6m
1 Assignment
8
Analytical Patterns and Advanced SQL
6 Lessons•4h 3m
1 Assignment
Lessons
9
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
Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab
41m
Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lecture
40m
Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab
45m
Dimensional Data Modeling: Graph Data Modeling Day 3 Lecture
34m
Dimensional Data Modeling: Graph Data Modeling Day 3 Lab
46m
5
Fact Data Modeling
6 Lessons•3h 52m
1 Assignment
Lessons
Fact Data Modeling: Core Concepts, Deduplication Day 1 Lecture
52m
Fact Data Modeling: Practical Insights into Data Modeling Day 1 Lab
40m
Fact Data Modeling: Core Elements in Data Modeling Day 2 Lecture
31m
Fact Data Modeling: Compact Tables for Efficient Data Representation Day 2 Lab
45m
Fact Data Modeling: Minimizing Shuffle and Reducing Facts Day 3 Lecture
32m
Fact Data Modeling: Practical Guide to Formatting and Aggregating Data Day 3 Lab
30m
Assignments
6
Apache Spark Fundamentals
6 Lessons•3h 34m
1 Assignment
Lessons
Apache Spark: Architecture, Optimization, and Best Practices Day 1 Lecture
48m
Apache Spark: Hands-On for Broadcast and Hash Joins Day 1 Lab
26m
Apache Spark: Managing Spark Jobs and Notebooks Day 2 Lecture
34m
Apache Spark: User-Defined Functions and Broadcast Join Day 2 Lab
36m
Unit Testing Spark Jobs: Importance, Challenges, and Leadership Perspectives Lecture
41m
Unit Testing Spark Jobs: Mastering Spark and PySpark Testing Lab
27m
Assignments
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
Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab
34m
Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture
44m
Applying Analytical Patterns: Aggregations and Cardinality Reduction Day 2 Lab
33m
Assignments
8
Real-time pipelines with Flink and Kafka
5 Lessons•2h 48m
1 Assignment
Lessons
Flink Lab Setup
7m
Streaming Pipelines: Mastering Streaming and Real-time Pipelines Day 1 Lecture
50m
Streaming Pipelines: Setting up Streaming Pipelines Day 1 Lab
40m
Streaming Pipelines: Exploring Data Collection and Processing Day 2 Lecture
31m
Streaming Pipelines: Kafka, Postgres, Spark Integrations and Parallelism Day 2 Lab
39m
Assignments
9
Data Visualization and Impact
4 Lessons•1h 49m
1 Assignment
Lessons
Data Visualization and Impact: Mastering Data Engineering Day 1 Lecture
39m
Data Visualization and Impact: Hands-On with the CSV files Day 1 Lab
8m
Data Visualization and Impact: Insights and Best Practices Day 2 Lecture
23m
Data Visualization and Impact: Exploring Data Visualization and Aggregation Techniques Day 2 Lab
37m
Assignments
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, 2025
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
Apache Spark Shuffle Joins Day 1 Lab
34m
Apache Spark Memory Turning, Partitioning Day 2 Lecture
38m
Apache Spark Memory Turning, Partitioning Day 2 Lab
31m
Apache Spark Unit Testing Day 3 Lecture
Apache Spark Unit Testing Day 3 Lab
35m
Setting Up CI/CD and Unit Testing in Databricks for Reliable Data Pipelines
46m
Assignments
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, 2025
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
Conceptual Data Modeling Lab Day 1
51m
How to use Snowpark and Snowflake Optimizations Lecture Day 2
52m
How to use Snowpark and Snowflake Optimizations Lab Day 2
45m
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
47m
Advanced Snowflake Data Modeling and UDFs Lab Day 3
58m
Assignments
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, 2025
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
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
4
Airflow Pipelines with Iceberg
5 Lessons•4h 3m