CSE 414 Spring 2019 Course Calendar

CSE 414 Spring 2019
Course Calendar

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

March

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

31 01
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Unit 1 Intro

16:30-17:20 OH (vineeth)
GC 150
02
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
03
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Unit 2 Relational Data Model (2.1-3) Sqlite (data model)

17:00-17:50 OH (esteban)
AC 021
04
Section
Section 1 Gitlab and Sqlite

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220
05
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
SQL Basics (6.1-2) Sqlite (joins)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151
06
22:00-23:00 WQ1: Simple SQL

April

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

07 08
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Joins

16:30-17:20 OH (vineeth)
GC 150

23:00 HW1: SQLite (5 days)
09
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021

14:30-15:20 OH (josh)
GC 153
10
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Aggregates (6.3-4)

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021

22:00-23:00 WQ2: SQL Aggregates
11
Section
SQL slides worksheet solutions

11:00-12:20 OH (josh)
GC 151
12
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
SQL Subqueries (6.3)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151
13
22:00-23:00 WQ3: SQL Nested Queries

14 15
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
[RESCHEDULED ON 4/18] SQL wrap-up. Relational algebra (2.4 & 5.1)

14:30-15:20 OH (shumo)
AC breakout 2nd floor

16:30-17:20 OH (vineeth)
GC 150

23:00 HW2: SQL basics (1 wk)
16
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
17
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
More relational algebra (2.4 & 5.1)

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021

22:00-23:00 WQ4: Relational Algebra
18
Section
Azure, RA slides worksheet solutions

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220

17:30-18:20 Makeup lecture in G20
19
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
Datalog (5.3-5.4)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151
20
22:00-23:00 WQ5: Datalog

21 22
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Datalog (5.3-5.4)

16:30-17:20 OH (vineeth)
GC 150
23
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
24
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Unit 3

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021
25
Section
RA, Datalog Slides Worksheet Solution Datalog examples

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220
26
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
JSon and SQL++

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151

23:00 HW3: Advanced SQL and running SQL Azure (2 wk)
27

28 29
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
JSon and SQL++

16:30-17:20 OH (vineeth)
GC 150
30
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
01
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
JSon and SQL++

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021
02
Section
Midterm review Slides

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220
03
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Midterm

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151

23:00 HW4: Datalog and Relational Algebra(1 wk)
04

May

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

05 06
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2)

16:30-17:20 OH (vineeth)
GC 150
07
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
08
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021
09
Section
SQL++ Slides Worksheet Solutions

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220
10
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151
11

12 13
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Query Optimization wrapup

16:30-17:20 OH (vineeth)
GC 150

23:00 HW5: NoSQL (SQL++) (1 wk)
14
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
15
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Unit 5

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021
16
Section
Spark Slides Worksheet Solutions

11:00-12:20 OH (josh)
GC 151
17
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
Parallel Databases (20.1)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151
18

19 20
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Unit 6 E/R Diagrams and Constraints (4.1-4.6)

16:30-17:20 OH (vineeth)
GC 150
21
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
22
9:00-9:50 OH (shumo)
AC 220

12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Integrity Constraints (4.1-4.6)

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021
23
Section
FDs and BCNF Slides Worksheet Solutions

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220
24
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
BCNF (3.1-3.4)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151

23:00 HW6: Spark and running on AWS (2 wk)
25
22:00-23:00 WQ6: Conceptual Design

26 27
Memorial Day
28
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
29
12:30-13:20 OH (kartik)
AC 220

13:30-14:20 Lecture
CSE2 G20
Unit 7 Introduction to Transactions (18.1) Sqlite demo

14:30-15:20 OH (dan)
AC 662

17:00-17:50 OH (esteban)
AC 021
30
Section
Database Applications in Java Slides Worksheet Solutions

11:00-12:20 OH (josh)
GC 151

16:30-17:20 OH (shumo)
Room AC 220
31
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
More Transactions (18.1-3)

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151

23:00 HW7: Schema design + JDBC application (1 wk)
01

June

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

02 03
10:30-11:20 OH (ying)
GC 150

13:30-14:20 Lecture
CSE2 G20
Transaction Implementations (18.1-3)

16:30-17:20 OH (vineeth)
GC 150
04
11:00-11:50 OH (yihang)
GC 151

13:30-14:20 OH (pranay)
AC 021
05
12:30-13:20 OH (kartik)
AC 220

12:30-13:20 OH (dan)
CSE 662

13:30-14:20 Lecture
CSE2 G20
Transaction Implementations (18.1-3)

17:00-17:50 OH (esteban)
AC 021
06
Section
Transactions Slides Workshee Solutions

11:00-12:20 OH (josh)
GC 151
07
11:00-11:50 OH (yihang)
GC 150

13:30-14:20 Lecture
CSE2 G20
Final Review

15:30-16:20 OH (ruta)
GC 153

17:30-18:20 OH (pranay)
GC 151
08
14:00-15:00 Final Review; GWN 301

22:00-23:00 WQ7: Transactions

09
23:00 HW8: Transactions in the JDBC application (1.5 wk)
10
14:30-16:20 Final exam
11 12 13 14 15

March
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
31	01 10:30-11:20 OH (ying) GC 150 13:30-14:20 Lecture CSE2 G20 Unit 1 Intro 16:30-17:20 OH (vineeth) GC 150	02 11:00-11:50 OH (yihang) GC 151 13:30-14:20 OH (pranay) AC 021	03 12:30-13:20 OH (kartik) AC 220 13:30-14:20 Lecture CSE2 G20 Unit 2 Relational Data Model (2.1-3) Sqlite (data model) 17:00-17:50 OH (esteban) AC 021	04 Section Section 1 Gitlab and Sqlite 11:00-12:20 OH (josh) GC 151 16:30-17:20 OH (shumo) Room AC 220	05 11:00-11:50 OH (yihang) GC 150 13:30-14:20 Lecture CSE2 G20 SQL Basics (6.1-2) Sqlite (joins) 15:30-16:20 OH (ruta) GC 153 17:30-18:20 OH (pranay) GC 151	06 22:00-23:00 WQ1: Simple SQL

April
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
07	08 10:30-11:20 OH (ying) GC 150 13:30-14:20 Lecture CSE2 G20 Joins 16:30-17:20 OH (vineeth) GC 150 23:00 HW1: SQLite (5 days)	09 11:00-11:50 OH (yihang) GC 151 13:30-14:20 OH (pranay) AC 021 14:30-15:20 OH (josh) GC 153	10 12:30-13:20 OH (kartik) AC 220 13:30-14:20 Lecture CSE2 G20 Aggregates (6.3-4) 14:30-15:20 OH (dan) AC 662 17:00-17:50 OH (esteban) AC 021 22:00-23:00 WQ2: SQL Aggregates	11 Section SQL slides worksheet solutions 11:00-12:20 OH (josh) GC 151	12 11:00-11:50 OH (yihang) GC 150 13:30-14:20 Lecture CSE2 G20 SQL Subqueries (6.3) 15:30-16:20 OH (ruta) GC 153 17:30-18:20 OH (pranay) GC 151	13 22:00-23:00 WQ3: SQL Nested Queries
14	15 10:30-11:20 OH (ying) GC 150 13:30-14:20 Lecture CSE2 G20 [RESCHEDULED ON 4/18] SQL wrap-up. Relational algebra (2.4 & 5.1) 14:30-15:20 OH (shumo) AC breakout 2nd floor 16:30-17:20 OH (vineeth) GC 150 23:00 HW2: SQL basics (1 wk)	16 11:00-11:50 OH (yihang) GC 151 13:30-14:20 OH (pranay) AC 021	17 12:30-13:20 OH (kartik) AC 220 13:30-14:20 Lecture CSE2 G20 More relational algebra (2.4 & 5.1) 14:30-15:20 OH (dan) AC 662 17:00-17:50 OH (esteban) AC 021 22:00-23:00 WQ4: Relational Algebra	18 Section Azure, RA slides worksheet solutions 11:00-12:20 OH (josh) GC 151 16:30-17:20 OH (shumo) Room AC 220 17:30-18:20 Makeup lecture in G20	19 11:00-11:50 OH (yihang) GC 150 13:30-14:20 Lecture CSE2 G20 Datalog (5.3-5.4) 15:30-16:20 OH (ruta) GC 153 17:30-18:20 OH (pranay) GC 151	20 22:00-23:00 WQ5: Datalog
21	22 10:30-11:20 OH (ying) GC 150 13:30-14:20 Lecture CSE2 G20 Datalog (5.3-5.4) 16:30-17:20 OH (vineeth) GC 150	23 11:00-11:50 OH (yihang) GC 151 13:30-14:20 OH (pranay) AC 021	24 12:30-13:20 OH (kartik) AC 220 13:30-14:20 Lecture CSE2 G20 Unit 3 14:30-15:20 OH (dan) AC 662 17:00-17:50 OH (esteban) AC 021	25 Section RA, Datalog Slides Worksheet Solution Datalog examples 11:00-12:20 OH (josh) GC 151 16:30-17:20 OH (shumo) Room AC 220	26 11:00-11:50 OH (yihang) GC 150 13:30-14:20 Lecture CSE2 G20 JSon and SQL++ 15:30-16:20 OH (ruta) GC 153 17:30-18:20 OH (pranay) GC 151 23:00 HW3: Advanced SQL and running SQL Azure (2 wk)	27
28	29 10:30-11:20 OH (ying) GC 150 13:30-14:20 Lecture CSE2 G20 JSon and SQL++ 16:30-17:20 OH (vineeth) GC 150	30 11:00-11:50 OH (yihang) GC 151 13:30-14:20 OH (pranay) AC 021	01 12:30-13:20 OH (kartik) AC 220 13:30-14:20 Lecture CSE2 G20 JSon and SQL++ 14:30-15:20 OH (dan) AC 662 17:00-17:50 OH (esteban) AC 021	02 Section Midterm review Slides 11:00-12:20 OH (josh) GC 151 16:30-17:20 OH (shumo) Room AC 220	03 11:00-11:50 OH (yihang) GC 150 13:30-14:20 Midterm 15:30-16:20 OH (ruta) GC 153 17:30-18:20 OH (pranay) GC 151 23:00 HW4: Datalog and Relational Algebra(1 wk)	04

June
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
02	03 10:30-11:20 OH (ying) GC 150 13:30-14:20 Lecture CSE2 G20 Transaction Implementations (18.1-3) 16:30-17:20 OH (vineeth) GC 150	04 11:00-11:50 OH (yihang) GC 151 13:30-14:20 OH (pranay) AC 021	05 12:30-13:20 OH (kartik) AC 220 12:30-13:20 OH (dan) CSE 662 13:30-14:20 Lecture CSE2 G20 Transaction Implementations (18.1-3) 17:00-17:50 OH (esteban) AC 021	06 Section Transactions Slides Workshee Solutions 11:00-12:20 OH (josh) GC 151	07 11:00-11:50 OH (yihang) GC 150 13:30-14:20 Lecture CSE2 G20 Final Review 15:30-16:20 OH (ruta) GC 153 17:30-18:20 OH (pranay) GC 151	08 14:00-15:00 Final Review; GWN 301 22:00-23:00 WQ7: Transactions
09 23:00 HW8: Transactions in the JDBC application (1.5 wk)	10 14:30-16:20 Final exam	11	12	13	14	15