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