CSE 344 (Win 2026) Course Calendar

See Canvas for the full list of lecture and section recordings
Subscribe to this calendar (Google, iCal, etc.)

Show color key Show color key
January
MondayTuesdayWednesdayThursdayFriday
09:30-10:20 Lecture
SAV 260
Introduction (Syllabus + Relational Model)
Textbook sections 2.1-2.3
Slides, Video
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
09:30-10:20 Lecture
SAV 260
SQL Basics (SELECT-FROM-WHERE, nested-loop semantics)
Textbook sections 6.1-6.2
Slides, Intended-but-cancelled Demo, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
SQLite Intro
Slides, Demo
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
13:30-15:20 Ajay Support Hours
Gates (CSE2) 121
09:30-10:20 Lecture
SAV 260
SQL Joins (Inner Joins)
Same textbook sections (6.1-6.2)
Slides, Intended-but-cancelled Demo, Video
09:30-10:20 Lecture
SAV 260
SQL Joins (Outer Joins and NULL)
Same textbook sections (6.1-6.2)
Slides, Intended-but-cancelled Demo, Video
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
22:00 HW1 (Intro to SQL and SQLite) due
09:30-10:20 Lecture
SAV 260
SQL Aggregates
Textbook section 6.4
Slides, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
SQL Joins and Nulls
Slides, Worksheet, HW2 Demo , Solutions
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
13:30-15:20 Ajay Support Hours
Gates (CSE2) 121
09:30-10:20 Lecture
SAV 260
SQL Aggregates with Joins
Slides, Video
MLK Day
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
22:00 HW2 (Basic SQL Queries) due
(direct link to flights schema documentation)
09:30-10:20 Lecture
SAV 260
SQL Subqueries
Textbook section 6.3
Slides, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
SQL Aggregates, Group Bys and Subqueries
Slides, Worksheet, Solutions
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
13:30-15:20 Ajay Support Hours
Gates (CSE2) 121
09:30-10:20 Lecture
SAV 260
SQL Subqueries (cont.); SQL Query Patterns
Same textbook section (6.3)
Subq Slides, Pattern Slides, Video
09:30-10:20 Lecture
SAV 260
Design: Entities, Relationships, and ER Diagrams
Textbook sections 4.1-4.6
Slides, Video
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
22:00 HW3 (Advanced SQL Queries) due
(direct link to setup documentation)
09:30-10:20 Lecture
SAV 260
Design: Entities, Relationships, and ER Diagrams (cont.); Design: Design Theory and Normalization
Same textbook sections (4.1-4.6); Textbook sections 3.1-3.5
ER Slides, Normalization Slides, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
ER Diagrams
Slides, Worksheet, Solutions
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
13:30-15:20 Ajay Support Hours
Gates (CSE2) 121
09:30-10:20 Lecture
SAV 260
Design: Design Theory and Normalization (cont.)
Same textbook sections (3.1-3.5)
Slides, Video
February
MondayTuesdayWednesdayThursdayFriday
09:30-10:20 Lecture
SAV 260
Design: Design Theory and Normalization (cont.)
Same textbook sections (3.1-3.5)
Slides, Video
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
09:30-10:20 Lecture
SAV 260
Database Applications; Password Handling
DB Apps Slides, Password Slides, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
Functional Dependencies and BCNF Decomposition
Slides, Worksheet, Solutions
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
13:30-15:20 Ajay Support Hours
Gates (CSE2) 121
22:00 HW4 (Design Theory) due (only one late day token allowed)
09:30-10:20 Lecture
SAV 260
Design: Physical Design and Indices
Textbook sections 13.1-13.2; 14.1-14.2
Slides, Video
22:00 FlightApp Project: M0 due (direct link to setup documentation)
09:30-10:20 Lecture
SAV 260
Design: Physical Design and Indices (cont.); Data in Context
Textbook sections 8.3-8.4.3
Design Slides, Context Slides, Video
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
12:30-13:20 Ajay Support Hours
Gates (CSE2) 153
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
09:30-10:20 Lecture
SAV 260
Query Execution: Relational Algebra
Textbook sections 2.4; 5.1-5.2
Slides, Handout, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
Indexing and PreparedStatements
Slides, SQL Injection Demo, PreparedStatements Demo
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
09:30-10:20 Midterm (preview available here)
President's Day
09:30-10:20 Audrey BONUS Support Hours
Allen (CSE1) 3rd Fl breakout
11:30-12:20 Kevin BONUS Support Hours
Gates (CSE2) 151
12:30-13:20 Ajay Support Hours
Gates (CSE2) 153
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
22:00 FlightApp Project: M1 due (direct link to TESTING documentation)
09:30-10:20 Lecture
SAV 260
GUEST LECTURER: Query Execution: Relational Algebra (cont.)
Same textbook sections (2.4; 5.1-5.2)
Slides, Video
Section
Relational Algebra and Transactions
Slides, Worksheet, Solutions
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
09:30-10:20 Lecture
SAV 260
GUEST LECTURER: Query Execution: Relational Algebra (cont.); Query Execution: Cardinality Estimation
Textbook sections 16.1-16.4; Background Video 1, Background Video 2
Slides, Video
09:30-10:20 Lecture
SAV 260
Transactions: Basics
Textbook section 18.1-18.4
Slides, Video
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
09:30-10:20 Audrey BONUS Support Hours
Allen (CSE1) 3rd Fl breakout
12:30-13:20 Ajay Support Hours
Gates (CSE2) 153
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
09:30-10:20 Lecture
SAV 260
Query Execution: Cardinality Estimation (cont.); Transactions: Serializability
Same textbook sections (16.1-16.4), then 16.5.1-16.5.3; Same textbook sections (18.1-18.4)
Cardinality Slides, Serializability Slides, Video
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
M2 Transactions and Cardinality Estimation
DRAFT Slides
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
22:00 FlightApp Project: M2 due (direct link to TESTING documentation)
09:30-10:20 Lecture
SAV 260
Transactions: Serializability (cont.); Transactions: Locking
Same textbook sections (18.1-18.4)
DRAFT Slides
10:30-11:20 Kevin BONUS Support Hours
Allen (CSE1) 5th Fl breakout
20:00-21:00 Ajay BONUS Support Hours
Virtual
March
MondayTuesdayWednesdayThursdayFriday
09:30-10:20 Lecture
SAV 260
Transactions: Locking (cont.)
Same textbook sections (18.1-18.4)
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
12:30-13:20 Ajay Support Hours
Gates (CSE2) 153
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
09:30-10:20 Lecture
SAV 260
Data in Context; Query Execution: Physical Algorithms and Pipelining
Proximity Marketing article; Textbook sections 15.1-15.4; 15.6.1-15.6.2
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
Transaction Implementation
DRAFT Slides
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
22:00 HW5 (Query Execution) due
09:30-10:20 Lecture
SAV 260
Query Execution: Physical Algorithms and Pipelining (cont.)
Same textbook sections (15.1-15.4; 15.6.1-15.6.2), then 15.6.1-15.6.4
09:30-10:20 Lecture
SAV 260
Partitioning and Parallel Query Execution
Textbook section 20.1; 20.3-20.4.2
11:30-12:20 Hannah and Ozan Support Hours
Allen (CSE1) 4th Fl breakout
15:30-16:20 Rudra and Kevin Support Hours
Allen (CSE1) 3rd Fl breakout
16:30-17:20 Audrey Support Hours
Allen (CSE1) 3rd Fl breakout
12:30-13:20 Ajay Support Hours
Gates (CSE2) 153
15:30-17:20 Aditi Support Hours
Allen (CSE1) 5th Fl breakout
09:30-10:20 Lecture
SAV 260
Partitioning and Parallel Query Execution (cont.)
Same textbook sections (20.1; 20.3-20.4.2)
13:30-14:20 Hannah Support Hours
Allen (CSE1) 210
Section
Serializability, Locking, and Data Governance
11:00-12:00 Maria Support Hours
Gates (CSE2) 151
22:00 HW6 (Transactions and Society) due
09:30-10:20 Lecture
SAV 260
Data Governance; Course Conclusion
NYT Taxicab post
08:30-10:20 Final exam