How to use the SQL Learning Roadmap
- 1. Tick what you knowOpen each stage and tick the topics you can already do confidently.
- 2. Pick your paceChoose how many hours a week you can study; the estimate updates for what's left.
- 3. Get your planSee time left per stage and your next three topics, and download the checklist.
Who this roadmap is for
SQL is used by analysts, developers, testers and product managers alike. This roadmap suits complete beginners and people who know SELECT but get stuck on joins or window functions.
It's shorter than a career roadmap because SQL is one skill, not a whole job. A steady learner can cover it in a few months alongside other study, and the practice milestones are what make it stick.
The 8 stages
Each of the 8 stages of the SQL path ends with a milestone project, because building something is what turns topics into skills.
- Relational basics (about 1 week): Tables, rows, columns and data types, Primary and foreign keys, Installing a database or using an online compiler and more. Milestone: Draw the schema for a college database.
- Querying one table (about 2 weeks): SELECT, WHERE, ORDER BY, LIMIT, Comparison, LIKE, IN, BETWEEN, IS NULL, Aggregates: COUNT, SUM, AVG, MIN, MAX and more. Milestone: Answer 20 questions on a single sales table.
- Joins (about 2 weeks): INNER JOIN and how matching works, LEFT and RIGHT joins, finding missing rows, Self joins and many-to-many tables and more. Milestone: Answer 15 multi-table questions on an orders database.
- Subqueries and CTEs (about 2 weeks): Subqueries in WHERE and FROM, Correlated subqueries, EXISTS vs IN and more. Milestone: Rewrite five subquery answers as CTEs.
- Window functions (about 2 weeks): ROW_NUMBER, RANK, DENSE_RANK, PARTITION BY and ORDER BY in windows, Running totals and moving averages and more. Milestone: Top 3 products per month and month-on-month growth.
- Changing data and design (about 2 weeks): INSERT, UPDATE, DELETE safely, CREATE TABLE, constraints and ALTER, Normalisation to 3NF and more. Milestone: Design and populate a booking system schema.
- Performance (about 1 week): Indexes and how they help, Reading EXPLAIN plans, Avoiding SELECT * and functions on indexed columns and more. Milestone: Speed up one slow query with an index and compare plans.
- Job ready (about 2 weeks): Practise interview-style SQL questions daily, Explain your query step by step out loud, SQL in Python with pandas or SQLAlchemy and more. Milestone: Analysis project: 10 business questions answered in SQL.
How the time estimate works
Worked example: with nothing ticked and 10 hours a week, the plan shows about 14 weeks for all 34 topics. Choose 20 hours a week and it becomes about 7 weeks. Tick every topic in the first stage, Relational basics, and that row shows "done" while the total at 10 hours a week drops by 1 week to about 13.
Week counts are our suggestion for steady self-study of the SQL path, based on how much each stage covers. They are not survey data or a promise; use them to plan, not to judge yourself.
Tips for following it
- Write queries every day, even three short ones; SQL fluency comes from repetition.
- Before running a query, say what rows you expect back. It catches join mistakes early.
- Learn one database well (PostgreSQL or MySQL); the differences are small.
Frequently asked questions
Which database should I use to practise?
Any of PostgreSQL, MySQL or SQLite works. Our online SQL compiler runs SQLite in your browser with nothing to install.
Are window functions really asked in interviews?
They come up often in analyst and data engineer interviews, especially ranking and running-total questions.
Where are my ticks saved?
Your SQL Learning Roadmap ticks are kept only in this browser on this device, so nothing you tick is sent anywhere. Clearing site data or switching browsers starts you fresh; download your checklist to keep a copy.
Is the SQL Learning Roadmap free?
Yes. Reading the SQL Learning Roadmap and ticking topics is open to everyone. Viewing your plan the first time asks for your name and WhatsApp number once; after that every Uncodemy tool is free and open to you.