Topics in this schedule are tentative. At a high level, we will be focusing on conceptual matters at the beginning of the semester, and increasing the balance towards technical programming as the semester progresses.
The textbook readings are front-loaded into the first half or so of the semester. This will give you more time to work on the project in the later portion of the semester.
I will attempt to keep the online schedule up-to-date as the course progresses.
| Week | Lec. Date | Topic | Reading | Due | Site |
|---|---|---|---|---|---|
| 1 | 8/28 | Intro, History, DB Goals, Data Layout | 1, 2 | SM | |
| 2 | 9/4 | Relational Algebra, Introducing SQL | 2,3 | RR | |
| 3 | 9/11 | SQL Review, Data Design and Normalization | 5,6 | H1 | SM |
| 4 | 9/18 | Design Methodology, Project Introduction | RR | ||
| 5 | 9/25 | Defining and Creating Data | 3,4 | H2 | SM |
| 6 | 10/2 | Constraints, Integrity, Indexes | 4 | RR | |
| 7 | 10/9 | Project: Design Review | P: Design | out | |
| 8 | 10/16 | Midterm; DBs, Python & the Web | SM | ||
| 9 | 10/23 | H3 | RR | ||
| 10 | 10/30 | Transactions | SM | ||
| 11 | 11/6 | H4 | RR | ||
| 12 | 11/13 | SM | |||
| 13 | 11/20 | Distributed and Trending DBMSes | H5 | RR | |
| 14 | 11/27 | Thanksgiving | |||
| 15 | 12/4 | Project: Presentations | P: Final | SM | |
| F | 12/11 | Final Exam |
The Site column indicates which site I will be lecturing from; I will try to teach from San Marcos and Round Rock about the same number of times. When I am teaching from Round Rock, my Thursday office hours will be in Round Rock.