Zoom Classroom

Piazza Discussion Board

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! The class Canvas holds our full Zoom schedule, or refer to this pinned Piazza post for a list of all relevant links. 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 (robthomp @ 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 or feel free to contact us directly.

For additional details about the class, please refer to the syllabus.

Assignments

• HW1 due October 7 @ 11pm - Spec - Gradescope

• HW2 due October 15th @ 11pm - Spec

• HW3 due October 27th @ 11pm - Spec

• HW4 due November 6th @ 11pm - Spec

• HW5 Milestone 1 due November 20th - Spec Video intro

• HW5 Milestone 2 due November 29th

• HW6 due December 6th @ 11pm - Spec

• HW7 due December 13th @ 11pm - Spec

• HW8 (optional) due December 13th @ 11pm - Spec

Quizzes (tentative)

See our quiz page for more information and prep material.

• Quiz 1: SQL, October 16th

• Quiz 2: RA, ER, BCNF, October 30th

• Quiz 3, Transactions and Cost Estimation, November 13th

• Quiz 4, Parallelism, December 8th

• Quiz 5, SQL++, GraphDB, December 14th

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

Related Groups

• UW Database Group

• UW eScience Institute

• SIGMOD (Special Interest Group on Management of Data)

• PODS (Symposium on Principles of Database Systems)

• CIDR (Conference on Innovative Data Systems Research)

• VLDB (Very Large Data Base Endowment Inc.)

Down the Rabbit Hole

• arXiv - Databases

• SQL Injection Practice (University of Virginia)

• Canadian Data Center Unboxing (Linus Tech Tips)

• Computerphile MapReduce and Spark