(Subject to change)
| Week of | Monday | Wednesday | Friday |
| January 6 | Introduction Guest lecturer: Dan Suciu |
SQL basics Guest lecturer: Rachel Pottinger XML Info sheet due SQL For Web Nerds, Chapter 3 |
SQL Basics
Section 6.1-6.2 |
| January 13 | Advanced SQL HW#1 distributed Section 6.3-6.4 |
SQL Schema Creation Project schema due Section 6.5-6.6 |
Views Section 6.7 |
| January 20 | Martin Luther King, Jr. Day | Constraints and Triggers HW#1 due; Chapter 7 |
Programming and Transactions Chapter 8 |
| January 27 | Conceptual Database Design Section 2.1, 3.2 HW#2 distributed |
E/R Diagrams and Relational Model Section 2.2-2.4, 3.1, 3.3 Project Phase I due |
Functional Dependencies Section 3.4-3.5 |
| February 3 | Functional Dependencies Section 3.6 |
Relational Decomposition and Relational Algebra Section 5.1-5.2 |
Relational Algebra and Project Discussion Section 5.2 |
| February 10 | XML Section 4.7 HW#2 due |
Querying XML | Web services |
| February 17 | Presidents' Day | Project discussion Project Phase II Part 1&2 due |
Querying XML (cont) Project Phase II due HW#3 distributed |
| February 24 | DBMS Internals Chpt11 Project Phase II Part 3 due |
Storage and Indexing Section 13.1 |
Indexing Section 13.2-13.3 |
| March 3 | Query Execution Chpt15 |
Query Execution (cont.) HW#3 due; HW#4 distributed Project Phase III Part 1 due |
Query Optimization |
| March 10 | Query Optimization (cont.) | Query Optimization (cont.) HW#4 due |
Review Project Phase III Part2 due |
| March 17 | FINAL EXAM (2:30-4:30) |