(Subject to change)
Weekof | Monday | Wednesday | Friday |
January 5 | Introduction | SQL basics SQL For Web Nerds, Chapter 3 | SQL Basics Section 6.1-6.2 |
January 12 | Advanced SQL HW#1 distributed Section 6.3-6.4 | SQL Schema Creation Section 6.5-6.6 | Views Section 6.7 |
January 19 | Martin Luther King, Jr. Day | Constraints and Triggers HW#1 due; Chapter 7 | Programming and Transactions Chapter 8 |
January 26 | 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 2 | Functional Dependencies Section 3.6 | Relational Decomposition and Relational Algebra Section 5.1-5.2 | Relational Algebra and Project Discussion Section 5.2 |
February 9 | XML Section 4.7 HW#2 due | Querying XML | Web services |
February 16 | Presidents' Day | Project discussion Project Phase II Part 1&2 due | Querying XML (cont) Project Phase II due HW#3 distributed |
February 23 | DBMS Internals Chpt11 Project Phase II Part 3 due | Storage and Indexing Section 13.1 | Indexing Section 13.2-13.3 |
March 1 | Query Execution Chpt15 | Query Execution (cont.) HW#3 due; HW#4 distributed | Query Optimization |
March 8 | Query Optimization (cont.) | Query Optimization (cont.) Phase III due | Review HW#4 due |
March 15 | FINAL EXAM (2:30-4:30) |