Schedule

Midterm Exam: March 6, 2013, in class

- Administrative details
- Introduction to Database Systems [slides]
- Overview of Entity-Relationship Model [slides]
- Overview of the Relational Model [slides]
- Relational Algebra [slides]
- Relational Calculus [slides]
- Overview of SQL: Queries, Programming, Triggers [slides]
- File Organization and Indexing [slides]
- Disk Storage and Files [slides]
- Tree-Structured Indexes [slides]
- Hash-Based Indexes [slides]
- Midterm Exam Topics [pdf] - [midterm solutions]
- External Sorting [slides]
- Overview of Query Evaluation [slides]
- Evaluation of Relational Operations: Part I [slides]
- Evaluation of Relational Operations: Part II [slides]
- Relational Query Optimization [slides]
- Transaction Management [slides]
- Concurrency Control [slides]
- Crash Recovery [slides]
- Final Exam Topics [pdf]