| Week | Date | Topic & Lecture Notes Link | Readings (*) |
|---|---|---|---|
| #1 | Mon. Sept. 22 | Introductory Material | Chap. 1 all SQL for Web Nerds: Introduction |
| Wed. Sept. 24 | Data: Relations and XML XML Demo — Set 1 Set 2 Set 3 Set 4 |
Chap. 2 through 2.3; Chap. 11 through 11.4.4 Optional: XML: Introduction or Tutorial DTDs: Introduction or Tutorial XML Schema: Introduction |
|
| #2 | Mon. Sept. 29 | Data: Relations and XML (cont’d); Relational Algebra |
Sect. 2.4 |
| Wed. Oct. 1 | Relational Algebra (cont’d); SQL Queries and Updates SQL Demo — Schema Data Queries |
Chap. 6 through 6.5; Chap. 9 all (**) | |
| #3 | Mon. Oct. 6 | SQL Queries and Updates (cont’d) | – |
| Wed. Oct. 8 | SQL Queries and Updates (cont’d) | – | |
| #4 | Mon. Oct. 13 | XML Queries and Transformations Demos — Data XPath XQuery XSLT |
Chap. 12 all Optional: XPath: Introduction or Tutorial XQuery: Introduction or Tutorial XSLT: Introduction or Tutorial |
| Wed. Oct. 15 | XML Queries and Transformations (cont’d) | – | |
| #5 | Mon. Oct. 20 | Relational Database Design | Ch. 3 except 3.7 (some **) |
| Wed. Oct. 22 | Relational Database Design (cont’d) | – | |
| #6 | Mon. Oct. 27 | Higher-Level Design: UML | Ch. 4 sections 4.7-4.8 Optional: UML Readings |
| Wed. Oct. 29 | MIDTERM EXAM: in class | – | |
| #7 | Mon. Nov. 3 | Constraints and Triggers | Ch. 7 all |
| Wed. Nov. 5 | Transactions; CTL mid-course evaluation |
Sect. 6.6 | |
| #8 | Mon. Nov. 10 | Transactions (cont’d); Indexes; Views Views Demo — Schema Data Views |
Ch. 8 all |
| Wed. Nov. 12 | Views (cont’d); Authorization | Sect. 10.1 | |
| #9 | Mon. Nov. 17 | SQL Recursion | Sect. 10.2 |
| Wed. Nov. 19 | Data Warehousing & Data Mining | Sect. 10.6-10.7 | |
| – | – | THANKSGIVING BREAK | – |
| #10 | Mon. Dec. 1 | Uncertain Data | Trio book chapter (pdf) pages 1-20 (beginning through Sect. 3.3) |
| Wed. Dec. 3 | Project demos, wrap-up, exam review, and refreshments | – |
Filed under: Uncategorized | Leave a Comment »
