Course Schedule
Updated by Demian Lessa on 01-31-2011.
Below, you will find a tentative course schedule. The schedule will adapted as we progress through the semester, so come back and check often.
| Week | Date | Topic | Readings* |
|---|---|---|---|
| #1 | 01/19 | Course Overview, Introductory Material |
chapter 1 |
| 01/21 | Introductory Material (cont.), Relational Model |
chapter 1, sections 2.1--2.3 |
|
| #2 | 01/24 | Relational Model (cont.) | sections 2.1--2.3 |
| 01/26 | Relational Algebra | sections 2.4, 5.1 | |
| 01/28 | Relational Algebra (cont.) | sections 2.4, 5.1 | |
| #3 | 01/31 | Exercises (#1) | sections 1, 2.1--2.4, 5.1 |
| 02/02 | Canceled due to weather. | ||
| 02/04 | Exercises (#2) | sections 2.1--2.4, 5.1 | |
| #4 | 02/07 | SQL | sections 6.1--6.6 |
| 02/09 | SQL (cont.) | sections 6.1--6.6 | |
| 02/11 | SQL (cont.) | sections 6.1--6.6 | |
| #5 | 02/14 | SQL (cont.) | sections 6.1--6.6 |
| 02/16 | SQL (cont.) | sections 6.1--6.6 | |
| 02/18 | Review | sections 2.1--2.4, 5.1, 6.1--6.6 | |
| #6 | 02/21 | Project Discussion | |
| 02/23 | Test #1 | ||
| 02/25 | Relational Design | section 3.1 | |
| #7 | 02/28 | Relational Design | section 3.2, 3.3 |
| 03/02 | Test #1 | ||
| 03/04 | Relational Design | sections 3.3 | |
| #8 | 03/07 | Relational Design | section 3.4, 3.5 |
| 03/09 | Relational Design | sections 3.5, 3.6 | |
| 03/11 | Relational Design | sections 3.6, 3.7 | |
| #9 | 03/21 | ER Design | section 4.1, 4.2 |
| 03/23 | ER Design | section 4.2--4.6 | |
| 03/25 | ER Design | class work | |
| #10 | 03/28 | ER Design | class work |
| 03/30 | XML | sections 11.1, 11.2 | |
| 04/01 | XML | sections 11.3 | |
| #11 | 04/04 | XML & XPath | sections 11.4, 12.1 |
| 04/06 | Exercises | section 12.1 | |
| 04/08 | Review | chapters 3--4 | |
| #12 | 04/11 | Test #2 | |
| 04/13 | Exercises | sections 11.1-11.4, 12.1 | |
| 04/15 | Exercises | sections 11.1-11.4, 12.1 | |
| #13 | 04/18 | XQuery | section 12.2 |
| 04/20 | Exercises | section 12.2 | |
| 04/22 | Indexes | ||
| #14 | 04/25 | Indexes Stored Procedures |
|
| 04/27 | Stored Procedures | ||
| 04/29 | Final Review | chapters 3, 4, 6 | |
| #15 | 05/02 | Final Review | chapters 11, 12 |
-- Demian Lessa
