Analytics Engineering Boot Camp starting October 2024
Taught by Zach Wilson
Founder at DataExpert.io
What you'll learn
✓
5 weeks of classes
✓
8 hrs on dbt
✓
8 hrs on Trino, Snowflake, and Iceberg
✓
4 hrs on Airflow
✓
Master 5 analytics interviews
✓
Weekly Q&A with Zach
✓
2x/week calls with industry leaders
✓
Get career mentorship afterwards
✓
Build a capstone project
Learn directly from the experts
Enroll now
Oct 22, 2024 – Nov 18, 2024 · Starting soon
Payment plan
$1997.9
one-timeDuration4 weeks
StartsOct 22, 2024
Time commitment9 hrs / week
FormatLive Online
What's included
5 weeks of classes
8 hrs on dbt
8 hrs on Trino, Snowflake, and Iceberg
4 hrs on Airflow
Master 5 analytics interviews
Weekly Q&A with Zach
2x/week calls with industry leaders
Get career mentorship afterwards
Build a capstone project
Course syllabus
49 lessons • 36+ hours of content • 6 assignments
Bootcamp Kickoff
1
Analytics Engineering Bootcamp Kickoff
2
Capstone Requirements
3
Understanding Capstone Requirements
Pipeline Spec Building + Airflow Fundamentals
1
Write a comprehensive pipeline spec document
2
Write a comprehensive pipeline spec document Lab
3
Orchestration and Airflow Fundamentals Lecture
4
Orchestration and Airflow Fundamentals Lab
Change Data Capture (CDC) and Analytical Patterns
1
Change Data Capture (CDC) and Snowflake basics Lecture
2
Change Data Capture (CDC) and Snowflake basics Lab
3
How to use snowpark and Snowflake optimization Lecture
4
How to use snowpark and Snowflake optimization Lab
5
Growth Accounting Models Lecture
6
Growth Accounting Models Lab
7
Grouping sets and Window functions Lecture
8
Grouping sets and Window functions Lab
dbt basics
1
dbt basics: How dbt works: sources, models, packages Lecture
2
dbt basics: How dbt works: sources, models, packages Lab
3
dbt basics: creating a full dbt project lecture
4
dbt basics: creating a full dbt project lab
Advanced dbt
1
Advanced dbt: Understanding incremental models Lecture
2
Advanced dbt: Understanding incremental models Lab
3
Advanced pipelines: Blue-green and WAP with Airflow Lecture
4
Advanced pipelines: Blue-green and WAP with Airflow Lab
Advanced Snowflake
1
Advanced snowflake: Deploying the Capstone dag Lecture
2
Advanced snowflake: Deploying the Capstone dag Lab
3
Advanced Snowflake: Data Modeling and UDFs Lecture
4
Advanced Snowflake: Data Modeling and UDFs Lab
Passing Analytics Engineer Interviews
1
SQL
Bonus
1
Complex Data Types Lecture
2
Complex Data Types Lab
3
Slowly Changing Dimensions Lecture
4
Slowly Changing Dimensions Lab
5
Graph Data Modeling Lecture
6
Graph Data Modeling Lab
7
Fact Data Modeling Lecture
8
Fact Data Modeling Lab
9
Data modeling with Date lists Lecture
10
Data modeling with Date lists Lab
Tech Talk
1
Tech talk with Andrew Madson
2
Tech talk with Gourav Khanijoe
3
Tech talk with Carly Taylor
4
Tech talk with Jess Ramos
5
Tech talk with Madison Schott
6
Tech talk with Vaishali Macwan
7
Tech talk with Tim Chan
TA Office Hours
1
Office Hour 1
2
Office Hour 2
3
Office Hour 3
4
Office Hour 4
Program Resources
See what you'll be working with
Homework overview
Weekly schedule
Before you join
Prerequisites
Basic SQL knowledge
Previous experience as data analyst, data engineer or data scientist
Enroll now
Oct 22, 2024 – Nov 18, 2024 · Starting soon
Payment plan
$1997.9
one-timeDuration4 weeks
StartsOct 22, 2024
Time commitment9 hrs / week
FormatLive Online
What's included
5 weeks of classes
8 hrs on dbt
8 hrs on Trino, Snowflake, and Iceberg
4 hrs on Airflow
Master 5 analytics interviews
Weekly Q&A with Zach
2x/week calls with industry leaders
Get career mentorship afterwards
Build a capstone project
Enroll now
Oct 22, 2024 – Nov 18, 2024 · Starting soon
Payment plan
$1997.9
one-timeDuration4 weeks
StartsOct 22, 2024
Time commitment9 hrs / week
FormatLive Online
What's included
5 weeks of classes
8 hrs on dbt
8 hrs on Trino, Snowflake, and Iceberg
4 hrs on Airflow
Master 5 analytics interviews
Weekly Q&A with Zach
2x/week calls with industry leaders
Get career mentorship afterwards
Build a capstone project
$1997.9one-time
One-time