Introduction to Data Management
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.
Remote quarter: This quarter is mandated to have fully online instruction with no in-person meetings permitted. So long as the staff internet connections permit, we will still be holding synchronous lecture/section meetings so that students have the opportunity to ask questions and work together - please do attend and participate! Lecture recordings will be posted if you need to access them asynchronously.
Questions and Comments: If you have any questions or comments about lecture, sections, assignments, quizzes, or whatever, post on Piazza. This is the fastest way to get in contact with the 344 staff and your peers. You can post privately to just the staff and anonymously to the whole class if you want to. Please note that when signing up for Piazza, Piazza specifies an option (default is to agree) to share your contact information with companies for recruiting purposes. Opt out of this option if you wish. 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.
For additional details about the class, please refer to the syllabus.
CSE 344 Staff
Ethan Sylvia
He/They pronouns, ethans24@cs
OH: Wednesday 4pm- 5pm
Steve Ma
He/him pronouns, bochenma@cs
OH: Thursday 7pm - 8pm
Nishtha Agarwal
Instruction
Note that all instruction for the quarter is remote. Links to the Zoom meetings and lecture recordings can be found on Canvas.
(Lecture) MWF, 2:20 - 3:20 PM Zoom Classroom
(Section AA) Th, 2:20 - 3:20 PM Zoom Classroom Ethan & Nishtha
(Section AB) Th, 1:10 - 2:10 PM Zoom Classroom Steve & Nishtha
Assignments
HW1 due June 29 @11 PM (Gradescope)
HW2 due July 9 @11 PM (Spec, Gradescope)
HW3 due July 16 @11 PM (Spec, Azure Setup Guide, Gradescope)
HW4 due July 26 @11 PM (Spec, Gradescope)
HW5 part 1 due Aug 7 @11 PM (Java Spec, Python Spec, Gradescope)
HW5 Part 2 due Aug 19 @11 PM (Spec, SQL Script, ER Diagram, Gradescope)
HW6 due TBD
Quizzes
Quiz 1 out Thursday July 22 @ 3am, due July 23 @ 1pm (Topics are similar problems to HW 1 and HW 2, as well as conceptual questions from the slides. The quiz should only take around 30-40 minutes to complete.)
Log into our course page on Gradescope to complete the quiz.
For practice problems, see midterm exam questions from Autumn 2018 and 2019
Quiz 2 out Thursday August 12 @ 3am, due August 13 @ 10am (Topics are similar problems to HW 3 and HW 4, 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
See Canvas for lecture recordings
Date
Slides
Reading
Week3
Monday, July 5
NO CLASS (holiday)
Friday, August 6
Intro to Parallel Processing cont.
Section
2021-06-24 ~ Intro with SQLite - (slides Section AA), (slides Section AB)
2021-07-01 ~ SQL Practice ~ (slides), (worksheet), (solution)
2021-07-15 ~ Design Practice & RA Practice ~ (section slides), (worksheet), (solution)
2021-07-22 ~ Functional Dependencies & BCNF ~ (worksheet), (section slides), (solution)
2021-07-29 ~ HW 5 Demo & Setup~ section recordings on Canvas
2021-08-12 ~ AstrixDB/NoSQL / SQL++ ~ (Slides)
Other Resources
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)
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