May 2012Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|
| | 1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 | | |
2012–05–20
This is a tentative lecture and reading schedule for the course. It will be updated throughout the term.
Course materials (slides, source code, and documents) are available for some lectures. Lectures containing materials are marked with a check mark in the “Docs” column. To access the materials, click on the check mark icon. Note: the
lecture slides are provided as a pdf document, with one slide per page. To conserve paper, you can use acroread and print multiple slides per page.
| Date |
| Topic |
Reading |
Other |
Docs |
|---|
|
| 08/26 |
Introduction |
Chapters 1 and 2 |
|
 |
| Lecture slides:
|
| 08/31 |
Relational Data Model |
Chapter 3: pp. 59 - 72 |
|
|
| Lecture slides
|
| 09/02 |
Introduction to SQL |
Chapter 4: pp. 97 - 107 |
Hw #1 |
|
| Lecture slides:
|
| 09/07 |
SQL Queries: Join operations |
Chapter 5: pp. 123 - 124 |
|
|
| Lecture slides:
Note: this a newer version of the lecture slides. |
| 09/09 |
SQL Queries: Set Operations |
|
Hw #1 due
Hw #2 |
|
| Lecture Slides
|
| 09/14 |
SQL Queries: Aggregate Functions |
Chapter 5: pp. 124 - 129 |
|
|
| Lecture Slides
|
| 09/16 |
SQL: Nested Queries |
Chapter 4 |
|
|
| Lecture slides:
|
| 09/21 |
SQL Data Modification |
Chapter 4: pp. 107 - 111 |
Hw #3 |
|
| Lecture slides:
|
| 09/23 |
SQL Data Definition |
Chapter 4: pp. 89 - 97 |
|
|
| Lecture slides:
|
| 09/28 |
SQL: Data Definition |
|
|
|
| Lecture slides:
|
| 09/30 |
Intro to Python |
|
Hw #3 due |
|
| 10/05 |
Exam One |
|
|
|
| 10/07 |
Python SQL Interface |
Chapter 13 |
Hw #4 |
|
| Source Listings:
|
| 10/12 |
Fall Break |
|
|
|
| 10/14 |
Designing Databases |
Chapter 7 |
|
|
| Lecture Slides:
|
| 10/19 |
E-R Model |
Chapter 7 |
Hw #4 due
Hw #5 |
|
| Lecture Slides:
|
| 10/21 |
E-R Model |
|
|
|
| 10/26 |
E-R Model |
Chapter 7 |
Hw #5 due |
|
| 10/28 |
Relational Database Design |
Chapter 9 |
|
|
| Lecture Slides:
|
| 11/02 |
Relational DB Design |
Chapter 15 |
Hw #6 |
|
| Lecture Slides:
|
| 11/04 |
Relational DB Design |
Chapter 15 |
|
|
| 11/09 |
Final Project Discussion |
|
Hw #6 due |
|
| 11/11 |
Exam Two |
|
|
|
| 11/16 |
Final Project Discussions |
|
|
|
| 11/18 |
Final Project Work Session |
Attendance Required |
|
|
| 11/23 |
Final Project Work Session |
Attendance Required |
|
|
| 11/25 |
Thanksgiving Break |
|
|
|
| 11/30 |
Project Presentations |
|
|
|
| 12/02 |
Project Presentations |
|
|
|
| 12/14 |
Final Exam |
2pm - 5pm |
|
|
