All roadmaps

Placement ready

Fresher placement path

The shortest route from zero to placement-ready: Python basics, SQL, then problems and interview questions.

  • about 8 weeks at an hour a day
  • 4 stages, 30 steps
Start step 1See the roadmap

Python from zero

about 2 weeks · 8 steps

After this stage: You can write, run and fix a short Python program.

  1. Your first Python programLessonFreeRun code and read an error before anything else.01
  2. Variables, types and type hintsLessonLockedText, numbers and converting between them.02
  3. Lists, dictionaries and setsLessonLockedThe containers almost every test question uses.03
  4. Decisions and loopsLessonLockedif, for and while, the core of coding rounds.04
  5. Functions, modules and importsLessonLockedWrite code in reusable pieces.05
  6. Strings and textLessonLockedSlicing, splitting and formatting, asked in most coding tests.06
  7. Control flow and error handlingLessonLockedtry and except, and what to do when input is wrong.07
  8. Reading and writing filesLessonLockedOpen a file, read it and write results back.08

SQL and databases

about 2 weeks · 11 steps

After this stage: You can read a table and answer a question about it with a query.

  1. SQL: what is data?LessonFreeStart SQL from what a table is.09
  2. Primary keys and foreign keysLessonFreeHow tables point at each other.10
  3. SQL aggregations and groupingLessonLockedCOUNT, SUM and GROUP BY, asked in most interviews.11
  4. SQL multi-table joinsLessonLockedCombine tables without repeating or losing rows.12
  5. Case study: where does the revenue come from?Case studyA whole analysis on 180 orders, step by step.13
  6. Relational basicsLessonLockedSELECT, WHERE, ORDER BY and LIMIT.14
  7. NULL handlingLessonLockedWhy NULL breaks comparisons and how to handle it.15
  8. Subqueries and CTEsLessonLockedBreak a hard question into steps.16
  9. CASE expressionsLessonLockedIf-then-else inside a query.17
  10. Window functionsLessonLockedRank rows without losing them, a favourite interview topic.18
  11. SQL that changes dataLessonLockedINSERT, UPDATE, DELETE and CREATE TABLE.19

Practise until it is quick

about 3 weeks · 6 steps

After this stage: You solve most easy problems in one sitting.

  1. Python 100 practice sheetPractice100 ordered problems. The first ones in each topic are free.20
  2. SQL 50 practice sheetPractice50 ordered SQL problems from SELECT to window functions.21
  3. Daily problemToolOne free problem a day keeps the habit.22
  4. Hash maps and frequency countingLessonLockedThe pattern behind many array and string questions.23
  5. Two pointersLessonLockedScan an array from both ends.24
  6. Sorting and binary searchLessonLockedSearch a sorted list fast.25

Interview round

about 1 week · 5 steps

After this stage: You can explain what you wrote and answer the common questions.

  1. SQL questions for freshersInterviewRead the answers, then explain them aloud.26
  2. Python questions for freshersInterviewThe beginner questions with full answers.27
  3. DBMS questions for freshersInterviewKeys, normalization and transactions, a standard campus topic.28
  4. Mock interviewToolPractise out loud and get scored.29
  5. SQL certificate examToolA timed exam that gives you a link to share.30

After this roadmap