CSE 344 (Aut 2025) 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
September
MondayTuesdayWednesdayThursdayFriday
22 23 24
09:30-10:20 Lecture
IEB G109
Introduction (Syllabus + Relational Model)
Textbook sections 2.1-2.3
Slides, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
25
Section
SQLite Intro
Slides, Demo
18:00-19:00 Angie Online Support Hrs
Zoom link
26
09:30-10:20 Lecture
IEB G109
SQL Basics (SELECT-FROM-WHERE, nested-loop semantics)
Textbook sections 6.1-6.2
Slides, Demo, Video
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
29
09:30-10:20 Lecture
IEB G109
SQL Joins (Inner Joins)
Same textbook sections (6.1-6.2)
Slides, Demo, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
30
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 HW1 (Intro to SQL and SQLite) due
01
09:30-10:20 Lecture
IEB G109
SQL Joins (Outer Joins and NULL)
Same textbook sections (6.1-6.2)
Slides, Demo, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
02
Section
SQL Joins and Nulls
Slides, Worksheet, Worksheet Solutions
18:00-19:00 Angie Online Support Hrs
Zoom link
03
09:30-10:20 Lecture
IEB G109
SQL Aggregates
Textbook section 6.4
Slides, Video
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
October
MondayTuesdayWednesdayThursdayFriday
06
09:30-10:20 Lecture
IEB G109
SQL Aggregates with Joins; Data in Context
SQL Slides, Context Slides, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
07
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 HW2 (Basic SQL Queries) due
(direct link to flights schema documentation)
08
09:30-10:20 Lecture
IEB G109
SQL Subqueries
Textbook section 6.3
Slides, SUPPLEMENTAL Slides (witnessing problem as a self-join), Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
09
Section
Aggregates, Group Bys and Subqueries
Slides, Worksheet, Worksheet Solutions
18:00-19:00 Angie Online Support Hrs
Zoom link
10
09:30-10:20 Lecture
IEB G109
SQL Subqueries (cont.)
Same textbook section (6.3)
Slides, Video
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
13
09:30-10:20 Lecture
IEB G109
SQL Subqueries (cont.); SQL Query Patterns
Same textbook section (6.3)
Subquery Slides, Query Patterns Slides, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
14
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 HW3 (Advanced SQL Queries) due
(direct link to setup documentation)
15
09:30-10:20 Lecture
IEB G109
Design: Entities, Relationships, and ER Diagrams
Textbook sections 4.1-4.6
Slides, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
16
Section
ER Diagrams
Slides, Worksheet, Worksheet Solutions
18:00-19:00 Angie Online Support Hrs
Zoom link
17
09:30-10:20 Lecture
IEB G109
Design: Entities, Relationships, and ER Diagrams (cont.); Design: Design Theory and Normalization
Same textbook sections (4.1-4.6) for ER Diagrams; sections 3.1-3.5 for Design Theory
ER Slides, Normalization Slides, Video
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
20
09:30-10:20 Lecture
IEB G109
Design: Design Theory and Normalization (cont.)
Same textbook sections (3.1-3.5)
Slides, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
21
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22
09:30-10:20 Lecture
IEB G109
Design: Design Theory and Normalization (cont.); Design: Physical Design and Indexes
Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3 (design)
Slides, Supplemental B+-tree Slides, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
23
Section
Functional Dependencies and Indexing
Slides, Worksheet,
18:00-19:00 Angie Online Support Hrs
Zoom link
24
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
22:00 Take-home Midterm due
27
09:30-10:20 Lecture
IEB G109
Design: Physical Design and Indexes (cont.); Database Applications; Password Handling
DRAFT Design Slides, DRAFT DB Apps Slides, DRAFT PW Handling Slides
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
28
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 HW4 (Design Theory) due
29
09:30-10:20 Lecture
IEB G109
Query Execution: Relational Algebra
Textbook sections 2.4; 5.1-5.2 (execution)
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin Support Hrs
Allen (CSE1) 220
17:00-18:00 Angie Online Support Hrs
Zoom link
30
Section
Relational Algebra, Prepared Statements, and SQL Injection
18:00-19:00 Angie Online Support Hrs
Zoom link
31
09:30-10:20 Lecture
IEB G109
Query Execution: Relational Algebra (cont.)
Same textbook sections (2.4; 5.1-5.2)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
November
MondayTuesdayWednesdayThursdayFriday
03
09:30-10:20 Lecture
IEB G109
Query Execution: Cardinality Estimation
Textbook sections 16.1-16.4
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
04
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 HW5 (Query Execution) and FlightApp Project: M0 due
05
09:30-10:20 Lecture
IEB G109
Query Execution: Physical Algorithms; Pipelining
Textbook sections 15.1-15.4; 15.6.1-15.6.2
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
06
Section
Cardinality Estimation and Join Algorithms
18:00-19:00 Angie Online Support Hrs
Zoom link
07
09:30-10:20 Lecture
IEB G109
Query Execution: Physical Algorithms; Pipelining (cont.)
Same Textbook sections (15.1-15.4; 15.6.1-15.6.2)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
10
09:30-10:20 Lecture
IEB G109
Transactions: Basics
Textbook section 18.1-18.4
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
11
Veteran's Day
12
09:30-10:20 Lecture
IEB G109
Transactions: Serializability
Same textbook sections (18.1-18.4)
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
22:00 FlightApp Project: M1 due
13
Section
Transactions, Serializability
18:00-19:00 Angie Online Support Hrs
Zoom link
14
09:30-10:20 Lecture
IEB G109
Transactions: Locking
Same textbook sections (18.1-18.4)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
17
09:30-10:20 Lecture
IEB G109
Transactions: Locking (cont.); Data Governance
Same textbook sections (18.1-18.4); NYT Taxicab post
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
18
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 FlightApp Project: M2 due
19
09:30-10:20 Lecture
IEB G109
Partitioning and Parallel Query Execution
20.1; 20.3-20.4.2
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
20
Section
Locking, Data Governance, and Parallel DBs
18:00-19:00 Angie Online Support Hrs
Zoom link
21
09:30-10:20 Lecture
IEB G109
Parallel Query Execution (cont.); NoSQL: Intro
Same textbook sections (20.1; 20.3-20.4.2)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
24
09:30-10:20 Lecture
IEB G109
NoSQL: Key/Value Stores; NoSQL: Document Stores
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
25
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
22:00 HW6 (Transactions and Society) due
26
09:30-10:20 Lecture
IEB G109
NoSQL: Document Stores (cont.); NoSQL: Wide Column
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
27
Thanksgiving
28
Native American Heritage Day
December
MondayTuesdayWednesdayThursdayFriday
01
09:30-10:20 Lecture
IEB G109
Privacy and Joins; NoSQL: Wide Column (cont.)
Proximity Marketing article
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
02
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom link
03
09:30-10:20 Lecture
IEB G109
NoSQL: Wide Column (cont.); NoSQL Conclusion
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
17:00-18:00 Angie Online Support Hrs
Zoom link
04
Section
NoSQL and Office Hours
18:00-19:00 Angie Online Support Hrs
Zoom link
05
09:30-10:20 Lecture
IEB G109
Course Conclusion
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
22:00 HW7 (NoSQL Design) due
08 09 10
10:20 Take-home Final due
11 12