# Boot Camp: Community Edition

> Join the free community boot camp that covers everything you need to know to go from junior data engineer to senior data engineer!

- Web page and enrollment: https://learn.dataexpert.io/program/free-community-boot-camp
- Starts: 2024-11-15
- Ends: 2026-07-31
- Content: 41 video lessons (26 h 31 min)
- Academy: DataExpert.io Community Academy

## About this program

Join the free community boot camp that covers everything you need to know to go from junior data engineer to senior data engineer!

## What you'll learn

- Six weeks covering Spark, Flink, Data Modeling, and more!
- Automatic Graded Homework
- Get Certified

## What's included

- Six weeks covering Spark, Flink, Data Modeling, and more!
- Automatic Graded Homework
- Get Certified

## Prerequisites

- Basic SQL and Python skills
- Exposure to Docker

## Skills

Airflow, Algorithms, Apache Iceberg, Apache Spark, APIs, AWS, CI/CD, Cloud Platforms, Communication, Databricks, Data Modeling, Data Structures, Data Visualization, Data Warehousing, Docker, ETL/ELT, Flink, GCP, Git, Hadoop, Kafka, Leadership, MLOps, MySQL, Postgres, Problem Solving, Python, PyTorch, SQL, Statistics, Tableau, Trino

## Instructors

- Zach Wilson — Founder at DataExpert.io

## Curriculum

### Bootcamp Orientation

- [Bootcamp Kickoff](https://learn.dataexpert.io/lesson/bootcamp-kickoff-yt.md) — 21 min
- [Boot Camp Database Setup](https://learn.dataexpert.io/lesson/boot-camp-database-setup-yt.md) — 20 min

### Dimensional Data Modeling

- [Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lecture](https://learn.dataexpert.io/lesson/dimensional-data-modeling-lecture-day-1-yt.md) — 43 min
- [Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab](https://learn.dataexpert.io/lesson/dimensional-data-modeling-lab-day-1-yt.md) — 41 min
- [Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lecture](https://learn.dataexpert.io/lesson/dimensional-data-modeling-day-2-lecture-yt.md) — 40 min
- [Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab](https://learn.dataexpert.io/lesson/dimensional-data-modeling-day-2-lab-yt.md) — 46 min
- [Dimensional Data Modeling: Graph Data Modeling Day 3 Lecture](https://learn.dataexpert.io/lesson/dimensional-data-modeling-day-3-lecture-yt.md) — 34 min
- [Dimensional Data Modeling: Graph Data Modeling Day 3 Lab](https://learn.dataexpert.io/lesson/dimensional-data-modeling-day-3-lab-yt.md) — 46 min

### Fact Data Modeling

- [Fact Data Modeling: Core Concepts, Deduplication Day 1 Lecture](https://learn.dataexpert.io/lesson/fact-data-modeling-day-1-lecture-yt.md) — 52 min
- [Fact Data Modeling: Practical Insights into Data Modeling Day 1 Lab](https://learn.dataexpert.io/lesson/fact-data-modeling-day-1-lab-yt.md) — 40 min
- [Fact Data Modeling: Core Elements in Data Modeling Day 2 Lecture](https://learn.dataexpert.io/lesson/fact-data-modeling-day-2-lecture-yt.md) — 31 min
- [Fact Data Modeling: Compact Tables for Efficient Data Representation Day 2 Lab](https://learn.dataexpert.io/lesson/fact-data-modeling-day-2-lab-yt.md) — 45 min
- [Fact Data Modeling: Minimizing Shuffle and Reducing Facts Day 3 Lecture](https://learn.dataexpert.io/lesson/fact-data-modeling-day-3-lecture-yt.md) — 32 min
- [Fact Data Modeling: Practical Guide to Formatting and Aggregating Data Day 3 Lab](https://learn.dataexpert.io/lesson/fact-data-modeling-day-3-lab-yt.md) — 31 min

### Apache Spark Fundamentals

- [Apache Spark: Architecture, Optimization, and Best Practices Day 1 Lecture](https://learn.dataexpert.io/lesson/apache-spark-day-1-lecture-yt.md) — 48 min
- [Apache Spark: Hands-On for Broadcast and Hash Joins Day 1 Lab](https://learn.dataexpert.io/lesson/apache-spark-day-1-lab-yt.md) — 27 min
- [Apache Spark: Managing Spark Jobs and Notebooks Day 2 Lecture](https://learn.dataexpert.io/lesson/apache-spark-day-2-lecture-yt.md) — 34 min
- [Apache Spark: User-Defined Functions and Broadcast Join Day 2 Lab](https://learn.dataexpert.io/lesson/apache-spark-day-2-lab-yt.md) — 36 min
- [Unit Testing Spark Jobs: Importance, Challenges, and Leadership Perspectives Lecture](https://learn.dataexpert.io/lesson/apache-spark-day-3-lecture-yt.md) — 42 min
- [Unit Testing Spark Jobs: Mastering Spark and PySpark Testing Lab](https://learn.dataexpert.io/lesson/apache-spark-day-3-lab-yt.md) — 27 min

### Applying Analytical Patterns

- [Applying Analytical Patterns: Exploring SQL, Scaling Projects and Aggregation Analysis Day 1 Lecture](https://learn.dataexpert.io/lesson/applying-analytical-patterns-day-1-lecture-yt.md) — 53 min
- [Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab](https://learn.dataexpert.io/lesson/applying-analytical-patterns-day-1-lab-yt.md) — 34 min
- [Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture](https://learn.dataexpert.io/lesson/applying-analytical-patterns-day-2-lecture-yt.md) — 45 min
- [Applying Analytical Patterns: Aggregations and Cardinality Reduction Day 2 Lab](https://learn.dataexpert.io/lesson/applying-analytical-patterns-day-2-lab-yt.md) — 34 min

### Real-time pipelines with Flink and Kafka

- [Flink Lab Setup](https://learn.dataexpert.io/lesson/flink-lab-setup-yt.md) — 7 min
- [Streaming Pipelines: Mastering Streaming and Real-time Pipelines Day 1 Lecture](https://learn.dataexpert.io/lesson/streaming-pipelines-day-1-lecture-yt.md) — 50 min
- [Streaming Pipelines: Setting up Streaming Pipelines Day 1 Lab](https://learn.dataexpert.io/lesson/streaming-pipelines-day-1-lab-yt.md) — 40 min
- [Streaming Pipelines: Exploring Data Collection and Processing Day 2 Lecture](https://learn.dataexpert.io/lesson/streaming-pipelines-day-2-lecture-yt.md) — 32 min
- [Streaming Pipelines: Kafka, Postgres, Spark Integrations and Parallelism Day 2 Lab](https://learn.dataexpert.io/lesson/streaming-pipelines-day-2-lab-yt.md) — 39 min

### Data Visualization and Impact

- [Data Visualization and Impact: Mastering Data Engineering Day 1 Lecture](https://learn.dataexpert.io/lesson/data-visualization-and-impact-day-1-lecture-yt.md) — 40 min
- [Data Visualization and Impact: Hands-On with the CSV files Day 1 Lab](https://learn.dataexpert.io/lesson/data-visualization-and-impact-day-1-lab-yt.md) — 9 min
- [Data Visualization and Impact: Insights and Best Practices Day 2 Lecture](https://learn.dataexpert.io/lesson/data-visualization-and-impact-day-2-lecture-yt.md) — 24 min
- [Data Visualization and Impact: Exploring Data Visualization and Aggregation Techniques Day 2 Lab](https://learn.dataexpert.io/lesson/data-visualization-and-impact-day-2-lab-yt.md) — 37 min

### Data Pipeline Maintenance

- [Data Pipeline Maintenance: Navigating the Complexities of Data Engineering Day 1 Lecture](https://learn.dataexpert.io/lesson/data-pipeline-maintenance-day-1-lecture-yt.md) — 1 h 7 min
- [Data Pipeline Maintenance: Strategies for Maintenance and Dock Building Day 2 Lecture](https://learn.dataexpert.io/lesson/data-pipeline-maintenance-day-2-lecture-yt.md) — 1 h 17 min

### KPIs and Experimentation

- [KPIs and Experimentation: Decoding Business Success: Metrics, Growth Strategies and Collaborative Approaches Day 1 Lecture](https://learn.dataexpert.io/lesson/kpis-and-experimentation-day-1-lecture-yt.md) — 56 min
- [KPIs and Experimentation: Setting up and Analysing Experiments Day 1 Lab](https://learn.dataexpert.io/lesson/kpis-and-experimentation-day-1-lab-yt.md) — 36 min
- [KPIs and Experimentation: Leading and Lagging Metrics Day 2 Lecture](https://learn.dataexpert.io/lesson/kpis-and-experimentation-day-2-lecture-yt.md) — 1 h 5 min

### Data Quality Patterns

- [Data Quality Patterns: MIDAS Process from Airbnb Day 1 Lecture](https://learn.dataexpert.io/lesson/data-quality-patterns-day-1-lecture-yt.md) — 45 min
- [Data Quality Patterns: Spec-Building Document Day 1 Lab](https://learn.dataexpert.io/lesson/data-quality-patterns-day-1-lab-yt.md) — 34 min
- [Data Quality Patterns: WAP Patterns Day 2 Lecture](https://learn.dataexpert.io/lesson/data-quality-patterns-day-2-lecture-yt.md) — 28 min
