Database Management Systems

SQL, transactions, indexing and normalization — how real systems store, protect and query data at scale.

intermediate~35 hours14 topics~23h of lessonsRoadmap Level 3

Nearly every real system is data-backed; understanding storage and querying decides how well it scales.

Learning Path
07 stages
14 topics · 7 stages0/14 completed
01

Fundamentals

Start from zero. Build the vocabulary.

What is a DBMS?~30 minbeginnerSQL Basics: SELECT, INSERT, UPDATE, DELETE~90 minbeginnerJoins and Aggregations~90 minbeginner
02

Core Concepts

The ideas you cannot skip.

Normalization (1NF–3NF)~90 minintermediateKeys and Constraints~45 minbeginnerIndexes and Query Performance~60 minintermediateTransactions and ACID~75 minintermediate
03

Intermediate

Connect ideas and go deeper.

Isolation Levels and Concurrency~60 minadvancedSubqueries, CTEs and Views~60 minintermediate
04

Advanced

Beyond the basics.

Query Optimization and EXPLAIN~60 minadvancedNoSQL Databases~60 minintermediate
05

Practice

Solve problems until it sticks.

Practice Set: SQL from basic to advanced~180 minintermediate
06

Projects

Apply everything in real work.

Project: Design a Database for an App~360 minintermediate
07

Interview Prep

Convert knowledge into offers.

DBMS Interview Questions~90 minadvanced