Embedded Files
Lecture Room: Mondays, Wednesdays and Fridays at 3:30 - 4:20 PM
Lecture Room: Mondays, Wednesdays and Fridays at 3:30 - 4:20 PM
Q&A: Following class
Q&A: Following class
Announcement:
Announcement:
Apr 3: An additional evening section was allocated for stduents not in the North American time-zone.
March 28: Account activation is needed before logging into the Discussion Board. Look for the email "Activate your Ed account for CSE 414". Contact staff if additional help is needed.
CSE 414 Staff
CSE 414 Staff
cse414-staff@cs
Mark Friedman
Mark Friedman
He/him pronouns, mbfried@cs
Alternative email: markf@demandtech.com
OH:Wednesday 2:00 PM - 3:00 PM via Zoom
Steve Ma
Steve Ma
He/him pronouns, bochenma@cs
OH: Friday 11:30 AM - 12:30 PM via Zoom
Chloe Wen
Chloe Wen
She/her pronouns, wenchloe@cs
OH:Tuesday 12:30 PM - 1:30 PM via Zoom
Shana Hutchison
Shana Hutchison
She/her pronouns, shutchis@cs
Xinyue Chen
Xinyue Chen
She/her pronouns, chenxy20@cs
OH:Thursday 7:00 PM - 8:00 PM via Zoom
Calendar
Calendar
Lecture MWF, 3:30-4:20, Mark Friedman Lecture Q&A
Section AE/BE: Steve & Prati, TH 11:30 - 12:20 PM via Zoom
Section AA/BA: Chloe & Apurv, TH 12:30 - 1:20 PM via Zoom
Section AB/BB : Shana & Nalin, TH 1:30 - 2:20 PM via Zoom
Section AC/BC: Xinyue & Chris, TH 2:30 - 3:20 PM via Zoom
Section AD/BD: Gibbs & Tanish, TH 3:30 - 4:20 PM via Zoom
Section AF/BF: Josh & Patrick, TH 8:00 - 8:50 PM via Zoom
Lecture Resources:
Lecture Resources:
PowerPoint font
- Monday, March 30, Introduction
- Wednesday, April 1, Joins
- Friday, April 3, Joins
- Monday, Apr 6, Aggregates
- Wednesday, April 8, Subqueries
- Friday, April 10, ER diagram
- Monday, April 13, Subqueries & Logical Database Design
- Wednesday, April 15, Logical Database Design
- Friday, April 17, Demo
- Monday, April 20, Design Theory
- Wednesday, April 22, Relational Algebra
- Friday, April 24, Exploring Data
- Monday, April 27, SQL Query Execution
- Wednesday, April 29, Cost Estimation
- Monday, May 4th, Serializability
- Wednesday, May 6th, Serializability
- Friday, May 8th, Serializability
- Monday, May 11th, Serializability
- Wednesday, May 13th, Serializability
- Friday, May 15th, Serializability
- Monday, May 18th, Physical Database
- Wednesday, May 20th, Physical Database
- Friday, May 22nd, Physical Database
- Wednesday, May 27th, Physical Database
- Friday, May 29th, Beyond SQL
- Monday, June 1st, Beyond SQL
- Wednesday, June 3rd, Beyond SQL
- Friday, June 5th, Beyond SQL
Section Resources:
Section Resources:
- 2020-04-02 Slides Demo Demo(AE/BE) Demo(AD/BD)
- 2020-04-09 Slides Worksheet Worksheet-Google-Doc Solutions-Google-Doc
- 2020-04-16 Slides Worksheet Solutions
- 2020-04-23 Slides Slides-Evening-Section
- 2020-04-30 Slides (AE/BE) Slides-Evening-Section
- 2020-05-07 Flight Booking App Intro Slides Slides2 DemoOfInjection
- 2020-05-14 Hw5 Debugging Slides
- 2020-05-21 Serializabilty and Isolation Levels Slides
- 2020-05-28 Semi-structured data, JSON, AsterixDB, SQL++ Slides Worksheet Solutions
- 2020-06-04 Wrap-up Slides
Readings
Readings
- ch1, ch 2-2.5, ch 6-6.5
Due Date: April 6th
- ch3, ch4.1 - 4.8
Due Date: April 18th
- Indexes: section 8.3 & 8.4
SQL database servers: 9.1 – 9.4
Index structures (b-trees and Hash tables): 14.1 – 14.3
Assignments
Assignments
- Homework 1, due April 6 @ 11:59pm
- Homework 2, due April 13 @ 11:59pm
- Homework 3, due April 24 @ 11:59pm
- Homework 4, due May 4 @ 11:59pm
- Homework 5, Milestone 1 due May 13 @11:59pm, Milestone 2 due May 25 @11:59pm
- Homework 6, due June 3 @11:00pm
Exams
Exams
Midterm exam resources
Midterm exam resources
- 344 exams from previous quarters
- 414-2018au
- 344-2019au / solutions
- 414-2019au / solutions
- 414-2020wi / solutions
Final exam resources
Final exam resources
Resources
Resources
You are welcome to attend CSE 344 lectures with Alyssa Pittman. See this quarter's 344 schedule.
Textbooks
Textbooks
- Database Systems: The Complete Book (2nd Edition) <errata>
- Fundamentals of Database Systems (7th Edition)
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 Winter 2020 - Shana Hutchison - videos, course webpage
- CSE 344 Spring 2019 - Jonathan Leang - videos, course webpage
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
Page updated
Report abuse