Database Design and Applications

17 lectures

Lecture notes and study resources for this subject.

01Lecture 01 · Introduction to Database Systems

02Lecture 02 · Entity–Relationship Modeling

03Lecture 03 · From Requirements to the Relational Model

04Lecture 04 · Normalization: Turning Instinct into Certainty

05Lecture 05 · Database Normalization: Closure, Minimal Cover, and the 3NF Synthesis Algorithm

06Lecture 06 · Minimal Covers, 3NF Synthesis, and Relational Algebra

07Lecture 07 · Relational Algebra: Select, Project, and Joins

08Lecture 08 · SQL Basics: Creating Databases, Tables, and Querying

09Lecture 09 · Candidate Keys, ER-to-Relational Mapping, and Normalization Revision

10Lecture 10 · Storage, File Organization, and Indexing

11Lecture 11 · Hashing, Extendible Hashing, and the HealthTrack Assignment

12Lecture 12 · The Evolution of Database Systems: Indexing, Transactions, and Concurrency

13Lecture 13 · Indexing for Fast Retrieval: Primary Indexes, B-Trees, and B+ Trees

14Lecture 14 · B+ Trees, Transactions, and ACID

15Lecture 15 · Transactions: Schedules, Serializability, and Recovery

16Lecture 16 · Concurrency Control: Lock-Based and Timestamp-Based Protocols

17Lecture 17 · Database Recovery, Checkpointing, and the NoSQL Shift

Loading comments…