Lecture

Section

Lab

Exam

Homework

Office Hour

Other

Holiday

Subscribe to this calendar

Use your CSE accounts to access homework assignments

January
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
01	02	03 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	04 WQ 1 (Basic SQL) out HW1 (SQL Basics) out 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 Introduction 16:30-17:30 OH (Amarpal) CSE 006	05 Section Introduction to SQLite instructions class.csv instructor.csv teaches.csv 11:30-12:30 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Data Models (2.1-2.3) Example queries	06 11:20-12:20 OH (Clara) CSE 006	07
08	09 10:30-11:30 OH (Kelly) CSE 006 15:30-16:20 Lecture KNE 210 SQL Basics (6.1-6.2) Example queries	10 WQ 1 (Basic SQL) due WQ 2 (Basic SQL and aggregates) out 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	11 HW1 (SQL Basics) due HW2 (SQL Queries) out 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 SQL Joins and Aggregates (6.3-6.4) 16:30-17:30 OH (Amarpal) CSE 006	12 Section SQL Basics population.csv instructor.csv gdb.csv class.csv airport.csv teaches.csv createAndImportTables.sql problems solutions 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Grouping and Query Evaluation (6.3-6.4)	13 13:30-14:30 OH (Clara) CSE 006	14
15	16 Martin Luther King Day	17 WQ 2 (Basic SQL and aggregates) due WQ 3 (Nested Queries) out 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	18 HW2 (SQL Queries) due HW3 (Advanced SQL and Physical Tuning) out 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 SQL Subqueries (6.3) 16:30-17:30 OH (Amarpal) CSE 006	19 Section Nested queries problems solutions drinking.sql 11:30-12:30 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 SQL Wrapup and relational algebra (no reading)	20 13:30-14:30 OH (Clara) CSE 006	21
22	23 10:30-11:30 OH (Kelly) CSE 006 15:30-16:20 Lecture KNE 210 Relational Algebra (2.4, 5.1)	24 WQ 3 (Nested Queries) due 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	25 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 Relational Algebra and Query Evaluation (5.2) 16:30-17:30 OH (Amarpal) CSE 006	26 Section Relational algebra problems solutions 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Data Storage and Indexing (14.1)	27 13:30-14:30 OH (Clara) CSE 006	28
29	30 10:30-12:30 OH (Kelly) CSE 006 15:30-16:20 Lecture KNE 210 Query Optimization and Cost Estimation (15.1-3, 15.6)	31 WQ 4 (RA, RC, Datalog) out 11:00-12:00 OH (Nick) CSE 006 13:30-15:30 OH (Jonathan) CSE 006	01 HW3 (Advanced SQL and Physical Tuning) due HW4 (Relational algebra, datalog, relational calculus) out 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 More Cost Estimation (16.3-5) additional reference: Ch 14 from Ramakrishnan and Gehrke (optional, available in library) 16:30-17:30 OH (Amarpal) CSE 006	02 Section More cost estimation and relational calculus problems solutions 11:30-12:30 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Relational calculus (query language primer) more reference 1 (optional) more reference 2 (optional)	03 13:30-14:30 OH (Clara) CSE 006	04

February
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
05	06 10:30-11:30 OH (Kelly) CSE 006	07 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	08 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 Datalog (5.3-5.4, query language primer) 16:30-17:30 OH (Amarpal) CSE 006	09 Section More relational calculus and datalog problems solutions 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 NoSQL (skim 11.1-3, 12.1)	10 13:30-14:30 OH (Clara) CSE 006	11
12 WQ 4 (RA, RC, Datalog) due HW4 (Relational algebra, datalog, relational calculus) due	13 10:30-11:30 OH (Kelly) CSE 006 15:30-16:20 Midterm Exam	14 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	15 HW6 (E/R and Conceptual Design) out WQ 6 (E/R and Design Theory) out 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 E/R Diagrams and Constraints (4.1-4.6) 16:30-17:30 OH (Amarpal) CSE 006	16 Section ER Diagrams additional slides problem solution 11:30-12:30 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Design Theory (3.1-3.4)	17 13:30-14:30 OH (Clara) CSE 006	18
19	20 Presidents Day	21 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	22 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 BCNF (3.5-3.7) 16:30-17:30 OH (Amarpal) CSE 006	23 Section BCNF 11:30-12:30 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Introduction to Transactions (18.1)	24 13:30-14:30 OH (Clara) CSE 006	25
26	27 HW6 (E/R and Conceptual Design) due HW7 (Transactions) out WQ 6 (E/R and Design Theory) due WQ 7 (Transactions) out 10:30-11:30 OH (Kelly) CSE 006 15:30-16:20 Lecture KNE 210 More Transactions (18.1-3)	28 11:00-12:00 OH (Nick) CSE 006 13:30-14:30 OH (Jonathan) CSE 006	01 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 Transaction Implementations (18.1-3) 16:30-17:30 OH (Amarpal) CSE 006	02 Section Transactions worksheet solutions 11:00-12:00 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 More Transaction Implementations (6.6, 18.4-6)	03 13:30-14:30 OH (Clara) CSE 006	04

March
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
05	06 WQ 7 (Transactions) due 10:30-11:30 OH (Kelly) CSE 006 15:30-16:20 Lecture KNE 210 Parallel Databases (20.1)	07 13:30-14:30 OH (Jonathan) CSE 006	08 HW7 (Transactions) due 13:30-14:30 OH (Cindy) CSE 006 15:30-16:20 Lecture KNE 210 MapReduce (20.2) Original research paper (optional) Comparison with parallel DBs (optional) Mining of Massive Datasets (Ch 2.1-2.3) (optional) 16:30-17:30 OH (Amarpal) CSE 006	09 Section Parallel databases and MapReduce worksheet solutions 11:30-12:30 OH (Alvin) CSE 530 13:30-14:30 OH (Lisa) CSE 006 15:30-16:20 Lecture KNE 210 Spark (no reading)	10 13:30-14:30 OH (Clara) CSE 006	11
12	13	14	15	16 14:30-16:20 Final Exam	17	18