Note that the timing and topics shown for future dates represent projections that are subject to change as the course progresses.
| # | Date | Topics | Notes | Lab | Homework |
|---|---|---|---|---|---|
| 1 | 9 Sept. | Introduction: Database requirements & concepts | Read chapter 1; chapter 2 sections 1-3 | Homework #1 due |
|
| 2 | 11 Sept. | Relational Design: Entity-relationship diagrams & Data models | Read chapter 4 sections 1-6 | ||
| 3 | 16 Sept. | Keys, Closures, Functional Dependencies, BCNF | Read chapter 3 sections 1-4 | Bookings | |
| 4 | 18 Sept. | SQL Queries | Read chapter 6 sections 1 & 4 | Flights DB & SQL dump Flight tables SQL Zoo units 0-3 |
Homework #2 due |
| 5 | 23 Sept. | Guest Lecture: John Singler, Julia Keller, & Kaja Katamay | Workday migration: stories from the trenches | ||
| * | 25 Sept. | M O U N T A I N D A Y | |||
| 6 | 30 Sept. | Review nested queries & joins; modifications & updates | Finish chapter 6 (sections 2,3,5,6) | SQL Zoo units 4-9 | |
| 7 | 02 Oct. | Embedded SQL: PHP basics & web databases; LAMP/MAMP/WAMP | Skim chapter 9 | Query lab | |
| 07 Oct. | (continued from 02 October) | Query lab cont. | Homework #3 due |
||
| 8 | 09 Oct. | Embedded SQL: Updating & security | Read The Hitchhiker's Guide to SQL Injection and PDO Tutorial Bobby Tables; Safe Bobby |
Update lab | |
| 9 | 16 Oct. | Constraints & triggers | Read chapter 7 | Constraints lab | |
| 10 | 21 Oct. | Secondary storage | Read chapter 13 sections 1-4 | ||
| 11 | 23 Oct. | Data organization | Read chapter 13 sections 5-8 | Storage examples | Homework #4 due |
| 12 | 28 Oct. | Indexing | Read chapter 14 | BTree Example | |
| 13 | 30 Oct. | Query processing: physical routines | Read chapter 15 | Operations; student handout; key | |
| 14 | 04 Nov. | Logical query optimization | Read chapter 2 sections 4-5, and chapter 16 sections 1-3 | Rewrite rules; query optimization handout | Homework #5 due Nov. 11 |
| 15 | 06 Nov. | Cost estimation & physical plan generation | Read chapter 16 sections 4-7 | ||
| 16 | 11 Nov. | Resilience & Data Protection | Read chapter 13 section 4; chapter 17 | Homework #6 due Nov. 18 | |
| 17 | 13 Nov. | Logging & Recovery | Logging handout Ethics case studies |
||
| 18 | 18 Nov. | Concurrency control | Read chapter 18 | Concurrency handout | Homework #7 due Nov. 26 |
| 19 | 20 Nov. | Parallel databases | Read chapter 20 | Replication & consistency across systems | |
| 20 | 25 Nov. | Distributed databases | Read chapter 20 | Replication & consistency across systems | Final Project |
| * | 2 Dec. | --- THANKSGIVING RECESS --- | |||
| * | 2 Dec. | Snow day | |||
| 21 | 4 Dec. | NoSQL & MapReduce | Read chapter 11 section 1-3; Advantages to MongoDB | ||
| * | 9 Dec. | Special guest appearance: Adam Sah | |||
| 22 | 11 Dec. | Final project presentations | Review sheet | ||