CSE 344 Winter 2019
Course Calendar

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

 Show color key

January
SundayMondayTuesdayWednesdayThursdayFridaySaturday
06 07
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
Unit 1 Intro
08
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
09
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
Unit 2 Relational Data Model (2.1-3) Sqlite (data model)
10
Section
Git setup, Sqlite; slides Sqlite demo notes
16:30-17:20 Makeup Lecture (Room: BAG 131): SQL Basics (6.1-2)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
11
13:30-14:20 Lecture
SIG 134
Joins (continued), Aggregates (6.3-4) Sqlite (joins) Sqlite (aggregates)
15:30-16:20 OH (Shana)
Gates 152
12
22:00-23:00 WQ1: Simple SQL
13 14
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
CANCELED (makeup: 1/10, 4:30pm, BAG 131)
15
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
23:00 HW1: SQLite (1 wk)
16
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
CANCELED (makeup: 1/22, 5:30pm, BAG 131)
17
Section
SQL slides worksheet solution
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
18
13:30-14:20 Lecture
SIG 134
Aggregates (6.3-4)
19
22:00-23:00 WQ2: SQL Aggregates
20 21
MLK Day
22
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
17:30-18:20 Makeup Lecture (Room BAG 131): SQL Subqueries (6.3)
23:00 HW2: SQL basics (1 wk)
23
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
SQL wrap-up. Relational algebra (2.4 & 5.1)
15:30-16:20 OH (Dan)
Allen 662
22:00-23:00 WQ3: SQL Nested Queries
24
Section
More SQL slides worksheet solutions
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
25
13:30-14:20 Lecture
SIG 134
More relational algebra (2.4 & 5.1)
26
22:00-23:00 WQ4: Relational Algebra
27 28
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
Datalog (5.3-5.4)
29
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
30
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
Datalog (5.3-5.4)
15:30-16:20 OH (Dan)
Allen 662
31
Section
Relational Algebra and Datalog slides worksheet solutions
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
01
13:30-14:20 Lecture
SIG 134
Unit 3
22:00-23:00 WQ5: Datalog
23:00 HW3: Advanced SQL and running SQL Azure (1 2/3 wk)
02

February
SundayMondayTuesdayWednesdayThursdayFridaySaturday
03 04
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
CANCELED (Snow day)
05
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
06
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
JSon and SQL++
15:30-16:20 OH (Dan)
Allen 662
07
Section
JSON/SQL++ and Midterm review slides Midterm general practice Additional midterm datalog practice Midterm general practice solutions Additional midterm datalog practice solutions
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
08
13:30-14:20 Lecture
SIG 134
CANCELED (Snow day)
23:00 HW4: Datalog and Relational Algebra(1 wk)
09
10 11
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
CANCELED (Snow day)
12
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
13
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
JSon and SQL++
15:30-16:20 OH (Dan)
Allen 662
14
Section
SQL++ slides worksheet solutions
16:30-17:20 Midterm Review (Room BAG 131)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
15
13:30-14:20 Midterm
16
17 18
President's Day
23:00 HW5: NoSQL (SQL++) (1 wk)
19
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
20
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2)
15:30-16:20 OH (Dan)
Allen 662
21
Section
AWS and SPark Setup
16:30-17:20 Makeup Lecture: Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) (Room BAG 131)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
22
13:30-14:20 Lecture
SIG 134
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
23
24 25
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
26
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
27
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
Unit 5 Parallel Databases (20.1) Introduction to Spark (no reading)
15:30-16:20 OH (Dan)
Allen 662
28
Section
Query Evaluation and Cost Estimation Worksheet Worksheet solution
16:30-17:20 Makeup Lecture: More Spark (Room BAG 131)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
01
13:30-14:20 Lecture
SIG 134
Unit 6 E/R Diagrams and Constraints (4.1-4.6)
23:00 HW6: Spark and running on AWS (2 wk)
02

March
SundayMondayTuesdayWednesdayThursdayFridaySaturday
03 04
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
Integrity Constraints
05
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
06
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
BCNF (3.1-3.4)
15:30-16:20 OH (Dan)
Allen 662
22:00-23:00 WQ6: Conceptual Design
07
Section
Functional Dependencies, Views Slides Worksheet Worksheet Solutions Supplementary Notes on Design Theory
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
08
13:30-14:20 Lecture
SIG 134
Unit 7 Introduction to Transactions (18.1) Sqlite demo
23:00 HW7: Schema design + JDBC application (1 wk)
09
10 11
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134
More Transactions (18.1-3)
12
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
13
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134
Transaction Implementations (18.1-3)
15:30-16:20 OH (Dan)
Allen 662
22:00-23:00 WQ7: Transactions
14
Section
Transactions and Final Review Slides Final Review Slides Worksheet Worksheet Solutions
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br)
15
13:30-14:20 Lecture
SIG 134
Final Review
16
17
23:00 HW8: Transactions in the JDBC application (1.5 wk)
18
14:30-16:20 Final exam
19 20 21 22 23