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]

Assignments

Textbook


Last updated: June 6, 2024