|
|
| Date | Topic & Lecture Notes Link | Readings (*) |
|---|---|---|
| Wed. April 2 | Introductory Material | Chapter 1 and SQL for Web Nerds: Introduction |
| Mon. April 7 | Data: Relations and XML | 3.1, 6.6.1-6.6.4, 4.7,
XML in 10 Points OPTIONAL: Various XML readings linked from this page |
| Wed. April 9 | Relational Algebra | 5.1-5.2 |
| Mon. April 14 | SQL: Queries and Updates | 6.1-6.5, 8.1 (**), 8.5 (**) OPTIONAL: SQL for Web Nerds: Queries and Complex Queries |
| Wed. April 16 | XML Queries: XPath and XQuery | For XPath read one or more of: XPath Tutorial, XPath Tutorial (different), XPath For XQuery: XQuery, An Introduction to XQuery OPTIONAL: XPath 2.0 Specification, XQuery 1.0 Specification, What is XQuery?, XQuery paper (pdf) |
| Mon. April 21 | Relational Database Design | 3.4-3.7 |
| Wed. April 23 | Relational Design (cont'd) | " |
| Mon. April 28 | Higher-Level Design: UML | Recommended to browse one or both of: Database Modeling in UML, Database design with UML and SQL |
| Wed. April 30 | Catch-up and Review | - |
| Mon. May 5 | MIDTERM EXAM | - |
| Wed. May 7 | Constraints and Triggers | Chapter 7 OPTIONAL: SQL for Web Nerds: Triggers |
| Mon. May 12 | Transactions | 8.6 |
| Wed. May 14 | Indexes; Views | 6.6.5-6.6.6, 6.7 OPTIONAL: SQL for Web Nerds: Views |
| Mon. May 19 | Authorization; Object-Relational SQL | 8.7, 9.4-9.5 |
| Wed. May 21 | Recursion; Temporal Databases | 10.4 |
| Mon. May 26 | HOLIDAY | - |
| Wed. May 28 | Data Warehousing & Data Mining | "On-Line Analytical Processing and Data Cubes" (in postscript or pdf), SQL for Web Nerds: Data Warehousing |
| Mon. June 2 | Data Streams (pdf) | Optional reading linked from: STREAM project home page |
| Wed. June 4 | Course evals, project demos, wrap-up, refreshments | - |
| Fri. June 6 | FINAL EXAM 9:30-11:30 AM, Gates B01 | - |
(*) All numbers in this column refer to chapters or sections of the course textbook - A First Course in Database Systems, Second Edition or Database Systems: The Complete Book. See Books in the Administrative Information page for more information.
(**) Required reading even though material will not be covered in lecture.