Description: In this course, we will introduce the basics of modern data management. You will learn about schema design, data modeling, query languages, building database applications, transactions, and many other topics. Through lectures, sections, and assignments, you will learn about and understand how real-world data management systems work, and how they touch upon many aspects of our daily lives.
Questions and Comments: If you have any questions or comments about lecture, sections, assignments, exams, or whatever, post on the discussion board. This is the fastest way to get in contact with the 344 staff and your peers. If you need to talk about anything personal or offline, see us during office hours or email the instructor (maas @ cs) to set up a meeting. And we love feedback! If you have any concerns, comments, or suggestions let us know through this anonymous feedback tool.
HW1 due June 29 @11 PM (Gradescope)
HW2 due July 8 @ 11pm (Spec, Gradescope)
HW3 due July 16th @ 11pm (Spec, Azure setup guide, Setup demo from 344 in 21AU) https://www.gradescope.com/courses/405576/assignments/2132020
HW4 due July 23rd @ 11pm (Spec, Gradescope)
HW5 due August 6 @ 11pm (Spec)
HW6 due August 17th (19th with late days) (Spec) Note that you need to verify that you have set up the assignment by Friday, see the spec for instructions.
Quiz 1 - Thursday August 4th release, due Friday August 5th. Topics are similar problems to HW 1, HW 2, and HW 3, as well as conceptual questions from the slides. The quiz should only take around 30-40 minutes to complete.
Link to this quarter's quiz on Gradescope: https://www.gradescope.com/courses/405576/assignments/2149969
For practice problems, see midterm exam questions from Autumn 2018 and 2019
Quiz 2 - Wednesday August 17th release, due Friday August 19th (Topics are similar problems to HW 4, HW5 , as well as conceptual questions from the slides about transaction schedules. The quiz should only take around 30-40 minutes to complete.)
For practice problems, see midterm exam questions from Autumn 2018 and 2019
See Canvas for lecture recordings
Week 1
Monday June 20
NO CLASS (holiday)
Week3
Monday, July 4
NO CLASS (holiday)
Friday, July 15
Design Theory cont.
3.1-5
Friday, July 22
Transactions - Serializability cont.
18.1-2
Friday, August 5
Intro to Parallel Processing cont.
1:10 - 2:10 AB: Eden Chmielewski
2:20 - 3:20 AA: Kush Bhatia & Ananya Sharma
Section 1, June 23rd (slides (AA), demo queries)
Section 2, June 30th (slides (AB), worksheet, solutions)
Section 3, July 7th (slides (AB), worksheet, solutions)
Section 4, July 14th (slides (AA), worksheet, solutions)
Section 5, July 21st (slides (AB), worksheet, solutions)
Section 6, July 28th (slides (AB), worksheet, solutions)
Section 7, Aug 4th (slides (AB), worksheet (AA), solutions)
Database Systems: The Complete Book (2nd Edition) <errata>
The library has the following that you might find useful if you require another explanation of a topic.
Fundamentals of database systems by Elsmasri and Navathe
Database management systems by Raghu Ramakrishnan and Johannes Gehrke
Foundations of database systems by Abiteboul, Hull and Vianu
Look at the course webpage for a schedule of what topic was taught when.
CSE 414 Spring 2020 - Mark Friedman - videos, course webpage
CSE 414 Winter 2020 - Shana Hutchison - videos, course webpage
CSE 344 Spring 2019 - Jonathan Leang - videos, course webpage