| Lecture # | Date | Day | Topic | Reading | Handout / Quiz | Assignment Due |
| 1 | January 7 | Wednesday | Introduction [pdf] | Ch.1 | Java Assignment | |
| Discussion | January 9 | Friday | Intro to Java [pdf] | Read intro to Java for C++ programmers before discussion. | After discussion, work through exercises here. We won't grade this, but it will help you on the individual assignment. | |
| 2 | January 12 | Monday | ER Model [pdf] | Ch.2 | ||
| 3 | January 14 | Wednesday | Relational Model [pdf] | Ch. 3 | ||
| Discussion | January 16 | Friday | More Java [pdf] | |||
| January 19 | Monday | MLK Day -- NO CLASS | ||||
| 4 | January 21 | Wednesday | ER to Relational [pdf] | Ch. 3 | JDBC/Oracle Assignment; Also, see Toby Teorey's SQL Handout | Java Assignment / Group Registration |
| Discussion | January 23 | Friday | JDBC/Oracle Assignment [pdf] | Ch. 6, except 6.4, 6.5 | ||
| 5 | January 26 | Monday | Relational Algebra [pdf] | Ch. 4, except 4.3, 4.4 | ||
| 6 | January 28 | Wednesday | SQL [pdf] | Ch. 5 | ||
| Discussion | January 30 | Friday | Relational Algebra | Ch. 5 | ||
| 7 | February 2 | Monday | SQL [pdf] | Ch. 5 | ||
| 8 | February 4 | Wednesday | Disks and Files [pdf] | Ch. 9, except 9.2 | Quiz 1 | |
| Discussion | February 6 | Friday | SQL [pdf] | |||
| 9 | February 9 | Monday | Disks and Files | Ch. 9, except 9.2 | ||
| 10 | February 11 | Wednesday | Storage & Indexing (1) [pdf] | Ch. 8 | JDBC/Oracle Assignment | |
| Discussion | February 13 | Friday | Exam Review | |||
| February 16 | Monday | Midterm Exam | ||||
| 11 | February 18 | Wednesday | Tree-Structured Indexing [pdf] | Ch. 10, except 10.8.1 | ||
| Discussion | February 20 | Friday | NO CLASS | |||
| February 23 | Monday | Spring Break | ||||
| February 25 | Wednesday | Spring Break | ||||
| Discussion | February 27 | Friday | Spring Break | |||
| 12 | March 2 | Monday | Hash-based Indexing [pdf] | Ch. 11 | ||
| 13 | March 4 | Wednesday | Storage & Indexing (2) [pdf] | Ch. 8 | Minirel Project Part 1 | |
| Discussion | March 6 | Friday | Minirel (Part 1) [ppt] | |||
| 14 | March 9 | Monday | Sorting [pdf] | Ch. 13 | ||
| 15 | March 11 | Wednesday | Query Evaluation [pdf] | Ch. 12, Ch. 14 | ||
| Discussion | March 13 | Friday | Review of Indexing [pdf] | |||
| 16 | March 16 | Monday | Query Evaluation | |||
| 17 | March 18 | Wednesday | Query Optimization [pdf] | Ch. 15 | ||
| Discussion | March 20 | Friday | Review of Query Evaluation [pdf] | |||
| 18 | March 23 | Monday | Query Optimization | Minirel Project Part 2 | Minirel Part 1 | |
| 19 | March 25 | Wednesday | TBD | Quiz 2 | Explain Plan Examples | |
| Discussion | March 27 | Friday | Minirel (Part 2) [pdf] | |||
| 20 | March 30 | Monday | Transactions [pdf] | Ch. 16, except 16.6 | ||
| 21 | April 1 | Wednesday | Concurrency Control [pdf] | Ch. 17, except 17.5, 17.6 | Locking Handout | |
| Discussion | April 3 | Friday | ||||
| 22 | April 6 | Monday | Recovery [pdf] | Ch. 18 | ||
| 23 | April 8 | Wednesday | Recovery | Ch. 18 | ||
| Discussion | April 10 | Friday | ||||
| 24 | April 13 | Monday | Normalization [pdf] | Ch. 19.1-19.5 | ||
| 25 | April 15 | Wednesday | Normalization | Ch. 19.1-19.5 | Minirel Part 2 | |
| 26 | April 20 | Monday | Review | |||
| April 28 | Tuesday | Final Exam 1:30-3:30, 1504 GG Brown |