| Week | Date | Topic | Sections in the textbook |
| 1 | September 5 | Introduction | Chapter 1 |
| September 7 | Collecting data | ||
| 2 | September 10 | Storing data | Chapter 3 |
| September 12 | Simple SQL (1) | ||
| September 14 | Simple SQL (2) | Chapter 3 | |
| 3 | September 17 | Simple SQL (3) | Chapter 3 |
| September 19 | Writing advanced queries | Chapter 3 | |
| September 21 | Views | Chapter | |
| 4 | September 24 |
Tutorial on using SQL Server 2005 Tutorial on developing using tablet PCs |
Courtesy by Bin Zhou |
| September 26 | No class | ||
| September 28 | Exam 1 (Simple SQL) | ||
| 5 | October 1 | Integrity Constraints and Authorization | Chapters 4.1-4.3 |
| October 3 | Embedded SQL | Chapters 4.4-4.5 | |
| October 5 | ODBC and JDBC | Chapters 4.5 | |
| 6 | October 10 | ER diagram | Chapter 6 |
| October 12 | ER design (1) | Chapter 6 | |
| 7 | October 15 | ER design (2) | Chapter 6 |
| October 17 | Relational model | Chapter 2 | |
| October 19 | Relational algebra | Chapter 2 | |
| 8 | October 22 | Relational design | Chapter 2 |
| October 24 | Relational calculus | Chapters 5.1-5.2 | |
| October 26 | Query-by-Example (QBE) | Chapter 5.3 | |
| 9 | October 29 | Datalog | Chapter 5.4 |
| October 31 | Functional dependencies | Chapter 7.1, 7.2, 7.4.1 | |
| November 2 | BCNF and 3NF | Chapter 7.3 | |
| 10 | November 5 | Closure and lossless decomposition | Chapter 7.4.2-7.4.5 |
| November 7 | Using BCNF and 3NF | Chapter 7.5 | |
| November 9 | 4NF | Chapter 7.6, 7.9 | |
| 11 | November 14 | Review for Exam 2 | |
| November 16 | Exam 2 | ||
| 12 | November 19 | XML | |
| November 21 | DTD and XMLSchema | ||
| November 23 | XQuery | ||
| 13 | November 26 | Data warehousing and OLAP | |
| November 28 | Data mining | ||
| November 30 | Information retrieval | ||
| 14 | December 3 | Review for final exam |