CS Learning PortalCS Learning PortalCS Learning Portal
  • Tutorials
  • Practice
  • Problems
  • Interview
  • Articles
  • Store
Sign in

◈ Dashboard⚙ Settings
  • Tutorials
  • Practice
  • Problems
  • Interview
  • Articles
  • Store
/…/DBMS
Home/Tutorials/DBMS

Tutorial · 41 chapters

DBMS

Database Management Systems from the ground up: ER modeling, the relational model, normalization, transactions, concurrency control, indexing and recovery.

Start learning

Mission log

01Introduction to DBMS02File System vs DBMS03DBMS Architecture04Three-Schema Architecture & Data Independence05Data Models06Database Languages (DDL, DML, DCL, TCL)07ER Model08Types of Attributes09Relationships, Cardinality & Participation10Weak Entities11Generalization, Specialization & Aggregation12Converting ER Diagrams to Tables13Relational Model14Keys in DBMS15Integrity Constraints16Relational Algebra17Relational Calculus18Functional Dependencies19Attribute Closure & Candidate Keys20Canonical Cover21Normalization & Anomalies221NF, 2NF & 3NF23BCNF244NF & 5NF25Lossless Join & Dependency Preservation26Transactions & ACID Properties27Transaction States28Schedules & Serializability29Conflict & View Serializability30Recoverable & Cascadeless Schedules31Lock-Based Concurrency Control (2PL)32Timestamp Ordering Protocol33Deadlocks in DBMS34Recovery & Logging35File Organization36Indexing in DBMS37B-Tree & B+ Tree38Hashing in DBMS39Query Processing & Optimization40NoSQL Databases41Distributed Databases & CAP Theorem
DBMS
CS Learning PortalCS Learning Portal

All-in-one platform to learn CS, code online, prepare for interviews and use developer tools.

Learn

  • Tutorials
  • Articles
  • Store

Practice

  • Code Editor
  • Challenges
  • Interview Prep

Legal

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • Refund Policy
  • Delivery Policy

© 2026 CS Learning Portal · All systems nominal

PrivacyTermsContact