Chapter 1

Introduction to DBMS

File systems vs DBMS

medium • 1 min read

Database architecture (1-tier, 2-tier, 3-tier)

medium • 2 min read

Data models (Relational, Hierarchical, Network)

medium • 3 min read

Entity-Relationship (ER) model

medium • 4 min read

Extended ER features

medium • 5 min read

Chapter 2

Relational Model

Relational algebra

medium • 1 min read

Relational calculus

medium • 2 min read

Integrity constraints

medium • 3 min read

SQL (DDL, DML, DCL)

medium • 4 min read

Views and triggers

medium • 5 min read

Chapter 3

Database Design

Functional dependencies

medium • 1 min read

Normalization (1NF, 2NF, 3NF, BCNF)

medium • 2 min read

Multivalued dependencies and 4NF

medium • 3 min read

Join dependencies and 5NF

medium • 4 min read

Denormalization

medium • 5 min read

Chapter 4

Transaction Management

ACID properties

medium • 1 min read

Serializability (Conflict and View)

medium • 2 min read

Concurrency control protocols (Lock-based, Time-stamp)

medium • 3 min read

Deadlock handling

medium • 4 min read

Recovery techniques (Log-based, Shadow paging)

medium • 5 min read

Chapter 5

Advanced Topics

Query processing and optimization

medium • 1 min read

Data warehousing concepts

medium • 2 min read

Data mining techniques

medium • 3 min read

NoSQL databases

medium • 4 min read

Distributed databases

medium • 5 min read