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
Ethan Barber
Ethan Barber
He/him pronouns, ethan21@cs
OH: Mon 5:00pm - 7:00pm @ Allen 2nd Floor Breakout
Wed 2:30pm - 4:00pm @ Allen 5th Floor Breakout
Thurs 5:00pm - 7:00pm @ Allen 4th Floor Breakout
Winston Bullen
Winston Bullen
He/him pronouns, wbullen@cs
OH: Tues 2:00pm - 3:00pm @ Allen 5th Floor Breakout
Ananya Ganapathi
Ananya Ganapathi
She/her pronouns, gananya1@cs
OH: Fri 2:30pm - 3:30pm @ Gates 131
Kashyap Jagwani
Kashyap Jagwani
He/him pronouns, kashyap@uw
OH: Wed 4:30pm - 5:30pm @ Gates 131
Huong Ngo
Huong Ngo
She/her pronouns, hvn2002@uw
OH: Tues 3:00pm - 4:00pm @ Allen 5th Floor Breakout
Nina Okubo
Nina Okubo
She/her pronouns, nokubo@cs
OH: Wed 12:30pm - 1:30pm @ Gates 131
Rachel Phuong
Rachel Phuong
She/her pronouns, rphuong@cs
OH: Fri 1:30pm - 2:30pm (Zoom link)
Ananya Sharma
Ananya Sharma
She/her pronouns, ananya03@uw
OH: Mon 1:30pm - 2:30pm (Zoom link)
Assignments
Assignments
HW1 due Friday, January 13th @ 11pm (specification, submit on Gradescope)
HW2 due Monday, January 23rd @ 11pm (specification, submit on Gradescope)
HW3 due Wednesday, February 1st @ 11pm (specification, Azure setup guide, submit on Gradescope)
HW4 due Friday, February 10th @ 11pm (specification, submit on Gradescope)
HW5 (specification)
Milestone 0 due Monday, February 13th @ 11pm (no late days!) (submit on Gradescope)
Milestone 1 due Wednesday, February 22nd @ 11pm (submit on Gradescope)
Milestone 2 due Monday, March 6th Wednesday, March 8th @ 11pm (submit on Gradescope)
HW6 due Monday, March 13th Tuesday, March 14th @ 11pm (specification, submit on Gradescope)
Instruction
Instruction
Lecture
Lecture
MWF, 10:30 - 11:20 PM, MGH 389
Sections
Sections
AA, 8:30 - 9:20, MGH 228: Ethan/Johanna
AB, 9:30 - 10:20, ECE 037: Kashyap/Nina
AC, 10:30 - 11:20, JHN 026: Ananya S./Qirui
AD, 12:30 - 1:20, MEB 242: Ananya G./Winston
AE, 9:30 - 10:20, DEM 004: Huong/Matt
Calendar
Calendar
See Canvas (under Panopto tab) for lecture recordings
Date
Date
Slides
Slides
Reading
Reading
Week 1
Monday Jan 2
NO CLASS (holiday)
Week3
Monday, Jan 16
NO CLASS (holiday)
Week 4
Monday, Jan 23
SQL Subqueries cont.
6.3
Week 5
Monday, Jan 30
Design Theory (cont)
3.1-5
Friday, Feb 3
Design - BCNF Decomposition cont.
3.1-5
Wednesday, Feb 8
Transactions - Serializability cont.
18.1-2
Week 8
Monday, Feb 20
NO CLASS (holiday)
Friday, Feb 24
Query costs cont.
Wednesday, Mar 8
Parallel Databases cont.
Section Materials
Section Materials
Section 1, Jan 5 (slides [AE], demo)
Section 2, Jan 12 (slides [AB], slides [AE], worksheet, solutions, feedback form)
Section 3, Jan 19 (slides [AB], worksheet, solutions, extra RA practice, extra RA solutions)
Section 5, Feb 2 (slides[AB], worksheet, solutions)
Assessments
Assessments
Midterm Quiz
Midterm Quiz
Release: 3am on Tuesday Feb. 14
Due: 10:30am on Wednesday Feb. 15
Topics are similar problems to HW1, HW2, and HW3, as well as conceptual questions from the slides on RA and topics before the database design module.
The quiz should only take around 30-40 minutes to complete.
Final Quiz (Canceled)
Final Quiz (Canceled)
Release: 3am March 13th
Due: 11pm March 15th
Topics are similar problems to HW4, HW5, HW6 as well as conceptual questions from the slides about transaction schedules.
The quiz should only take around 30-40 minutes to complete.
Resources
Resources
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