CSE 344 Autumn 2018
Course Calendar

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

 Show color key

September
SundayMondayTuesdayWednesdayThursdayFridaySaturday
23 24 25 26
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
Unit 1Intro
15:30-16:20 OH (ds)
CSE 662
27
Section
Git setup, Sqlite Slides
14:30-15:20 OH (dh)
CSE 021
28
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
Unit 2 Relational Data Model (2.1-3)
29
30 01
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
SQL Basics (6.1-2) demo in sqlite
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
02
23:00 HW1: SQLite (1 wk)
03
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
Aggregates (6.3-4)
15:30-16:00 OH (ds)
CSE 662
04
Section
A SeQueL to SQL Worksheet
14:30-15:20 OH (dh)
CSE 021
05
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
Aggregates (6.3-4)
22:00-23:00 WQ1: Simple SQL
06

October
SundayMondayTuesdayWednesdayThursdayFridaySaturday
07 08
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
SQL Subqueries (6.3)
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
09
23:00 HW2: SQL basics (1 wk)
10
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
SQL wrap-up, Relational algebra (2.4 & 5.1)
11
Section
Azure, Grouping, and Nesting Worksheet
14:30-15:20 OH (dh)
CSE 021
12
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
More relational algebra (2.4 & 5.1)
22:00-23:00 WQ2: SQL Aggregates
13
14 15
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
Datalog (5.3-5.4)
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
16
22:00-23:00 WQ3: SQL Nested Queries
17
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
Datalog (5.3-5.4)
15:30-16:20 OH (ds)
CSE 662
18
Section
Relational algebra and Datalog Worksheet
14:30-15:20 OH (dh)
CSE 021
19
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
Unit 3 NoSQL, JSON, SQL++
23:00 HW3: Advanced SQL and running SQL Azure (1 2/3 wk)
20
21 22
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
JSon and SQL++ (guest lecturer)
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
23
22:00-23:00 WQ4: Relational Algebra
24
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
JSon and SQL++ (guest lecturer)
25
Section
Datalog Worksheet, Solutions
14:30-15:20 OH (dh)
CSE 021
26
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
JSon and SQL++ (guest lecturer)
27
28
14:00-17:00 Midterm review: GWN 201
29
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2)
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
30
22:00-23:00 WQ5: Datalog
23:00 HW4: Datalog and Relational Algebra(1 1/3 wk)
31
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Midterm
15:30-16:20 OH (ds)
CSE 662
01
Section
SQL++ Worksheet
14:30-15:20 OH (dh)
CSE 021
02
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)
03

November
SundayMondayTuesdayWednesdayThursdayFridaySaturday
04 05
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
06
23:00 HW5: NoSQL (SQL++) (1 wk)
07
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
Finish Unit 4
15:30-16:20 OH (ds)
CSE 662
08
Section
Query execution, indexes Worksheet
14:30-15:20 OH (dh)
CSE 021
09
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
Unit 5 Parallel Databases (20.1) Introduction to Spark (no reading)
10
11 12
Veteran's Day*
13 14
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
More Spark
15:30-16:20 OH (ds)
CSE 662
15
Section
Cost of Query Plans, Spark Worksheet
14:30-15:20 OH (dh)
CSE 021
16
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2)
17
18 19
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
MapReduce
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
20
23:00 HW6: Spark and running on AWS (2 wk)
21
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
Unit 6 E/R Diagrams and Constraints (4.1-4.6)
15:30-16:20 OH (ds)
CSE 662
22
Thanksgiving
23
Fri. after Thanksgiving
24
25 26
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
Integrity Constraints
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
27
17:30-18:20 Makeup Lecture (Room EEB 105): BCNF (3.1-3.4)
28
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
Unit 7 Introduction to Transactions (18.1) Sqlite demo
15:30-16:20 OH (ds)
CSE 662
29
Section
Design Theory and BCNF Worksheet
14:30-15:20 OH (dh)
CSE 021
30
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
More Transactions (18.1-3)
22:00-23:00 WQ6: Conceptual Design
23:00 HW7: Schema design + index tuning + cost estimation (1.5 wk)
01

December
SundayMondayTuesdayWednesdayThursdayFridaySaturday
02 03
12:30-13:30 OH (jl)
CSE 021
13:30-14:20 Lecture
AND 223
Transaction Implementations (18.1-3)
16:00-16:50 OH (sh)
Breakout 3rd floor
17:00-17:50 OH (jk)
Breakout 3rd floor
04
17:30-18:20 Makeup Lecture (Room EEB 105): Transactions Wrapup
05
10:30-11:20 OH (yw)
CSE 021
13:30-14:20 Lecture
AND 223
CLASS CANCELED
06
Section
Transactions
14:30-15:20 OH (dh)
CSE 021
22:00-23:00 WQ7: Transactions
07
10:30-11:20 OH (tw)
CSE 007
13:30-14:20 Lecture
AND 223
CLASS CANCELED
08
09
14:00-16:00 Final review: EEB 125
23:00 HW8: JDBC application (1.5 wk)
10
14:30-16:20 Final exam
11 12 13 14 15