JAJoseph Akinsanya
Free program

Reach Data Engineer Competence

Become employable as a data engineer

Sep 7 · 30 days 1 joined 26 tasks

The roadmap

Every task, day by day. This is exactly what you'll work through.

Week 1
Sep 7 – Sep 13
  • Install PostgreSQL and DBeaver
    Monday 7 Sep
  • Master Basic SQL Queries
    Tuesday 8 Sep
  • Practice SQL Joins and Subqueries
    Wednesday 9 Sep
  • Design a Relational Database Schema
    Thursday 10 Sep
  • Implement Your Database Schema in SQL
    Friday 11 Sep
  • Review SQL Fundamentals with Practice Problems
    Saturday 12 Sep
Week 2
Sep 14 – Sep 20
  • Set Up Python Development Environment
    Monday 14 Sep
  • Learn Python Data Structures and Functions
    Tuesday 15 Sep
  • Understand Object-Oriented Programming (OOP) in Python
    Wednesday 16 Sep
  • Interact with Files and APIs using Python
    Thursday 17 Sep
  • Connect Python to PostgreSQL Database
    Friday 18 Sep
  • Develop a Basic Data Extraction Script
    Saturday 19 Sep
Week 3
Sep 21 – Sep 27
  • Set Up AWS Free Tier Account & CLI
    Monday 21 Sep
  • Explore AWS S3 for Data Storage
    Tuesday 22 Sep
  • Provision an EC2 Instance
    Wednesday 23 Sep
  • Automate EC2 Setup with User Data
    Thursday 24 Sep
  • Introduction to AWS RDS (PostgreSQL)
    Friday 25 Sep
  • Deploy a Simple Python Script to EC2
    Saturday 26 Sep
Week 4
Sep 28 – Oct 4
  • Understand ETL/ELT Concepts & Data Pipelines
    Monday 28 Sep
  • Set Up Apache Airflow Locally via Docker
    Tuesday 29 Sep
  • Develop Your First Airflow DAG
    Wednesday 30 Sep
  • Integrate Python Operators & Data Dependencies
    Thursday 1 Oct
  • Schedule & Monitor Airflow DAGs
    Friday 2 Oct
  • Implement Error Handling & Retries in Airflow
    Saturday 3 Oct
Week 5
Oct 5 – Oct 11
  • Outline a Personal Data Engineering Project
    Monday 5 Oct
  • Update LinkedIn Profile & Seek Opportunities
    Tuesday 6 Oct
Free to join
1 already in · 26 tasks
Join program