FreeCodingCourses
Roadmap
3–6 months
4 phases
~23 weeks

SQL & Databases Roadmap

SQL is one of the fastest high-return skills to learn. This roadmap takes you from your first SELECT query to database design, analytics, and production database management.
Follow the learning path →All Roadmaps

  1. Phase 1:SQL Fundamentals

    beginner
    1 week

    SELECT & WHERE

    Retrieve data from tables with filters, sorting, and limiting results.

    beginner
    1 week

    Aggregations

    COUNT, SUM, AVG, MIN, MAX, and GROUP BY for summarizing data.

    intermediate
    2 weeks

    JOINs

    Combine data from multiple tables with INNER, LEFT, RIGHT, and FULL JOINs.

    intermediate
    2 weeks

    Subqueries & CTEs

    Write nested queries and Common Table Expressions for complex analysis.

  2. Phase 2:Advanced SQL

    intermediate
    2 weeks

    Window Functions

    ROW_NUMBER, RANK, LEAD, LAG, and running totals for analytical queries.

    intermediate
    1 week

    Date & Time Functions

    Work with timestamps, date arithmetic, and time-based analysis.

    intermediate
    1 week

    String Manipulation

    CONCAT, SUBSTRING, REGEXP, and transforming text data in SQL.

  3. Phase 3:Database Design

    intermediate
    2 weeks

    Normalization

    1NF, 2NF, 3NF. Design schemas that minimize redundancy and anomalies.

    intermediate
    2 weeks

    Indexes

    Speed up queries with the right indexes. Understand query execution plans.

    advanced
    1 week

    Transactions & ACID

    Ensure data consistency with transactions, rollbacks, and isolation levels.

  4. Phase 4:Real-World Application

    intermediate
    2 weeks

    PostgreSQL

    The most feature-rich open-source database: JSON support, full-text search, extensions.

    intermediate
    2 weeks

    SQL in Python

    Use SQLAlchemy or psycopg2 to query databases from Python scripts.

    intermediate
    4 weeks

    Analytics Projects

    Build 2 end-to-end data analysis projects using real-world datasets.

Next steps

Keep exploring

Languages in this roadmap

SQLPython

Follow the SQL & Databases learning path

The same plan step by step, with a specific free course for each stage.

Compare all 22 free platforms

See how the platforms behind these courses stack up side by side.

See all roadmaps

Browse every career roadmap we have mapped.

Other goals

More Roadmaps

Web DeveloperView →Frontend DeveloperView →Backend DeveloperView →PythonView →