Roadmaps Companies Jobs

Sign in Sign up

Opening page…

Opening page…

Keep it in your account.

Your progress is saved securely and available when you return.

Sign in Create a free account

contentintech© 2026

Lessons Roadmaps Cheatsheets Jobs Tools Blog Privacy

DBMS

A complete DBMS course for interviews: ER modelling, SQL to window functions, normalization, indexing, transactions, concurrency, recovery and NoSQL.

1Modelling

DBMS Basics~28 min read ER Model~28 min read Relational Model~26 min read

2SQL

SQL Basics~24 min read Advanced SQL~24 min read

3Design and storage

Normalization~33 min read Indexing~34 min read

4Transactions

Transactions~26 min read Concurrency Control~30 min read Recovery~27 min read

5Beyond the basics

Query Optimization~27 min read NoSQL and Distribution~24 min read Schema Design~23 min read Interview Questions~34 min read

Your preparation pack

Free · Self-paced

14 lessons in 5 modules

Explain why databases exist and how a DBMS is organised
Model a system with an ER diagram and map it to tables
Write interview-level SQL including joins and window functions
Normalize schemas, find candidate keys and design indexes
Test schedules for serializability
Explain locking, MVCC, isolation levels and recovery
Choose between SQL and NoSQL and design real schemas

Exercises support self-assessment. This free pack does not award a certificate or guarantee placement.