Overview

The goal of this class is two-fold. First, to introduce you to core database concepts (e.g., data modeling, logical design, SQL) so that you too can build a billion dollar application. Second, to teach enough about database engine internals (e.g., physical database design, query optimization, transaction processing) so you have a good sense of why queries may be running slowly/incorrectly. We will also discuss their relevance to systems used in industry.

The Data Management Seminar invites interesting database researchers and practitioners to speak. Students are invited to join in person or on zoom (if available). We will announce these periodically throughout the semester.

Announcements

• 11/22: links to join ordering and concurrency control problem generators.
• 11/19: uploaded makeup video for lecture 20. Called “W4111 L20 Selinger” in the course works video library
• 11/11: fixed a bug in data quality slide 37. The example incorrectly stated that ACDE is in BCNF. It is not because B is not in the projection, so C does not determine A, and is thus not a key. This has been fixed in the slide.
• 11/1: added clarification to HW3 Q1.5’s prompt
• 10/27: updated normalization slides to fix error in BCNF decomposition example.
• 10/24: added a link to Functional Dependency Exercies.
• 10/17: added a link to SQL injection example in class.
• 10/11: fixed a bug in relational algebra slide 57 so equijoin removes the duplicate attributes.
• 10/6: first extra credit assignment released
• 10/6: Updated the slides for the SQL lectures
• 9/29: Looking for past exams? Look no further. Click here!
• 9/29: Link to SQLTutor
• 9/27: Notebook examples used in class can be found here
• 9/13: Added Link to Project 1 Part 1 appointment slots
• 9/8: Added course gradescope link to webpage
• 9/8: HW1 part 1 and Project 1 Part 1 are released
• 9/6: HW0 released. No Late Days! Failure to submit on time is a -5% penalty on your final grade.

Schedule