CSE 414 Spring 2024
Course Calendar

Subscribe to this calendar (Google, iCal, etc.)

Show color key Show color key
March
MondayTuesdayWednesdayThursdayFriday
25
Lecture
Introduction (2.1-3)
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
26
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
27
Lecture
SQL Basics (6.1 - 6.2)
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
28
Section
Sqlite: slides,demo
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
29
Lecture
SQL Joins (6.1 - 6.2)
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW1 (Sqlite 1)
April
MondayTuesdayWednesdayThursdayFriday
01
Lecture
SQL: NULLs, Aggregates
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
02
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
03
Lecture
SQL Aggregates cont. demo queries
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
04
Section
Sqlite cont: slides, worksheet, solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
05
Lecture
SQL Review demo queries
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW2 (Sqlite 2)
08
Lecture
Subqueries in SQL
11:30-12:00 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
09 10
Lecture
SQL Wrapup
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
11
Section
SQL cont: slides, worksheet, solutions
11:00-11:50 OH (qirui)
CSE 3nd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
16:30-17:20 OH (Zareef)
CSE 220
12
Lecture
Relational Algebra
10:00-10:50 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
15
Lecture
ER Diagrams (2.1)
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
16
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
17
Lecture
ER Diagrams cont. (2.1)
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
18
Section
Relational algebra slides, worksheet, solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
19
Lecture
Functional Dependencies (2.2 - 2.3)
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW3 (Azure); setup video
22
Lecture
BCNF (3.4 - 3.6)
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
23
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
24
Lecture
Midterm review
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
25
Section
Functional dependencies slides worksheet solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
26
10:30-11:20 Midterm (in class)
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
29
Lecture
TXN Basics (18.1 - 18.2) demo (sqlite, python)
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
30
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
01
Lecture
Serializability (18.1 - 18.2)
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
02
Section
Serializability slides worksheet solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
03
Lecture
Locks
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW4 (DB Design)
May
MondayTuesdayWednesdayThursdayFriday
06
Lecture
Isolation Levels
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
07
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
08
Lecture
TXN Wrapup demo
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
09
Section
Locks Slides Worksheet Solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
10
Lecture
Practical Data Management demo
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW5 (TXN)
13
Lecture
Query Execution
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
14
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
15
Lecture
Disks and Indexes
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
16
Section
Extended OH for HW6
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
17
Lecture
Query Optimization (8.3-4, 14.1-7)
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW6(i) (DB App Java and Python)
20
Lecture
Semistructured Data
11:30-12:20 OH (dan)
CSE 662
14:00-14:50 OH (arjun)
CSE 3rd floor breakout
15:00-15:50 OH (cindy)
CSE 3rd floor breakout
21
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
22
Lecture
SQL++ demo
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
23
Section
Cardinality Estimation Slides Worksheet Solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
24
Lecture
SQL++ (VIDEO ONLY!) demo
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW6(ii) (DB App)
27
Memorial Day
28
16:30-17:20 OH (Zareef)
CSE 2nd floor breakout
29
Lecture
Review
12:00-12:50 OH (moe)
CSE 678
14:00-14:50 OH (madrona)
CSE 678
16:30-17:20 OH (andrew)
CSE 403
30
Section
SQL++ Slides Worksheet Solutions
12:30-13:20 OH (emi)
CSE 3rd floor breakout
13:30-14:20 OH (eden)
CSE 4th floor breakout
31
Lecture
Final Exam Review (selected problems from here)
12:00-12:50 OH (qirui)
CSE 2nd floor breakout
13:30-14:20 OH (aaron)
CSE 4th floor breakout
23:00 HW7 (SQL++)
June
MondayTuesdayWednesdayThursdayFriday
03
08:30-10:20 Final exam (same room, ECE 105)
04 05 06 07