| Location & Time | Ryerson 251, 5:30pm - 8:30pm, Thursdays |
|---|---|
| Instructor | Svetlozar Nestorov (evtimov at uchicago.edu) email for appointment,
include string csppdb in the subject line |
| TAs | For faster response, please, address your email to csppdb at cs.uchicago.edu.
This email address reaches the instructor and the 3 TAs. James Sams (jasams at uchicago.edu) email for appointment, Samuel Olofin (solofin at uchicago.edu) email for appointment, Greg Cross (grog at cs.uchicago.edu) email for appointment, include string csppdb in the subject line |
| Textbook | A First Course in Database Systems (3rd ed.) by Jeff Ullman and Jennifer Widom |
| Academic Policies | Academic Policies & Requirements at UChicago |
| Date | Announcement |
|---|---|
| 11/1 | For faster response, please, address your email to csppdb at cs.uchicago.edu.
This email address reaches the instructor and the 3 TAs. |
| 10/22 | We have a new (third) TA: Greg Cross. His contact info is grog at cs.uchicago.edu. |
| 10/17 |
Our next class is on Thursday, Oct 18. We will have a make-up class on Saturday, Oct 20, at 10:30am in Ryerson 251. |
| 10/4 | Please, subscribe to the class mailing list. |
| 10/4 | Slides and homework will be posted on chalk. |
| 10/4 | Please, complete the background survey. |
| 10/2 | First class meets on October 4, 2012! |
| Week | Date | Topics | Reading | Assignments |
|---|---|---|---|---|
| 1 | 10/4 | Introduction, Entity-Relationship model and design | 1, 4.1-4.4 | hw1 |
| 2 | 10/18 | Database design, Relational model, Functional dependencies | 2.1-2.2, 4.5-4.6, 3.1-3.5 | hw2 |
| 3 | 10/20 | Normal forms, Relational algebra, SQL: Schemas, Simple queries | 2.3-2.5, 5, 6.1-6.2 | |
| 4 | 10/25 | SQL: Subqueries, Aggregation, Modifications | 6.2-6.5 | hw3 |
| 5 | 11/1 | SQL: Joins, Views, Indexes, Constraints | 6.3, 7.1-7.2, 8.1-8.4 | hw4 |
| 6 | 11/8 | Midterm; Transactions, Authorization | 6.6, 10.1 | hw5 |
| 7 | 11/15 | Midterm review; Triggers, Stored procedures | 7.5, 9.1-9.4 | hw6 |
| 8 | 11/29 | Database connectivity, Web programming | 9.5-9.7, class notes | hw7 |
| 9 | 12/6 | Data warehousing, Data mining | class notes | hw8 |
| 10 | TBD | NoSQL Databases, Big Data | class notes | |
| - | 12/12 | Final project deadline! | no class |