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
25
Section
SQLite Intro
Slides, Demo
18:00-19:00 Angie Online Support Hrs
Zoom
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
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
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
02
Section
SQL Joins and Nulls
18:00-19:00 Angie Online Support Hrs
Zoom
03
09:30-10:20 Lecture
IEB G109
SQL Aggregates
Textbook section 6.4
DRAFT Slides
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
October
MondayTuesdayWednesdayThursdayFriday
06
09:30-10:20 Lecture
IEB G109
SQL Aggregates with Joins
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
22:00 HW2 (Basic SQL Queries) due
08
09:30-10:20 Lecture
IEB G109
Data in Context; SQL Subqueries
Textbook section 6.3
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
09
Section
Aggregates, Group Bys and Subqueries
18:00-19:00 Angie Online Support Hrs
Zoom
10
09:30-10:20 Lecture
IEB G109
SQL Subqueries (cont.)
Same textbook section (6.3)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
13
09:30-10:20 Lecture
IEB G109
SQL Query Patterns; Design: Entities, Relationships, and ER Diagrams
Textbook sections 4.1-4.6
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
22:00 HW3 (Advanced SQL Queries) due
15
09:30-10:20 Lecture
IEB G109
Design: Entities, Relationships, and ER Diagrams (cont.)
Same textbook sections (4.1-4.6)
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
16
Section
ER Diagrams and Functional Dependencies
18:00-19:00 Angie Online Support Hrs
Zoom
17
09:30-10:20 Lecture
IEB G109
Design: Design Theory and Normalization
Textbook sections 3.1-3.5
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)
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
22:00 HW4 (Design Theory) due
22
09:30-10:20 Lecture
IEB G109
Design: Physical Design and Indexes
Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3 (design)
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
23
Section
Relational Algebra, Indexing, and Prepared Statements
18:00-19:00 Angie Online Support Hrs
Zoom
24
09:30-10:20 Midterm exam
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
27
09:30-10:20 Lecture
IEB G109
Database Applications; Password Handling
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
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
30
Section
Cardinality Estimation, SQL Injection, and Join Algorithms
18:00-19:00 Angie Online Support Hrs
Zoom
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
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
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
06
Section
Transactions, Serializability, and Locking
18:00-19:00 Angie Online Support Hrs
Zoom
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
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
22:00 FlightApp Project: M1 due
13
Section
More Locking & Office Hours
18:00-19:00 Angie Online Support Hrs
Zoom
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
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
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
20
Section
Parallel DBs & Data Governance
18:00-19:00 Angie Online Support Hrs
Zoom
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: Intro; NoSQL: Key/Value Stores
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
22:00 HW6 (Transactions and Society) due
26
09:30-10:20 Lecture
IEB G109
NoSQL: Document Stores
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
27
Thanksgiving
28
Native American Heritage Day
December
MondayTuesdayWednesdayThursdayFriday
01
09:30-10:20 Lecture
IEB G109
Privacy and Joins
Proximity Marketing article
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout
19:00-21:00 Aneesha Online Support Hrs
Zoom
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
03
09:30-10:20 Lecture
IEB G109
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
04
Section
SQL++ & NoSQL
18:00-19:00 Angie Online Support Hrs
Zoom
05
09:30-10:20 Lecture
IEB G109
NoSQL Conclusion; Course Conclusion
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
22:00 HW7 (NoSQL Design) due
08 09 10
08:30-10:20 Final exam
11 12