| Lecture | Date | Description | Chapters covered |
| Lecture1 | May 17, 2005 | The E/R Data Model | Ch 2 |
| Lecture 2 | May 24, 2005 | The Relational Data Model
Relational Algebra |
Ch 3.1 - 3.3
Ch 5.2 |
| Lecture 3 | May 31, 2005 | Relational Algebra
Relational Calculus |
Ch 5.3 - 5.4 |
| Lecture 4 | June 7, 2005 | SQL | Ch 6.1 - 6.3 |
| Lecture 5 | June 14, 2005 | SQL, cont | Ch 6.4 - 6.7 |
| Lecture 6.1 | June 21, 2005 | SQL, cont: Constraints, Assertions, Triggers | Ch. 7 |
| Lecture 7 | June 30, 2005 | Datalog, Recursivity | Ch 10 |
| Lecture 8 | July 5, 2005 | Datalog, Recursivity + Embedded SQL | Ch 10 |
| Lecture 9 + 10 | July 12, 19, 2005 | Functional Dependencies, Normalization | Ch 3 |
| Lecture 11 | July 26, 2005 | Query Execution | Ch 15 |
| Lecture 12
slide 1 slide 2 slide 3 slide 4 slide 5 slide 6 slide 7 slide 8 slide 9 slide 10 slide 11 slide 12 slide 13 slide 14 slide 15 slide 16 slide 17 slide 18 slide 19 slide 20 slide 21 slide 22 slide 23 slide 24 slide 25 slide 26 slide 27 |
August 2, 2005 | Transactions and Concurency | |