CSE 344 Autumn 2017
Course Calendar

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

 Show color key

September
MondayTuesdayWednesdayThursdayFriday
25 26 27
13:30-14:20 Lecture
EEB 125
Unit 1Intro
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
28
Section
Git setup, Sqlite Slides
12:00-13:00 OH (jl)
CSE 021
29
13:30-14:20 Lecture
EEB 125
Unit 2 Relational Data Model (2.1-3)
14:30-15:20 OH (jh)
CSE 3rd floor breakout

October
MondayTuesdayWednesdayThursdayFriday
02
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
SQL Basics (6.1-2) demo in sqllite
03
12:00-13:00 OH (pl)
CSE 021
23:00 HW1: SQLite (1 wk)
04
13:30-14:20 Lecture
EEB 125
Aggregates (6.3-4)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
05
Section
A SeQueL to SQL Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
06
13:30-14:20 Lecture
EEB 125
Aggregates (6.3-4)
14:30-15:20 OH (jh)
CSE 3rd floor breakout
22:00-23:00 WQ1: Simple SQL
09
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
SQL Subqueries (6.3)
10
12:00-13:00 OH (pl)
CSE 021
23:00 HW2: SQL basics (1 wk)
11
13:30-14:20 Lecture
EEB 125
SQL wrap-up, Relational algebra (2.4 & 5.1)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
12
Section
Azure, Grouping, and Nesting Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
13
13:30-14:20 Lecture
EEB 125
More relational algebra (2.4 & 5.1)
14:30-15:20 OH (jh)
CSE 3rd floor breakout
22:00-23:00 WQ2: SQL Aggregates
16
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
Datalog (5.3-5.4)
17
20:00-21:00 OH (pl)
Basement labs (002)
22:00-23:00 WQ3: SQL Nested Queries
18
13:30-14:20 Lecture
EEB 125
Datalog (5.3-5.4)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
19
Section
Relational algebra and Datalog Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
20
13:30-14:20 Lecture
EEB 125
Unit 3 NoSQL, JSON, SQL++
14:30-15:20 OH (jh)
CSE 3rd floor breakout
23:00 HW3: Advanced SQL and running SQL Azure (1 2/3 wk)
23
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
JSon and SQL++)
24
12:00-13:00 OH (pl)
CSE 021
22:00-23:00 WQ4: Relational Algebra
25
13:30-14:20 Lecture
EEB 125
SQL++
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
26
Section
SQL++ Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
27
13:30-14:20 Lecture
EEB 125
Unit 4 From RA to Query Evaluation (5.2 & 16.3, skimming 16.3.2)
14:30-15:20 OH (jh)
CSE 3rd floor breakout
17:30-18:20 Midterm review: SMI 205
22:00-23:00 WQ5: Datalog
30
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)
31
12:00-13:00 OH (pl)
CSE 021
23:00 HW4: Datalog and Relational Algebra(1 1/3 wk)
01
13:30-14:20 Midterm
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
02
09:30-10:20 OH (ac)
Basement labs (002)
10:30-11:20 OH (rv/jh)
Basement labs (002)
11:30-12:20 OH (rv/jh)
Basement labs (002)
12:00-13:00 OH (jl)
CSE 021
12:30-13:20 OH (ml)
Basement labs (002)
03
13:30-14:20 Lecture
EEB 125
Storage & Indexing cont.

November
MondayTuesdayWednesdayThursdayFriday
06
10:30-11:30 OH (ml)
CSE 007
13:30-14:20 Lecture
EEB 125
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
07
12:00-13:00 OH (pl)
CSE 021
15:30-16:20 OH (ac)
Basement labs (002)
23:00 HW5: NoSQL (SQL++) (1 wk)
08
13:30-14:20 Lecture
EEB 125
Unit 5 Parallel Databases (20.1) From RA to Query Evaluation (5.2 & 16.3, skimming 16.3.2)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
09
Section
Query execution, indexes Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
10
Veterans Day
13
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
More Parallel Databases
14
12:00-13:00 OH (pl)
CSE 021
15
13:30-14:20 Lecture
EEB 125
Introduction to Spark (no reading)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
16
Section
Cost of Query Plans, Spark Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
17
13:30-14:20 Lecture
EEB 125
More Spark (no reading)
14:30-15:20 OH (jh)
CSE 3rd floor breakout
20
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
Unit 6 E/R Diagrams and Constraints (4.1-4.6)
14:30-15:20 OH (ml)
CSE 220
21
12:00-13:00 OH (pl)
CSE 021
23:00 HW6: Spark and running on AWS (2 wk)
22
13:30-14:20 Lecture
EEB 125
Design Theory (3.1-3.4)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
23
Thanksgiving Day
24
Day after Thanksgiving
27
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
BCNF (3.1-3.4)
28
12:00-13:00 OH (pl)
CSE 021
23:00 HW7: Schema design + index tuning + cost estimation (1 wk)
29
13:30-14:20 Lecture
EEB 125
Unit 5 Introduction to Transactions (18.1)
14:30-15:20 OH (ds)
CSE 662
16:30-17:30 OH (rv)
CSE 021
30
Section
Functional Dependencies Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
01
13:30-14:20 Lecture
EEB 125
More Transactions (18.1-3)
14:30-15:20 OH (jh)
CSE 3rd floor breakout
22:00-23:00 WQ6: Conceptual Design

December
MondayTuesdayWednesdayThursdayFriday
04
10:30-11:30 OH (ml)
CSE 007
12:00-13:00 OH (ac)
CSE 021
13:30-14:20 Lecture
EEB 125
Transaction Implementations (18.1-3)
05
12:00-13:00 OH (pl)
CSE 021
06
13:30-14:20 Lecture
EEB 125
Transactions Wrapup demo in sqllite
16:30-17:30 OH (rv)
CSE 021
07
Section
Transactions Slides, Worksheet, Solutions
12:00-13:00 OH (jl)
CSE 021
22:00-23:00 WQ7: Transactions
08
13:30-14:20 Lecture
EEB 125
Final Review
14:30-15:20 OH (jh)
CSE 3rd floor breakout
11
14:30-16:20 Final exam
12 13
23:00 HW8: JDBC application (2 wk)
14 15