CSE 344 Autumn 2024
Course Calendar

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

Show color key Show color key
September
MondayTuesdayWednesdayThursdayFriday
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
Section
SQLite queries
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
2. SQL Basics (6.1-6.2)
13:30-14:20 OH (Chris)
Gates 121
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
SQL worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
5. Aggregates
13:30-14:20 OH (Chris)
Gates 121
October
MondayTuesdayWednesdayThursdayFriday
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
Azure
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
8. SQL Subqueries
13:30-14:20 OH (Chris)
Gates 121
09:30-10:20 Lecture
JHN 102
9. Relational Algebra (Recording only)
14:00-14:50 OH (Rohini)
Gates 131
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
Subqueries, Relational Algebra worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
11. ER Diagrams (2.2-2.3)
13:30-14:20 OH (Chris)
Gates 121
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
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
09:30-10:20 Midterm
13:30-14:20 OH (Chris)
Gates 121
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
BCNF, Transactions worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
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
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
Transactions worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
20. TXN Isolation Levels
13:30-14:20 OH (Chris)
Gates 121
23:00 HW5 Transactions
Veteran's Day
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
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
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!)
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
Query Execution (slides) Worksheet
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
25. Query Optimization
13:30-14:20 OH (Chris)
Gates 121
09:30-10:20 Lecture
JHN 102
26. Cardinality Estimation
14:00-14:50 OH (Rohini)
Gates 131
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Thanksgiving
Native American Heritage Day
December
MondayTuesdayWednesdayThursdayFriday
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
10:00-10:50 OH (Elvin)
Allen 5th Floor Breakout
15:00-15:50 OH (Cindy)
Gates 121
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
Section
Query Optimization, SQL++ Worksheet solutions
14:30-15:20 OH (Amal)
Allen 2nd Floor Breakout
16:00-16:50 OH (Sumeh)
Gates 151
09:30-10:20 Lecture
JHN 102
30. Review
13:30-14:20 OH (Chris)
Gates 121
23:00 HW7 SQL++ (NO LATE DAYS!)
10:30-12:20 Final Review
CSE2 G10
08:30-10:20 Final exam