Course Schedule and Materials
Attention: schedule is tentative and will be updated! - Last updated on July 27, 2010
| Session |
Topic/Readings
|
Lecture/Activities
|
Reminder
|
|---|---|---|---|
| 1. 06/14/2010 |
Course overview Reading: Syllabus |
- Attendance and survey Software Training: |
First class meet in the classroom CS 203 |
Part 1: Basic Concepts |
|||
| 2. 06/16/2010 |
Introduction to Relational Database Reading: chapter 1, chapter 3 (part 1) |
Lecture: Software Training: |
|
| 3. 06/21/2010 |
Database Query Reading: |
Lecture: Database Query with SQL [new] Software Training: |
|
| 4. 06/23/2010 |
Normalization Reading: |
Lecture: Normalization [new] |
|
Part 2: Designing Database |
|||
| 5. 06/28/2010 |
Database Design using ERD Reading: |
Lecture: Software Training: |
|
| 6. 06/30/2010 |
Logical Design Reading: |
Lecture: Logical Design [new] Software Training: |
Semester Mid-point |
| 7. 07/05/2010 |
Independence Day! |
||
| 8. 07/07/2010 |
Physical Design and Implementation Reading: |
Lecture: Physical Design and DDL [new] Software Training: |
|
| 9. 07/12/2010 |
Mid-term summary and exam preparation. |
||
| 10. 7/14/2010 |
Mid-term Exam |
||
Part 3: Managing and Using Database |
|||
| 11. 7/19/2010 |
Database Applications Reading: |
Lecture: Software Training: |
|
| 12. 7/21/2010 |
More SQL Query Reading: |
Lecture: |
|
| 13. 7/26/2010 |
XML and Database Reading: |
Lecture: - XML: Introduction [new] |
|
| 14. 7/28/2010 |
Business Intelligence Reading: |
Lecture: Software Training: |
|
| 15. 8/02/2010 | Semester summary, catch-up, and exam preparation. | ||
| 16. 8/04/2010 |
Final exam |
||