Get Support

Roadmap & Syllabus

Databases & SQL Roadmap

Every application depends on its data. Learn to design schemas, write efficient queries and choose the right database for the job — a skill every developer interview tests.

Start the roadmap Download PDF
  • SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • Redis
  • Indexes
  • Data modelling

Learning path

Choose where you are today

Each path is written for a different starting point.

Freshers & Students

Starting from the basics and preparing for a first developer job.

Write correct, readable SQL and design simple schemas with confidence.

Approximate duration2–3 months

  1. Relational Basics & Queries

    4 weeks
    • Keys, constraints and normalization
    • SELECT, filters and sorting
    • Joins and aggregations

    Milestone: Answer real business questions with SQL.

  2. Interview SQL

    3 weeks
    • Subqueries and CTEs
    • Nth highest salary, duplicates, running totals
    • Practise 50+ query problems

    Milestone: Solve common SQL interview problems without help.

  3. Using a Database from Code

    2 weeks
    • Connect from Java (JDBC/JPA) or Node.js
    • Basic MongoDB CRUD

    Milestone: Read and write data from your own application.

Want it offline? Download the Databases & SQL roadmap (PDF) — includes all three paths and the complete syllabus.

Projects to build

  • Schema and queries for a college or hospital system
  • Sales report queries with joins and aggregations
  • Small app backed by MySQL or PostgreSQL

Complete syllabus

Databases & SQL syllabus

Everything this track covers, grouped by topic. Use it as a checklist.

01 Relational Basics

  • Tables, rows, columns and data types
  • Primary and foreign keys
  • Constraints
  • Normalization (1NF–3NF)

02 SQL Queries

  • SELECT, WHERE, ORDER BY
  • Joins (inner, left, right, self)
  • GROUP BY and HAVING
  • Subqueries and CTEs
  • CASE expressions

03 Advanced SQL

  • Window functions: ROW_NUMBER, RANK, LAG
  • Views
  • Stored procedures and functions
  • Common interview queries

04 Performance

  • Indexes and how they work
  • Reading EXPLAIN plans
  • Avoiding N+1 queries
  • Pagination strategies

05 Transactions

  • ACID properties
  • Isolation levels
  • Locking and deadlocks

06 NoSQL

  • MongoDB documents and schema design
  • Aggregation pipeline
  • Redis for caching
  • SQL vs NoSQL trade-offs

07 Operations

  • Backups and restore
  • Replication basics
  • Migrations
  • Security and access control

Where it leads

Roles this track prepares you for

  • Backend Developer
  • Database Developer
  • Data Analyst
  • Full Stack Developer

Durations are approximate and assume about 2–3 hours of focused study a day. Move faster or slower as you need — understanding matters more than speed.

Want guidance along the way?

A roadmap tells you what to learn. Guidance helps you learn it in the right depth, practise with real interview questions and explain your projects with confidence.

Java Full Stack support Ask a question

Roadmaps are for learning guidance. They do not guarantee jobs or placements.

Explore more

Other roadmaps

Java Full StackJava, Spring Boot, SQL and Angular or ReactMEAN StackMongoDB, Express.js, Angular and Node.jsMERN StackMongoDB, Express.js, React and Node.jsFrontend DevelopmentHTML, CSS, JavaScript, TypeScript, Angular and ReactBackend DevelopmentJava/Spring Boot or Node.js, APIs, security and scalabilityDevOps & CloudLinux, Git, CI/CD, Docker, Kubernetes, AWS and TerraformAI & Generative AI for DevelopersPython, machine learning basics, LLMs, RAG and AI agents

Prepare. Perform. Progress.

Turn the Databases & SQL roadmap into your plan

Share your background and goals, and we will help you decide what to focus on first.

Get a personal plan Chat on WhatsApp
Chat with us