Back

DBMS Roadmap - Intermediate

Follow this step-by-step roadmap to master dbms at Intermediate level

1

Advanced SQL

3 weeks
  • ▹Joins (INNER, LEFT, RIGHT, FULL)
  • ▹UNION, INTERSECT, EXCEPT
  • ▹Subqueries & Nested Queries
  • ▹Views
  • ▹Indexes
  • ▹Stored Procedures & Functions
  • ▹Mini-Project: Online Store Database Queries
2

Normalization & Design

2 weeks
  • ▹Functional Dependencies
  • ▹1NF, 2NF, 3NF, BCNF
  • ▹Denormalization
  • ▹Schema Design
  • ▹Mini-Project: Hospital Management Database
3

Transactions & Concurrency

3 weeks
  • ▹ACID Properties
  • ▹Transaction States
  • ▹Concurrency Control
  • ▹Locking Mechanisms (Shared, Exclusive)
  • ▹Deadlocks
  • ▹Mini-Project: Banking Transaction Simulation
4

Indexing & Query Optimization

2 weeks
  • ▹Clustered vs Non-clustered Index
  • ▹B-Tree & Hash Index
  • ▹Cost-based Query Optimization
  • ▹Execution Plans
  • ▹Mini-Project: Optimizing Search Queries
GeekDost - Roadmaps & Snippets for Developers