| Sno | Lecture Topics | Slides and relavant material | Suplimentary reading material |
|---|---|---|---|
| 1 | Introduction | Lecture Slides | |
| 2 | Relational Algebra | Lecture Slides Part 1, Part 2 | |
| 3 | SQL | Lecture Slides Part 1 | Stored Procedures Tutorials on PL/pgSQL Link1 Link2 Tutorials on Triggers Link1 |
| 4 | ER Models | Lecture Slides Part 1 Part 2 | |
| 5 | Normalization Theory | Slides from Jeffrey Ullman Part 1 Part 2 |
|
| 6 | Midterm Examination week (Feb-24 -- Mar-03) | ||
| 7 | Intro to File Structures and Indexes | Lecture Slides Part 1, Part 2 Linear Hashing Example Courtesy Shekhar UMN Lecture Slides Part 3 |
|
| 8 | Intro to Query Processing | Lecture slides part 1 | |
| 9 | Intro to Database Transactions | Lecture slides part 1 part 2 | |
| 11 | Final Examination week (April-29 -- May-07) |