Databases & DBMS

Every step on this roadmap

5 stages · 10 articles · 7 scenes · 5 quizzes

1. STAGE 01Foundations

   The relational model, tables, keys, and writing your first SQL queries.

   1. ArticleDatabases & DBMS: SQL, ACID & Indexing
   2. ArticleSQL Basics: CREATE, SELECT, UPDATE & DELETE
   3. QuizReadiness Check

2. STAGE 02Advanced SQL

   Joins, aggregates, subqueries — the tools for real-world queries.

   1. ArticleSQL Joins, Subqueries & Window Functions
   2. SceneINNER JOIN vs LEFT JOIN
   3. SceneThe N+1 Query Problem: 101 Trips or One JOIN
   4. QuizReadiness Check

3. STAGE 03Design & Transactions

   Schema design, normalisation, and making data changes safe.

   1. ArticleDatabase Design: ER Diagrams & Normalisation
   2. ArticleTransactions, ACID & Concurrency Control
   3. SceneTransaction Isolation Levels
   4. QuizReadiness Check

4. STAGE 04Performance

   How indexes work internally, query planning, and making queries fast.

   1. ArticleDatabase Indexes & Query Optimisation
   2. SceneFull Table Scan vs B-Tree Index
   3. ArticleQuery Processing & Optimisation: Parse, Plan & Execute
   4. SceneParse, Plan, Execute, and the Statistics Behind It
   5. QuizReadiness Check

5. STAGE 05Advanced DBMS

   Beyond SQL: NoSQL stores, stored procedures, triggers, and replication.

   1. ArticleNoSQL Databases: Document, Key-Value, Column & Graph Stores
   2. SceneCAP in Practice: Seven Systems, Pick Two
   3. ArticleStored Procedures, Triggers & Views
   4. ArticleDatabase Replication: Leader-Follower, Multi-Leader & Consensus
   5. SceneReplication Lag: One Write, Four Different Answers
   6. QuizReadiness Check

← All CS Fundamentals roadmaps