Skip to main content

SQL Roadmap 2026

Query, model and tune relational data: from SELECT to joins, window functions, transactions and indexes.

4 stages · 8 units · Beginner · about 70 hours · Last reviewed 19 November 2026

What is a sql?

SQL, short for Structured Query Language, is the standard language for working with relational databases. It is used to read data with SELECT, combine tables with joins, summarise with aggregates and window functions, change rows safely inside transactions and design schemas. It works across systems such as PostgreSQL, MySQL, SQL Server and SQLite, with minor dialect differences.

Step-by-step sql roadmap

  1. 1

    Query Basics

    Ask the database questions.

    • Reading Data

      Reading data in SQL means retrieving rows from tables with SELECT. You choose columns, filter rows with WHERE, sort with ORDER BY and limit output, then shape values using functions and expressions such as string, date and CASE logic. It is the first skill in SQL, because every report and analysis begins with a query.

    • Aggregating

      Aggregating in SQL means collapsing many rows into summary values using functions such as COUNT, SUM, AVG, MIN and MAX together with GROUP BY. HAVING filters the resulting groups, and set operators like UNION and INTERSECT combine the output of separate queries. It turns raw records into totals, averages and counts for reports.

  2. 2

    Multiple Tables

    Relate data across tables.

    • Joins

      Joins combine rows from two or more tables based on a related column, usually a foreign key matching a primary key. INNER, LEFT, RIGHT, FULL and CROSS joins differ in which unmatched rows are kept. Subqueries, including correlated ones and EXISTS, let one query use the result of another.

    • Modelling

      Data modelling in SQL is the design of tables, keys and relationships so data is stored once and stays consistent. Primary and foreign keys define links, constraints enforce rules, and normalisation, up to third normal form, removes redundancy that causes update anomalies. A good model makes queries simpler and prevents bad data.

  3. 3

    Advanced Querying

    Express complex logic.

    • Analytics SQL

      Analytics SQL covers features for complex analysis in a single query. Common table expressions, written with WITH, name intermediate results and enable recursion for hierarchies. Window functions such as ROW_NUMBER, RANK, LAG and running SUM OVER compute values across related rows without collapsing them, which suits rankings, trends and period comparisons.

    • Changing Data

      Changing data in SQL means writing to tables with INSERT, UPDATE and DELETE, and protecting those writes with transactions. A transaction groups statements so they all succeed or none do, following ACID properties. Isolation levels control what concurrent sessions can see, and getting this right prevents lost updates and corrupted records.

  4. 4

    Performance and Practice

    Make it fast and correct.

    • Performance

      SQL performance is about making queries return quickly as data grows. Indexes, most often B-tree, let the engine find rows without scanning the whole table, and the query plan from EXPLAIN shows how it will execute. Reading plans reveals missing indexes, poor join orders and costly sorts, so tuning is based on evidence.

    • Real Work

      Real work in SQL means using the language the way teams do on the job. Views save complex queries as reusable virtual tables, while stored procedures, functions and triggers keep logic inside the database. Practice projects, such as designing a library or shop schema and writing its reports, tie together modelling, querying and tuning.

Frequently asked questions

Ready to practise for interviews?

Practise sql questions with an AI mock interviewer and get feedback on your answers.

More roadmaps