Slides and Schedule
Monday + Wednesday, 10:00am - 11:15am, PH 131
The course schedule and linked slides will be updated over time. The slides are a modified version of the slides from Avi Silberschatz created for Database System Concepts.
For convenience, here is a combined versions of all slides and all handouts (6 slides per page).
Lectures and Slides
| 08/22 | 00. Course Organization | slides or handout (6 slides per page) |
| 08/24 | 01. Introduction | slides or handout (6 slides per page) |
| 08/29 | 02. The Relational Datamodel | slides or handout (6 slides per page) |
| 08/31 | ||
| 09/07 | 03. Formal Relational Query Languages | slides or handout (6 slides per page) |
| 09/12 | ||
| 09/14 | 04. SQL - Introduction | slides or handout (6 slides per page) |
| 09/19 | ||
| 09/21 | ||
| 09/26 | 05. SQL - Intermediate (Views, Integrity Constraints, Access Control) | slides or handout (6 slides per page) |
| 09/28 | ||
| 10/03 | 06. SQL - Advanced (APIs for SQL Access, Procedural Constructs) | slides or handout (6 slides per page) |
| 10/05 | 07. ER-Model | slides or handout (6 slides per page) |
| 10/12 | ||
| 10/17 | ||
| 10/19 | ||
| 10/24 | 08. Database Design and Normal Forms | slides or handout (6 slides per page) |
| 10/26 | ||
| 10/31 | ||
| 11/02 | ||
| 11/07 | ||
| 11/09 | 09. Transactions | slides or handout (6 slides per page) |
| 11/14 | 10. Concurrency Control | slides or handout (6 slides per page) |
| 11/16 | ||
| 11/21 | 11. Storage and Index Structures | slides or handout (6 slides per page) |