Python · SQL · Web Dev · Java · AI/ML tracks launching soon — your one platform for all of IT

CS CoreBeginner+100 XP

Database Management Systems (DBMS)

Complete track from absolute zero — ER diagrams, normalization, SQL, indexes, transactions, B+ trees, distributed databases, NoSQL, and interview prep.

20 modules March 2026

Advanced DSA Topics Introduction to Databases

20Total Modules

20Live Now

SQL + TheoryLanguage

Zero to AdvancedAudience

GATE + PlacementsExam Coverage

💡 Note

No prior knowledge needed — zero. This track is built for freshers, career switchers, and non-IT backgrounds. If you know what a spreadsheet is, you have everything you need to start. DBMS is taught in every CS/IT degree — but most explanations are textbook-heavy and confusing. This track explains it the way a senior engineer would explain it to you over chai.

// Track Phases

Phase 1 — Foundations(01–04)

Phase 2 — Design & SQL(05–08)

Phase 3 — Internals(09–12)

Phase 4 — Advanced Theory(13–16)

Phase 5 — Distributed & Interview(17–20)

MODULE 01LIVEPhase 1 — Foundations

Introduction to Databases & DBMS

What a database actually is, the 6 problems it solves, DBMS vs Database vs Database System, types of databases, and why this shows up in every interview.

What is a Database?File System ProblemsDBMS SoftwareTypes of DatabasesWhat DBAs Do

⏱ 25–30 min

Absolute Beginner

MODULE 02LIVEPhase 1 — Foundations

Data Models

The blueprint that decides how data is stored and connected — hierarchical, network, relational, object, and document models explained with real analogies.

Hierarchical ModelNetwork ModelRelational ModelDocument ModelWhy Relational Won

⏱ 20–25 min

Beginner

MODULE 03LIVEPhase 1 — Foundations

Entity-Relationship (ER) Model

Design a database visually before writing a single line of SQL. Entities, attributes, relationships, cardinality, weak entities — drawn step by step.

Entities & AttributesRelationships & CardinalityStrong vs Weak EntitiesDrawing ER DiagramsER to Tables

⏱ 35–40 min

Beginner

MODULE 04LIVEPhase 1 — Foundations

Relational Model & Keys

Tables, tuples, domains, integrity constraints — and every type of key explained clearly: Super, Candidate, Primary, Foreign, Composite, Surrogate.

Relations & TuplesSchema vs InstanceSuper & Candidate KeysPrimary & Foreign KeysIntegrity Constraints

⏱ 30–35 min

Beginner

MODULE 05LIVEPhase 2 — Design & SQL

Normalization — 1NF to 5NF

The most important theory topic in DBMS. Eliminate every database design mistake before it causes real problems — insert, update, and delete anomalies explained.

Insert/Update/Delete Anomalies1NF · 2NF · 3NFBCNF · 4NF · 5NFStep-by-Step NormalizationWhen to Denormalize

⏱ 45–55 min

Beginner

MODULE 06LIVEPhase 2 — Design & SQL

Functional Dependencies

The math behind normalization. X → Y means X determines Y. Armstrong's Axioms, attribute closure, canonical cover, and finding candidate keys using FDs.

Armstrong's AxiomsTrivial vs Non-Trivial FDsAttribute Closure (F+)Canonical CoverFinding Candidate Keys

⏱ 30–35 min

Intermediate

MODULE 07LIVEPhase 2 — Design & SQL

SQL — Complete Guide

From your very first SELECT to window functions and recursive CTEs. DDL, DML, DCL, TCL, all joins, subqueries, aggregations, GROUP BY, HAVING — nothing skipped.

DDL · DML · DCL · TCLSELECT & WHEREAll JOIN TypesWindow FunctionsCTEs & Subqueries

⏱ 90–120 min

Beginner → Advanced

MODULE 08LIVEPhase 2 — Design & SQL

Indexes

Why queries slow down at scale, how indexes fix it, B+ tree vs hash index, clustered vs non-clustered, covering indexes, and when NOT to add an index.

How Indexes WorkB+ Tree IndexClustered vs Non-ClusteredComposite & Covering IndexesWhen NOT to Index

⏱ 35–40 min

Intermediate

MODULE 09LIVEPhase 3 — Internals

Transactions & ACID Properties

All-or-nothing units of work. The bank transfer example that makes ACID click instantly — Atomicity, Consistency, Isolation, Durability — with real failure scenarios.

What is a Transaction?AtomicityConsistencyIsolationDurability · COMMIT · ROLLBACK

⏱ 30–35 min

Intermediate

MODULE 10LIVEPhase 3 — Internals

Concurrency Control

How databases handle thousands of simultaneous users safely. Locks, deadlocks, isolation levels, Two-Phase Locking, and MVCC — the engine inside PostgreSQL.

Lost Update · Dirty Read · Phantom ReadShared & Exclusive LocksTwo-Phase Locking (2PL)Deadlock DetectionIsolation Levels · MVCC

⏱ 40–45 min

Intermediate

MODULE 11LIVEPhase 3 — Internals

Query Processing & Optimization

What actually happens the moment you press Enter on a query — parsing, planning, optimization, execution. Then how to make it 10x faster using EXPLAIN.

Parsing → Planning → ExecutionQuery OptimizerEXPLAIN & EXPLAIN ANALYZESequential vs Index ScanReal Optimization Examples

⏱ 35–40 min

Intermediate

MODULE 12LIVEPhase 3 — Internals

Storage & File Organization

How data physically lives on disk — blocks, pages, buffer pool, heap files, sequential files. Understanding this is what separates developers from engineers.

Blocks & PagesBuffer Pool & CacheHeap File OrganizationSequential & Hash OrganizationWhy This Affects Query Speed

⏱ 30–35 min

Intermediate

MODULE 13LIVEPhase 4 — Advanced Theory

Hashing & B+ Trees

The two most important data structures inside every database. Static and dynamic hashing for fast lookups, B+ tree structure for range queries and indexes.

Static & Dynamic HashingCollision HandlingB+ Tree StructureSearch · Insert · DeleteWhy B+ Tree is the Standard

⏱ 40–45 min

Intermediate

MODULE 14LIVEPhase 4 — Advanced Theory

Relational Algebra

The mathematics SQL is built on. Select, Project, Join, Union, Difference, Division — shown with plain English explanations and direct SQL equivalents.

Select (σ) & Project (π)Union · Intersection · DifferenceCartesian Product & JoinDivision (÷)Mapping RA to SQL

⏱ 30–35 min

Intermediate

MODULE 15LIVEPhase 4 — Advanced Theory

Views, Stored Procedures & Triggers

Database objects that encapsulate logic — virtual tables, pre-compiled SQL procedures, and triggers that run automatically on INSERT/UPDATE/DELETE.

Views & Materialized ViewsStored Procedures vs FunctionsTriggers — BEFORE & AFTERCursorsReal Use Cases at Companies

⏱ 35–40 min

Intermediate

MODULE 16LIVEPhase 4 — Advanced Theory

Crash Recovery

How databases survive power failures, OS crashes, and hardware failures without losing a single committed transaction. WAL, checkpoints, and the ARIES algorithm.

Write-Ahead Logging (WAL)Undo & Redo LogsCheckpointsARIES AlgorithmWhat Happens at 3am When DB Crashes

⏱ 30–35 min

Advanced

MODULE 17LIVEPhase 5 — Distributed & Interview

Distributed Databases & CAP Theorem

Data across multiple machines — fragmentation, replication, two-phase commit, and the CAP theorem that every system design interview asks about.

Horizontal & Vertical FragmentationReplication StrategiesTwo-Phase Commit (2PC)CAP TheoremCA · CP · AP Real Examples

⏱ 35–40 min

Advanced

MODULE 18LIVEPhase 5 — Distributed & Interview

NoSQL Databases

When and why to break away from relational — MongoDB, Redis, Cassandra, Neo4j explained clearly. The SQL vs NoSQL decision framework for real projects.

Document Stores — MongoDBKey-Value — RedisColumn-Family — CassandraGraph — Neo4jSQL vs NoSQL Decision Framework

⏱ 35–40 min

Advanced

MODULE 19LIVEPhase 5 — Distributed & Interview

Database Security

Protecting data at every layer — authentication, authorization, roles, SQL injection attacks and exactly how to prevent them, encryption, and auditing.

Authentication vs AuthorizationGRANT & REVOKESQL Injection — How & PreventionEncryption at Rest & in TransitAuditing & Row-Level Security

⏱ 25–30 min

Intermediate

MODULE 20LIVEPhase 5 — Distributed & Interview

Interview Questions — All 60

60 DBMS questions categorized by company type. TCS/Wipro/Infosys for campus placements, Flipkart/Swiggy for product companies, and GATE-level for competitive exams.

Service Company Questions (TCS, Wipro)Product Company Questions (Flipkart, Swiggy)GATE CS Level QuestionsSystem Design DB QuestionsAnswers with Explanations

⏱ 60–90 min

All Levels

// Ready to start?

Modules dropping every week.

Start with Module 01 right now — no prior database knowledge needed. Every module builds on the previous one, in the exact order it should be learned.

Start Module 01 →Interview Prep →

What to learn next

Introduction to Databases

DBMS · 12 min · +100 XP

DBMS · 12 min · +100 XP

Advanced DSA Topics

Introduction to Databases

Share

Discussion

0

Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.

Continue with GitHub

Loading...