Roadmaps
Pick the job you want. Follow its roadmap.
Every roadmap lists what to learn and in what order, using lessons, practice and projects already on LakeBench. Choose the role closest to where you want to be.
Data engineer
From your first SELECT to a pipeline design you can defend. 7 phases and 106 topics covering SQL, Python, Spark, cloud, orchestration, dbt, streaming and system design.
Open the roadmap- 01Foundation
- 02Data Systems & Modeling
- 03Orchestration & Reliability
- 04Analytics Engineering & Quality
- 05Cloud & Streaming
- 06Infrastructure & Production Engineering
- 07System Design & Career
Other roles
Data analyst
Query data with SQL, clean and summarise it with Python and Pandas, learn the statistics behind a trustworthy number, and finish with real business questions.
- Read and summarise tables with SQL3 wk
- Clean and reshape with Pandas3 wk
- Think and check like an analyst2 wk
- Statistics every analyst needs3 wk
- Understand warehouse data2 wk
- Business questions end to end3 wk
- Get hired1 wk
about 17 weeks64 steps
Open roadmapSQL developer
Go from your first SELECT to joins, CTEs, window functions and fast queries, with practice at every stage.
- How databases work1 wk
- Query like a developer3 wk
- Change data safely2 wk
- Fast and correct2 wk
- Design the schema3 wk
- Interview round1 wk
about 12 weeks39 steps
Open roadmapPython developer
Build Python from the first program to files, JSON, APIs and tested scripts.
- Python basics3 wk
- Real inputs and outputs3 wk
- Write code others can trust3 wk
- Production habits3 wk
- Coding rounds2 wk
about 14 weeks47 steps
Open roadmapAnalytics engineer
Turn raw tables into clean, tested models that analysts can trust, using SQL and dbt.
- Strong SQL3 wk
- Model the data3 wk
- Build with dbt3 wk
- Trust the numbers2 wk
- Run it on a schedule2 wk
about 13 weeks52 steps
Open roadmapPySpark developer
Use the SQL and Python you know on data too big for one machine.
- Know the basics first3 wk
- Spark DataFrames3 wk
- Joins, windows and nested data3 wk
- Fast and production ready3 wk
- Streaming and production3 wk
about 15 weeks38 steps
Open roadmapPlacement ready
The shortest route from zero to placement-ready: Python basics, SQL, then problems and interview questions.
- Python from zero2 wk
- SQL and databases2 wk
- Practise until it is quick3 wk
- Interview round1 wk
about 8 weeks30 steps
Open roadmap
Want one task a day instead? See the 45-day plan.