Embedded Files
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.
CSE 344 Staff
CSE 344 Staff
Eden Chmielewski
Eden Chmielewski
She/her pronouns, edenski@cs
OH: Tues 2:00 -3:00pm via Zoom
Ananya Ganapathi
Ananya Ganapathi
She/her pronouns, gananya1@cs
OH: Mon 11:30 - 12:30 @ Gates 131
Aaleah Mendoza
Aaleah Mendoza
She/Her pronouns, aalmarie@cs
OH: Cancelled until further notice
Assignments
Assignments
HW1 - due Friday, June 30th @ 11pm (specification, submit on Gradescope)
HW2 - due Monday, July 10th @ 11pm (specification, submit on Gradescope)
HW3 - due Wednesday, July 19th @ 11pm (specification, Azure setup guide, submit on Gradescope)
HW4 - due Friday, July 28th @ 11pm (spec)
HW5 - due Friday August 4th @ 11pm (spec)
HW6 - due Wednesday August 16th @ 11pm (spec)
Quizzes
Quizzes
Quiz 1 - Releases Thursday August 3rd. 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.
For practice problems, see midterm exam questions from Autumn 2018 and 2019
Quiz 2 - 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
Calendar
Calendar
See Canvas for lecture recordings
Date
Date
Slides
Slides
Reading
Reading
Week 1
Monday June 19
NO CLASS (holiday)
Friday, July 7
SQL Subqueries continued
6.3
Wednesday, July 12
Design - E/R cont
4.1-6
Wednesday, July 19
Design - BCNF Decomposition (cont.)
3.1-5
Week 6
Monday, July 24
Transactions - Serializability cont.
18.1-2
Week 9
Monday, August 14
Intro to Parallel Processing cont.
Section
Section
Time slots
Time slots
1:10 - 2:10 AB:
2:20 - 3:20 AA:
Materials
Materials
Section 1, June 22nd (slides (AA), demo queries)
Section 2, June 29th (slides (AB), worksheet, solutions)
Section 7, Aug 3rd (slides, serializability worksheet, solutions, locking worksheet, solutions)
Other Resources
Other Resources
Textbook
Textbook
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
Past Panopto Recordings (for UW students)
Past Panopto Recordings (for UW students)
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
Related Groups
Related Groups
Down the Rabbit Hole
Down the Rabbit Hole
Report abuse