CSE 344 (Aut 2023) Course Calendar

CSE 344 (Aut 2023) Course Calendar

See Canvas for the full list of lecture and section recordings
Subscribe to this calendar (Google, iCal, etc.)

Show color key

September
Monday	Tuesday	Wednesday	Thursday	Friday
25	26	27 10:30-11:20 Lecture Introduction Textbook sections 2.1-2.3 Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	28 Section Slides 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout	29 10:30-11:20 Lecture SQL Basics Textbook sections 6.1-6.2 Slides, Demo, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214

October
Monday	Tuesday	Wednesday	Thursday	Friday
02 10:30-11:20 Lecture SQL Joins Same textbook sections (6.1-6.2) Slides, Demo; Video 11:30-12:20 Nina OH VIRTUAL ONLY 1	03 9:30-10:20 Aditi + Chris OH CSE2 (Gates) 150 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout 22:00 HW1 (Intro to SQL and SQLite) due	04 10:30-11:20 Lecture SQL Aggregates Textbook section 6.4 Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	05 Section Slides, Extra slides, Worksheet, Worksheet Solutions 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout	06 10:30-11:20 Lecture SQL Aggregates with SQL Joins Same textbook sections (6.1-6.2; 6.4) Slides, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214
09 10:30-11:20 Lecture Data in Context; Intro to SQL Query Patterns Context Slides, Query pattern slides; Video 11:30-12:20 Nina OH VIRTUAL ONLY 2	10 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout 22:00 HW2 (Basic SQL Queries) due	11 10:30-11:20 Lecture SQL Subqueries Textbook section 6.3 Slides, LAST QUARTERS Video (Panopto issues today) 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	12 Section Slides, Worksheet, Worksheet Solutions 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout	13 10:30-11:20 Lecture SQL Subqueries (cont.); SQL Query Patterns in Detail Same textbook section (6.3) Query Patterns, LAST QUARTERS Video (Panopto issues; ticket has been filed with UW IT) 11:30-12:20 Hannah OH CSE1 (Allen) 214 22:00 Quiz 1 due
16 10:30-11:20 Lecture Design: Entities, Relationships, and ER Diagrams Textbook sections 4.1-4.6 Slides, LAST QUARTERS Video 11:30-12:20 Nina OH VIRTUAL ONLY 3	17 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout 22:00 HW3 (Advanced SQL Queries and Azure) due; Setup Guide	18 10:30-11:20 Lecture Design: Entities, Relationships, and ER Diagrams (cont.); Design: Design Theory and Normalization Textbook sections 3.1-3.5 ER Slides, Normalization Slides; Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	19 Section Slides, Worksheet, Worksheet Solutions 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout	20 10:30-11:20 Lecture Design: Design Theory and Normalization (cont.) Same textbook sections (3.1-3.5) Slides, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214
23 10:30-11:20 Lecture Query Execution: Relational Algebra Textbook sections 2.4; 5.1-5.2 Slides, Video 11:30-12:20 Nina OH VIRTUAL ONLY	24 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout 22:00 HW4 (Design Theory) due	25 10:30-11:20 Lecture Query Execution: Relational Algebra (cont.) Same textbook sections (2.4; 5.1-5.2) Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	26 Section Slides, Worksheet, Worksheet Solutions 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout	27 10:30-11:20 Lecture Query Execution: Cardinality Estimation Textbook sections 16.1-16.4 Slides, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214 22:00 Quiz 2 due
30 10:30-11:20 Lecture Design: Physical Design and Indexes Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3 Slides, Video 11:30-12:20 Nina OH VIRTUAL ONLY	31 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout 22:00 HW5 (Query Execution and Society) due	01 10:30-11:20 Lecture Database Applications; Password Handling DB Apps Slides, Password Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	02 Section Slides 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout 22:00 Project (Flights Application) Milestone 0 due	03 10:30-11:20 Lecture Query Execution: Join Algorithms Textbook sections 15.1-15.4; 15.6.1-15.6.2 Slides, Handout, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214

November
Monday	Tuesday	Wednesday	Thursday	Friday
06 10:30-11:20 Lecture Query Execution: Join Algorithms (cont.) Same textbook sections (15.1-15.4; 15.6.1-15.6.2) Slides, Handout, Video 11:30-12:20 Nina OH VIRTUAL ONLY	07 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 11:00-12:00 Chris bonus OH CSE1 (Allen) 5th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout	08 10:30-11:20 Lecture Transactions Textbook section 18.1-18.4 Slides, Demo script, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:30 Amal + Yuna + Rich OH CSE1 (Allen) 3rd Fl Breakout 17:30-18:30 Amal + Rich bonus OH CSE2 150	09 Section Slides 13:30-15:20 Carrie OH CSE2 (Gates) 131 15:30-18:30 Amal bonus OH CSE1 (Allen) 4th Fl Breakout 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout 22:00 Project (Flights Application) Milestone 1 due	10 Veteran's Day
13 10:30-11:20 Lecture Transactions (cont.) Same textbook sections (18.1-18.4) Slides, Video 11:30-12:20 Nina OH VIRTUAL ONLY 16:30-18:00 Rich bonus OH CSE1 (Allen) 4th Fl Breakout	14 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE2 (Gates) 131	15 10:30-11:20 Lecture Transactions (cont.) Same textbook sections (18.1-18.4) Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout 17:30-18:20 Rich + Amal bonus OH CSE2 (Gates) 150	16 Section Slides, Worksheet, Worksheet Solutions 13:30-15:20 Carrie OH CSE2 (Gates) 131 15:30-18:00 Rich + Amal bonus OH CSE1 (Allen) 4th Fl Breakout	17 10:30-11:20 Lecture Transactions (cont.); Data Governance Same textbook sections (18.1-18.4); NYT Taxicab Post Txn Slides, Governance Slides, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214 17:00-19:00 Amal bonus OH CSE1 (Allen) 3rd Fl Breakout 22:00 Quiz 3 due
20 10:30-11:20 Lecture Parallel Processing and Partitioning 20.1; 20.3-20.4.2 Slides, Video 11:30-12:20 Nina OH VIRTUAL ONLY 22:00 Project (Flights Application) Milestone 2 due	21 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout	22 10:30-11:20 Lecture Parallel Processing and Partitioning (cont.); NoSQL: Intro Same textbook sections (20.1; 20.3-20.4.2) Parallel Slides, NoSQL Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	23 Thanksgiving	24 Native American Heritage Day
27 10:30-11:20 Lecture Privacy and Joins; NoSQL: Key/Value Stores NoSQL Slides, Privacy Slides, Video 11:30-12:20 Nina OH VIRTUAL ONLY	28 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout	29 10:30-11:20 Lecture NoSQL: Document Stores Slides, Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	30 Section Slides, Worksheet, Worksheet Solutions 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout 22:00 HW6 (Transactions) due	01 10:30-11:20 Lecture NoSQL: Document Stores (cont.); NoSQL: Wide Column DocStore Slides, WideCol Slides, Video 11:30-12:20 Hannah OH CSE1 (Allen) 214

December
Monday	Tuesday	Wednesday	Thursday	Friday
04 10:30-11:20 Lecture NoSQL: Wide Column (cont.) Slides, Video 11:30-12:20 Nina OH VIRTUAL ONLY	05 9:30-10:20 Aditi + Chris OH CSE1 (Allen) 4th Fl Breakout 15:30-16:20 Caleb + Zage OH CSE1 (Allen) 3rd Fl Breakout	06 10:30-11:20 Lecture NoSQL Conclusion; Data Integrity WideCol Slides, Conclusion Slides Video 11:00-12:00 Ivan Virtual OH VIRTUAL ONLY 12:00-13:00 Hannah Virtual OH VIRTUAL ONLY 15:30-16:20 Majid OH CSE1 (Allen) 3rd Fl Breakout 16:30-17:20 Amal + Yuna OH CSE1 (Allen) 3rd Fl Breakout	07 Section TBD 13:30-15:20 Carrie OH CSE2 (Gates) 131 16:30-17:20 Amal OH CSE1 (Allen) 4th Fl Breakout 22:00 HW7 (NoSQL Modeling) due	08 10:30-11:20 Lecture Conclusion Slides, Video; Supplemental streaming slides and videos (first, second) 11:30-12:20 Hannah OH CSE1 (Allen) 214 22:00 ~~Quiz 4 due~~ CANCELLED!
11 10:20 Final "exam" due	12	13	14	15