Database Systems Concepts (AI3613/ICE3404P, Spring 2024)
General Information
Lecture Notes
[02/02]
Introduction [PDF][28/02]
Relational model and algebra [PDF][06/03]
SQL: Part (I) [PDF][12/03]
SQL: Part (II) [PDF][12/03]
SQL: Part (III) [PDF][27/03]
Design Theory (I) [PDF][01/04]
Design Theory (II) [PDF][13/04]
Storage Manager [PDF][17/04]
Indexing [PDF][23/04]
Query Processing (I) [PDF][27/04]
Query Processing (II) [PDF][09/05]
Query Optimization [PDF][15/05]
Transaction Processing [PDF][30/05]
Crash Recovery [PDF][06/06]
Final review [PDF]
Textbook
- Database System Concepts, A. Silberschatz, H. Korth and S. Sudarshan, McGraw-Hill, 7th Edition, 2019
Last updated: June 6, 2024