Embedded Files
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.
If you have any questions or comments about lecture, assignments, exams, or whatever, post on the message board. This is the fastest way to get in contact with the 514 staff and your peers. You can post privately to just the staff and anonymously to the whole class if you want to. 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 tool.
Ryan Maas
Ryan Maas
(instructor)
maas @ cs . washington . edu
OH: Tuesday, 4:00-5:00 Allen 358
Jonathan Leang
Jonathan Leang
(teaching assistant)
jleang @ cs . washington . edu
OH: Monday, 4:00-5:00, SAV 141
Calendar
Calendar
(Lecture) Monday, 5:00-7:50, SAV 260
Lecture Resources:
Lecture Resources:
- January 6 - Introduction and SQL
- Introduction (large)(small)
- SQL Basics (large)(small) (demo-1.sql )
- SQL Joins (large)(small) (demo-lec03.sql )
- January 13 - More SQL - Joins and Aggregates
- January 20 - Martin Luther King Jr. Day (no class)
- January 27 - RA and SQL Subqueries
- February 3 - Database Design
- February 10 - Database Optimization
- February 17 - President's Day (no class)
- February 24 - Semi-Structured Data
- March 2 - Transactions
- March 9 - Parallel Systems and NoSQL
Lab Resources:
Lab Resources:
Assignments
Assignments
- HW1: SQLite --- Due Tuesday Jan 14th 11:59pm
- HW2: Basic SQL (dataset) --- Due Tuesday Jan 21st 11:59pm
- HW3: Advanced SQL and Azure --- Due Monday Feb 3rd 11:59pm
- HW4: Database Design --- Due Thursday Feb 13th 11:59pm
- HW5: Semi-Structured Data (dataset) --- Due Thursday Mar 5th 11:59pm
- HW6: TBD
Quizzes
Quizzes
There will be two in-class quizzes (dates TBD.) You may have handwritten notes for both quizzes, 2 sheets of notes (front and back). For reference to previous problems, see past exams on the CSE 344 and 414 course websites.
Other Resources
Other Resources
Textbooks
Textbooks
Past CSE 344/414
Past CSE 344/414
Look at the course webpage for a schedule of what topic was taught when.
- CSE 344 https://courses.cs.washington.edu/courses/cse344/
- CSE 414 https://courses.cs.washington.edu/courses/cse414/
Related Groups
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
Down the Rabbit Hole
Report abuse