Projects

Three chained database projects: model the data, pipe real data into it, then tune it under load.

• 01
  Database Management

  Data Modeling: Visa-Sponsor Jobs

  Normalize a flat, real-world jobs dataset into a 3NF MySQL schema and build analytical SQL on top.

  MySQL3NF schema designERDWindow functionsCTEs
  Not started
• 02
  Database Management

  Data Engineering: Automated Ingestion Pipeline

  Airflow-orchestrated ETL that lands raw data in MinIO, transforms it, and loads it into MySQL on a schedule.

  AirflowETLMinIOData quality checks
  Not started
• 03
  Database Management

  DBA: Performance Tuning at Scale

  Load the schema with millions of synthetic rows and run a full slow-query diagnosis and tuning case study.

  EXPLAINIndexingBenchmarkingBackup/restore
  Not started