CSE 344 (Win 2026) Course Calendar

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

January
Monday	Tuesday	Wednesday	Thursday	Friday
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 Data in Context; SQL Subqueries Textbook section 6.3 DRAFT Context Slides, DRAFT Subquery Slides 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section SQL Aggregates, Group Bys and Subqueries 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.) Same textbook section (6.3)
09:30-10:20 Lecture SAV 260 SQL Query Patterns; Design: Entities, Relationships, and ER Diagrams Textbook sections 4.1-4.6 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	09:30-10:20 Lecture SAV 260 Design: Entities, Relationships, and ER Diagrams (cont.) Same textbook sections (4.1-4.6) 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section ER Diagrams 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 Textbook sections 3.1-3.5

February
Monday	Tuesday	Wednesday	Thursday	Friday
09:30-10:20 Lecture SAV 260 Design: Design Theory and Normalization (cont.) Same textbook sections (3.1-3.5) 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 HW4 (Design Theory) due	09:30-10:20 Lecture SAV 260 Database Applications; Password Handling 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section Functional Dependencies and BCNF Decomposition 11:00-12:00 Maria Support Hours Gates (CSE2) 151 13:30-15:20 Ajay Support Hours Gates (CSE2) 121 22:00 FlightApp Project: M0 due	09:30-10:20 Lecture SAV 260 Design: Physical Design and Indices Textbook sections 13.1-13.2; 14.1-14.2
09:30-10:20 Lecture SAV 260 Design: Physical Design and Indices (cont.) Textbook sections 8.3-8.4.3 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 Query Execution: Relational Algebra Textbook sections 2.4; 5.1-5.2 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section Indexing and PreparedStatements 11:00-12:00 Maria Support Hours Gates (CSE2) 151 13:30-15:20 Ajay Support Hours Gates (CSE2) 121	09:30-10:20 Midterm
President's Day	15:30-17:20 Aditi Support Hours Allen (CSE1) 5th Fl breakout 22:00 FlightApp Project: M1	09:30-10:20 Lecture SAV 260 GUEST LECTURER: Query Execution: Relational Algebra (cont.) Same textbook sections (2.4; 5.1-5.2) 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section Relational Algebra 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 FORMAT TBD: Query Execution: Cardinality Estimation Textbook sections 16.1-16.4
09:30-10:20 Lecture SAV 260 Query Execution: Cardinality Estimation (cont.); Privacy and Joins Same textbook sections (16.1-16.4); 16.5.1-16.5.3; Proximity Marketing article; textbook sections 16.1-16.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	15:30-17:20 Aditi Support Hours Allen (CSE1) 5th Fl breakout 22:00 Flightapp Project: M2 due	09:30-10:20 Lecture SAV 260 Query Execution: Physical Algorithms and Pipelining Textbook sections 15.1-15.4; 15.6.1-15.6.2 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section Cardinality Estimation 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 Query Execution: Physical Algorithms and Pipelining (cont.) Same textbook sections (15.1-15.4; 15.6.1-15.6.2); 15.6.1-15.6.4

March
Monday	Tuesday	Wednesday	Thursday	Friday
09:30-10:20 Lecture SAV 260 Transactions: Basics Textbook section 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	15:30-17:20 Aditi Support Hours Allen (CSE1) 5th Fl breakout 22:00 HW5 (Query Execution) due	09:30-10:20 Lecture SAV 260 Transactions: Serializability Same textbook sections (18.1-18.4) 13:30-14:20 Hannah Support Hours Allen (CSE1) 210	Section Join Algorithms and Transactions 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 Transactions: Locking Same textbook sections (18.1-18.4)
09:30-10:20 Lecture SAV 260 Transactions: Locking (cont.); Data Governance Same textbook sections (18.1-18.4); NYT Taxicab post 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 HW6 (Transactions and Society) due	09:30-10:20 Lecture SAV 260 Partitioning and Parallel Query Execution 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 13:30-15:20 Ajay Support Hours Gates (CSE2) 121	09:30-10:20 Lecture SAV 260 Parallel Query Execution (cont.); Course Conclusion Same textbook sections (20.1; 20.3-20.4.2)
		08:30-10:20 Final exam