Course Syllabus

  • Data Modeling: ER model, Relational Model
  • Relational Algebra, Relational Calculus
  • SQL (Structured Query Language)
  • Schema Refinement and Normal Forms
  • Disks, Files, Buffers
  • Tree- and Hash-Structured Indexes
  • Evaluation of Relational Operators (selection, join, group-by aggregation, sorting)
  • Relational Query Optimization (query plans, algebraic equivalence, plan space, cost estimation, search algorithm)
  • Transaction Management
  • Concurrency Control