Learning paths

Pick the job you want. Follow the roadmap.

Each path is split into stages. Every stage says what you will be able to do, then lists the lessons, practice and case studies to get there, in order. Nothing to assemble yourself.

Placement readyFresher placement pathThe shortest route from zero to placement-ready: Python basics, SQL, then problems and interview questions.
1. 1Python from zero2 wk
2. 2SQL and databases2 wk
3. 3Practise until it is quick3 wk
4. 4Interview round1 wk
about 8 weeks30 stepsFor: Graduate engineer trainee, Junior developer, Associate analystOpen roadmap
Data analystData analyst pathQuery data with SQL, then clean and summarise it with Python and Pandas, and finish with real business questions.
1. 1Read and summarise tables with SQL3 wk
2. 2Clean and reshape with Pandas3 wk
3. 3Think and check like an analyst2 wk
4. 4Understand warehouse data2 wk
5. 5Business questions end to end3 wk
6. 6Get hired1 wk
about 14 weeks54 stepsFor: Data analyst, Business analyst, Product analystOpen roadmap
SQL developerSQL developer pathGo from your first SELECT to joins, CTEs, window functions and fast queries, with practice at every stage.
1. 1How databases work1 wk
2. 2Query like a developer3 wk
3. 3Change data safely2 wk
4. 4Fast and correct2 wk
5. 5Design the schema3 wk
6. 6Interview round1 wk
about 12 weeks39 stepsFor: SQL developer, Database developer, Backend developerOpen roadmap
Python developerPython developer pathBuild Python from the first program to files, JSON, APIs and tested scripts.
1. 1Python basics3 wk
2. 2Real inputs and outputs3 wk
3. 3Write code others can trust3 wk
4. 4Production habits3 wk
5. 5Coding rounds2 wk
about 14 weeks47 stepsFor: Python developer, Automation engineer, Junior backend developerOpen roadmap
Data engineerData engineer pathFrom SQL and Python to pipelines, Spark and the cloud, in the order a first data engineering job asks for them.
1. 1SQL you can rely on4 wk
2. 2Python for pipelines4 wk
3. 3Pipelines and orchestration3 wk
4. 4Warehouse, Spark and quality4 wk
5. 5Cloud, projects and interviews3 wk
about 18 weeks37 stepsFor: Data engineer, Associate data engineer, ETL developerOpen roadmap
Analytics engineerAnalytics engineer pathTurn raw tables into clean, tested models that analysts can trust, using SQL and dbt.
1. 1Strong SQL3 wk
2. 2Model the data3 wk
3. 3Build with dbt3 wk
4. 4Trust the numbers2 wk
5. 5Run it on a schedule2 wk
about 13 weeks52 stepsFor: Analytics engineer, BI developer, Data modellerOpen roadmap
PySpark developerPySpark developer pathUse the SQL and Python you know on data too big for one machine.
1. 1Know the basics first3 wk
2. 2Spark DataFrames3 wk
3. 3Joins, windows and nested data3 wk
4. 4Fast and production ready3 wk
5. 5Streaming and production3 wk
about 15 weeks38 stepsFor: PySpark developer, Big data engineer, Databricks developerOpen roadmap

Want a fixed daily plan?

The 45-day plan gives you one task for each day.

Want the full topic list?

The roadmap shows every data engineering topic in order.

Want to practise on real questions?

Case studies start with a story and explain each step.