CSE 344 Autumn 2024
Course Calendar

Subscribe to this calendar (Google, iCal, etc.)

Show color key Show color key
September
MondayTuesdayWednesdayThursdayFriday
23 24 25
09:30-10:20 Lecture
JHN 102
1. Introduction (2.1-3)
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
26
Section
SQLite queries
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
27
09:30-10:20 Lecture
JHN 102
2. SQL Basics (6.1-6.2)
13:30-14:20 OH (Chris)
Gates 121
30
09:30-10:20 Lecture
JHN 102
3. SQL Joins (6.1-6.2)
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
01
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
02
09:30-10:20 Lecture
JHN 102
4. SQL NULLs, Aggregates
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
23:00 HW1 Sqlite 1
03
Section
SQL worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
04
09:30-10:20 Lecture
JHN 102
5. Aggregates
13:30-14:20 OH (Chris)
Gates 121
October
MondayTuesdayWednesdayThursdayFriday
07
09:30-10:20 Lecture
JHN 102
6. SQL Review (so far)
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
08
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
09
09:30-10:20 Lecture
JHN 102
7. SQL Subqueries
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
23:00 HW2 Sqlite 2
10
Section
Azure
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
11
09:30-10:20 Lecture
JHN 102
8. SQL Subqueries
13:30-14:20 OH (Chris)
Gates 121
14
09:30-10:20 Lecture
JHN 102
9. Relational Algebra (Recording only)
14:00-14:50 OH (Rohini)
Gates 131
15
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
16
09:30-10:20 Lecture
JHN 102
10. ER Diagrams (2.1) (Recording only)
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
17
Section
Subqueries, Relational Algebra worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
18
09:30-10:20 Lecture
JHN 102
11. ER Diagrams (2.2-2.3)
13:30-14:20 OH (Chris)
Gates 121
21
09:30-10:20 Lecture
JHN 102
12. Functional Dependencies (2.2-2.3)
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
22
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
23
09:30-10:20 Lecture
JHN 102
13. BCNF (3.4-3.6)
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
23:00 HW3 SQL Azure, Setup instructions
24
Section
ER Diagrams, FDs Midterm review worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
25
09:30-10:20 Midterm
13:30-14:20 OH (Chris)
Gates 121
28
09:30-10:20 Lecture
JHN 102
15. TXN Basics (18.1-18.2) demo
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
29
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
30
09:30-10:20 Lecture
JHN 102
16. TXN Serializability (18.1-18.2)
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
31
Section
BCNF, Transactions worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
01
09:30-10:20 Lecture
JHN 102
17. TXN Locks
13:30-14:20 OH (Chris)
Gates 121
23:00 HW4 Database Design
November
MondayTuesdayWednesdayThursdayFriday
04
09:30-10:20 Lecture
JHN 102
18. TXN Isolation Levels
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
05
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
06
09:30-10:20 Lecture
JHN 102
19. Application Programming
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
07
Section
Transactions worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
08
09:30-10:20 Lecture
JHN 102
20. TXN Isolation Levels
13:30-14:20 OH (Chris)
Gates 121
23:00 HW5 Transactions
11
Veteran's Day
12
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
13
09:30-10:20 Lecture
JHN 102
21. Query Execution
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
14
Section
HW6 OH demo 1 demo 2
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
15
09:30-10:20 Lecture
JHN 102
22. Storing Data on Disk
13:30-14:20 OH (Chris)
Gates 121
23:00 HW6a Flight Application 1 (NO LATE DAYS!)
18
09:30-10:20 Lecture
JHN 102
23. Indexes
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
19
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
20
09:30-10:20 Lecture
JHN 102
24. External Memory Algorithms
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
21
Section
Query Execution (slides) Worksheet
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
22
09:30-10:20 Lecture
JHN 102
25. Query Optimization
13:30-14:20 OH (Chris)
Gates 121
25
09:30-10:20 Lecture
JHN 102
26. Cardinality Estimation
14:00-14:50 OH (Rohini)
Gates 131
26
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
27
09:30-10:20 Lecture
JHN 102
27. Semistructured Data
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
23:00 HW6b Flight Application 2
28
Thanksgiving
29
Native American Heritage Day
December
MondayTuesdayWednesdayThursdayFriday
02
09:30-10:20 Lecture
JHN 102
28. SQL++ Demo
10:30-11:20 OH (Dan)
CSE 662
14:00-14:50 OH (Rohini)
Gates 131
03
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
04
09:30-10:20 Lecture
JHN 102
29. SQL++ Demo
10:30-11:20 OH (Jay)
Allen 4h Floor Breakout
13:30-14:20 OH (Sai)
Gates 150
05
Section
Query Optimization, SQL++ Worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
06
09:30-10:20 Lecture
JHN 102
30. Review
13:30-14:20 OH (Chris)
Gates 121
23:00 HW7 SQL++ (NO LATE DAYS!)
09
10:30-12:20 Final Review
CSE2 G10
10 11
08:30-10:20 Final exam
12 13