CSE 344 (Spr 2023) 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
MondayTuesdayWednesdayThursdayFriday
27
09:30-10:20 Lecture
Introduction
Textbook sections 2.1-2.3
Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
28
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
29
09:30-10:20 Lecture
SQL Basics
Textbook sections 6.1-6.2
Slides; Demo; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Leanna + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
30
Section
S1: Introductions, SQLite
Slides
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
31
09:30-10:20 Lecture
SQL Joins (guest lecturer)
Same textbook sections (6.1-6.2)
Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
April
MondayTuesdayWednesdayThursdayFriday
03
09:30-10:20 Lecture
SQL Aggregates
Textbook section 6.4
Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
04
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW1 due
05
09:30-10:20 Lecture
SQL Aggregates with Joins
Same textbook sections (6.1-6.2; 6.4)
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Leanna + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
06
Section
S2: Joins, SQL Aggregates
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
07
09:30-10:20 Lecture
Data in Context; Intro to Query Patterns
Slides, Part 1; Slides, Part 2, Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
22:00 Quiz 1 due
10
09:30-10:20 Lecture
Subqueries
Textbook section 6.3
Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
11
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW2 due
12
09:30-10:20 Lecture
Subqueries (cont.); Query Patterns in Detail
Same textbook section (6.3)
Query Patterns Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Leanna + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
13
Section
S3: HW3 Setup, Subqueries
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Winston + Bianca OH
CSE01 (Allen) 3rd fl. breakout
14
09:30-10:20 Lecture
Design: Entities, Relationships, and ER Diagrams
Textbook sections 4.1-4.6
Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
17
09:30-10:20 Lecture
Design: Entities, Relationships, and ER Diagrams (cont.); Design: Design Theory and Normalization
Textbook sections 3.1-3.5
ER Slides; Design Theory Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
18
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW3 due
19
09:30-10:20 Lecture
Design: Design Theory and Normalization (cont.)
Same textbook sections (3.1-3.5)
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
20
Section
S4: Database Design
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
21
09:30-10:20 Lecture
Design: Design Theory and Normalization (cont.); Query Execution: Relational Algebra (guest lecturer)
Textbook sections 2.4; 5.1-5.2
Theory Slides; RA slides; Handout; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
22:00 Quiz 2 due
24
09:30-10:20 Lecture
Query Execution: Relational Algebra (cont.)
Same textbook sections (2.4; 5.1-5.2)
Slides; Video TBD
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
25
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW4 due
26
09:30-10:20 Lecture
Query Execution: Cardinality Estimation
Textbook sections 16.1-16.4
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
27
Section
S5: Relational Algebra
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
28
09:30-10:20 Lecture
Query Execution: Physical Considerations (guest lecturer)
Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3
Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
May
MondayTuesdayWednesdayThursdayFriday
01
09:30-10:20 Lecture
Database Applications; Password Handling
DB Apps Slides; Password Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
02
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW5 + HW 6.0 due
03
09:30-10:20 Lecture
Query Execution: Join Algorithms
Textbook sections 15.1-15.4; 15.6.1-15.6.2
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
04
Section
S6: Indexing + HW6 Flights App
Slides;
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
05
09:30-10:20 Lecture
Query Execution: Join Algorithms (cont.)
Same textbook sections (15.1-15.4; 15.6.1-15.6.2)
Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
22:00 Quiz 3 due
08
09:30-10:20 Lecture
Transactions
Textbook section 18.1-18.4
Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
09
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW6.1 due
10
09:30-10:20 Lecture
Transactions (cont.)
Same textbook sections (18.1-18.4)
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
11
Section
S7: Transactions
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
12
09:30-10:20 Lecture
Transactions (cont.)
Same textbook sections (18.1-18.4)
Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
15
09:30-10:20 Lecture
Data Governance; Parallel Processing and Partitioning
Textbook section 20.1; 20.3-20.4.2
Governance Slides; Parallel slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
16
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
12:30-13:00 Hannah OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW6.2 due
17
09:30-10:20 Lecture
Parallel Processing and Partitioning (cont.)
Same textbook sections (20.1; 20.3-20.4.2)
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
13:30-14:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
18
Section
S8: Parallel DBs
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
19
09:30-10:20 Lecture
Parallel Processing and Partitioning (cont.)
Same textbook sections (20.1; 20.3-20.4.2)
Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
22
09:30-10:20 Lecture
NoSQL: Intro; NoSQL: Key/Value Stores
Slides; Video
11:00-12:00 Hannah OH
VIRTUAL ONLY
12:30-13:20 Ethan OH
CSE01 (Allen) 5th fl. breakout
23
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
22:00 HW7 due
24
09:30-10:20 Lecture
NoSQL: Document Stores
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
25
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
26
09:30-10:20 Lecture
NoSQL: Document Stores (cont.); NoSQL: Wide Column
Google Bigtable Paper
DocStores Slides; WideCol Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
22:00 Quiz 4 due
29
Memorial Day
30
10:20-11:20 Johanna + Zage OH
CSE02 (Gates) 121
11:30-12:20 Ethan OH
CSE02 (Gates) 121
15:30-18:20 Abhishek + Eric OH
CSE01 (Allen) 5th fl. breakout
31
09:30-10:20 Lecture
NoSQL: Wide Column (cont.)
Same paper
Slides; Video
12:30-13:20 Hannah OH
CSE01 (Allen) 212
15:30-18:20 Carrie + Majid + Winston OH
CSE01 (Allen) 3rd fl. breakout
16:30-17:20 Leanna OH
VIRTUAL ONLY
01
Section
S10: Wide Column
Slides; Worksheet; Worksheet Solutions
14:30-17:20 Abhishek + Bianca OH
CSE01 (Allen) 3rd fl. breakout
22:00 HW8 due
02
09:30-10:20 Lecture
NoSQL: Wide Column (cont.); Ethical Joins
Same paper
Bigtable Slides; Joins Slides; Video
10:30-11:20 Nina OH
CSE02 (Gates) 121
12:00-13:20 Ethan OH
CSE02 (Gates) 121
June
MondayTuesdayWednesdayThursdayFriday
05 06 07
10:20 Take-home "final" due
08 09