Database Fundamentals

A complete DBMS course in ten lessons: data models, ER modeling, relational algebra and calculus, SQL, normalization, file organization, and the hierarchical and network models. Each lesson ends with self-assessment questions.

Abhishek Taneja

University lecture notes that follow a full database course: system architecture, storage and B+ tree indexes, relational algebra, SQL, normalization up to 5NF, query optimization, transactions, and distributed databases.

Subasish Mohapatra

A classic look inside a relational database engine. It explains process models, parallel architectures, the query processor, storage management, transactions, and the shared components that hold a DBMS together.

Joseph M. Hellerstein, Michael Stonebraker and James Hamilton

The famous Red Book. Three leading researchers comment on the papers that shaped the field, from traditional relational systems to dataflow engines, weak isolation, query optimization, and interactive analytics.

Peter Bailis, Joseph M. Hellerstein and Michael Stonebraker

Concise notes for a first DBMS course. They walk through data models, ER diagrams, relational algebra, SQL queries with examples, normal forms, transactions, and access control with GRANT and REVOKE.

J.B. Institute of Engineering and Technology