Free program
Learn Data engineering
Learn data engineering. Learn python. And build pipelines.
Sep 4 · 30 days 1 joined 26 tasks
The roadmap
Every task, day by day. This is exactly what you'll work through.
Week 1
Sep 4 – Sep 10
- Install essential data engineering toolsFriday 4 Sep
- Understand core relational database conceptsSaturday 5 Sep
- Practice basic SQL queries (SELECT, FROM, WHERE)Monday 7 Sep
- Master SQL data manipulation (INSERT, UPDATE, DELETE)Tuesday 8 Sep
- Explore data types and table creation in SQLWednesday 9 Sep
- Design a basic data model for a small projectThursday 10 Sep
Week 2
Sep 11 – Sep 17
- Set up your Python development environmentFriday 11 Sep
- Understand Python basics for data handlingSaturday 12 Sep
- Perform basic data operations with PandasMonday 14 Sep
- Read and write data from CSV/Excel using PandasTuesday 15 Sep
- Connect Python to your SQL databaseWednesday 16 Sep
- Build a basic Python script for ETL (Extract, Transform, Load)Thursday 17 Sep
Week 3
Sep 18 – Sep 24
- Set up your AWS Free Tier accountFriday 18 Sep
- Create and manage an S3 bucket for data storageSaturday 19 Sep
- Understand object storage concepts and S3 featuresMonday 21 Sep
- Launch your first EC2 instance (virtual server)Tuesday 22 Sep
- Connect to and configure your EC2 instanceWednesday 23 Sep
- Transfer files between your local machine and EC2/S3Thursday 24 Sep
Week 4
Sep 25 – Oct 1
- Explore Docker for containerizing applicationsFriday 25 Sep
- Containerize your Python ETL script with DockerSaturday 26 Sep
- Set up a data warehouse in AWS RedshiftMonday 28 Sep
- Load data into Redshift from S3 using PythonTuesday 29 Sep
- Explore Apache Airflow for workflow orchestrationWednesday 30 Sep
- Schedule your ETL workflow with AirflowThursday 1 Oct
Week 5
Oct 2 – Oct 8
- Develop a simple data pipeline project summaryFriday 2 Oct
- Reflect on your data engineering journey and next stepsSaturday 3 Oct