Analytics Engineering Boot Camp starting October 2024
Overview
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
Prerequisites
- Basic SQL knowledge
- Previous experience as data analyst, data engineer or data scientist
Contents
Bootcamp Kickoff
3 Lessons (2h 10m)
Pipeline Spec Building + Airflow Fundamentals
8 Lessons (5h 36m)
1 Assignment
Change Data Capture (CDC) and Analytical Patterns
8 Lessons (5h 30m)
1 Assignment
dbt basics
4 Lessons (2h 36m)
1 Assignment
Advanced dbt
4 Lessons (2h 40m)
1 Assignment
Advanced Snowflake
4 Lessons (2h 38m)
1 Assignment
Passing Analytics Engineer Interviews
5 Lessons (2h 34m)
2 Assignments
Bonus
6 Lessons (3h 58m)
Tech Talk
7 Lessons (5h 40m)
TA Office Hours
4 Lessons (3h 56m)
Community Engagement
2 Lessons (1h 50m)