CSE 344 (Spr 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
March
SundayMondayTuesdayWednesdayThursdayFridaySaturday
30 31
09:30-10:20 Lecture
MGH 389
Introduction (Syllabus + Relational Model)
Textbook sections 2.1-2.3
Slides, Video
01 02
09:30-10:20 Lecture
MGH 389
SQL Basics (SELECT-FROM-WHERE, nested-loop semantics)
Textbook sections 6.1-6.2
Slides, Video, Demo
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
03
Section
SQLite Intro
Slides, Demo SQL
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
04
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
SQL Joins (Inner Joins)
Same textbook sections (6.1-6.2)
Slides, Video, Demo
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 5th Fl. Breakout
05
April
SundayMondayTuesdayWednesdayThursdayFridaySaturday
06 07
09:30-10:20 Lecture
MGH 389
SQL Joins (Outer Joins and NULL) SQL Aggregates
Same textbook sections (6.1-6.2) Textbook section 6.4
Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
08
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW1 (Intro to SQL and SQLite) due
09
09:30-10:20 Lecture
MGH 389
SQL Aggregates SQL Joins (Outer Joins and NULL)
Textbook section 6.4 Same textbook sections (6.1-6.2)
Slides, Video, Demo
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
10
Section
SQL Joins and Nulls
Slides, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
11
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
SQL Aggregates with Joins
SQL Slides, Video
12
13 14
09:30-10:20 Lecture
MGH 389
Data in Context; SQL Subqueries
Textbook section 6.3
Context Slides, Subqueries Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
15
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW2 (Basic SQL Queries) due (schema documentation)
16
09:30-10:20 Lecture
MGH 389
SQL Subqueries (cont.)
Same textbook section (6.3)
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
17
Section
Aggregates, Group Bys and Subqueries
Slides, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
18
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
SQL Query Patterns; Design: Entities, Relationships, and ER Diagrams
Textbook sections 4.1-4.6
Query Pattern Slides, Design Slides, Video
19
20 21
09:30-10:20 Lecture
MGH 389
Design: Entities, Relationships, and ER Diagrams (cont.)
Same textbook sections (4.1-4.6)
Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
22
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW3 (Advanced SQL Queries) due
23
09:30-10:20 Lecture
MGH 389
Design: Design Theory and Normalization
Textbook sections 3.1-3.5
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
24
Section
ER Diagrams and Functional Dependencies
Slides, Worksheet, Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 Quiz 1 due
25
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
GUEST LECTURE: Design: Design Theory and Normalization (cont.)
Same textbook sections (3.1-3.5)
Slides, Video
26
27 28
09:30-10:20 Lecture
MGH 389
Design: Physical Design and Indexes; Query Execution: Relational Algebra
Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3 (design); sections 2.4; 5.1-5.2 (execution)
Design Slides, Execution Slides, Video, Handout
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
29
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW4 (Database Design) due
30
09:30-10:20 Lecture
MGH 389
GUEST LECTURE: Query Execution: Relational Algebra (cont.)
Same textbook sections (2.4; 5.1-5.2)
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
01
Section
Relational Algebra, Indexing, and Prepared Statements
Slides, Worksheet, Worksheet Solutions, Demo
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
02
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
Query Execution: Cardinality Estimation
Textbook sections 16.1-16.4
Slides, Video
03
May
SundayMondayTuesdayWednesdayThursdayFridaySaturday
04 05
09:30-10:20 Lecture
MGH 389
GUEST LECTURE: Database Applications; Password Handling
DRAFT DB Apps Slides, DRAFT Password Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
06
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW5 (Query Execution) + Project (Flights Application) M0 due
07
09:30-10:20 Lecture
MGH 389
Query Execution: Physical Algorithms; Pipelining
Textbook sections 15.1-15.4; 15.6.1-15.6.2
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
08
Section
Cardinality Estimation, SQL Injection, and Join Algorithms
Slides, Demo, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
09
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
Query Execution: Physical Algorithms; Pipelining (cont.)
Same Textbook sections (15.1-15.4; 15.6.1-15.6.2)
Slides, Video
10
11 12
09:30-10:20 Lecture
MGH 389
Transactions: Basics
Textbook section 18.1-18.4
Slides, Video, Demo
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
13
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
14
09:30-10:20 Lecture
MGH 389
Transactions: Serializability
Same textbook sections (18.1-18.4)
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 Quiz 2 due
15
Section
Transactions, Serializability, and Locking
Slides, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
16
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
Transactions: Locking
Same textbook sections (18.1-18.4)
Slides, Video
12:30-14:00 Khushi: ✨ Extra Support Hrs ✨
Allen (CSE1) 3rd Fl. Breakout
14:00-15:00 Hannah: πŸŽ‰ Extra Support Hrs πŸŽ‰
Allen (CSE1) 214
22:00 Project (Flights Application) M1 due (setup and testing documentation)
17
18 19
09:30-10:20 Lecture
MGH 389
Transactions: Locking (cont.); Data Governance
Same textbook sections (18.1-18.4); NYT Taxicab post
Transactions Slides, Governance Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
20
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
21
09:30-10:20 Lecture
MGH 389
Partitioning and Parallel Query Execution
20.1; 20.3-20.4.2
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
22
Section
More Locking & Office Hours
Slides, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
23
09:30-10:20 Lecture
MGH 389
Parallel Query Execution (cont.); NoSQL: Intro
Same textbook sections (20.1; 20.3-20.4.2)
Query Execution Slides, NoSQL Slides, Video
11:00-12:00 Kevin: 🎈 Extra Support Hrs 🎈
Allen (CSE1) 5th Fl. Breakout
12:00-13:00 Hannah: 🀩 Extra Support Hrs 🀩
Allen (CSE1) 5th Fl. Breakout
13:00-14:00 Ananya: 🎢Extra Support Hrs🎢
Allen (CSE1) 3rd Fl. Breakout
22:00 Project (Flights Application) M2 due (setup and testing documentation)
24
25 26
Memorial Day
27
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
28
09:30-10:20 Lecture
MGH 389
NoSQL: Intro; NoSQL: Key/Value Stores
Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 Quiz 3 due
29
Section
Parallel DBs & Data Governance
Slides, Worksheet, Worksheet Solutions
11:30-12:20 Khushi: Support Hrs
Gates (CSE2) 153
14:00-15:00 Lydia: Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
30
09:30-10:20 Lecture
MGH 389
Privacy and Joins
Proximity Marketing article
Slides, Video
11:30-12:20 Amal: 🎊 Extra Support Hrs 🎊
Allen (CSE1) 5th Fl. Breakout
12:30-11:20 Hannah: πŸ“ˆ Extra Support Hrs πŸ“ˆ
Allen (CSE1) 214
22:00 HW6 (Transactions and Society) due
31
June
SundayMondayTuesdayWednesdayThursdayFridaySaturday
01 02
09:30-10:20 Lecture
MGH 389
NoSQL: Document Stores
Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131
03
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
04
09:30-10:20 Lecture
MGH 389
NoSQL: Wide Column
DRAFT Slides
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
05
Section
SQL++ & NoSQL
Slides, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
06
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389
NoSQL Conclusion; Course Conclusion
07
08
22:00 HW7 (NoSQL Modeling) due
09 10 11
10:20 Final exam due
12 13 14