CSE 344 Winter 2019
Lecture Topics

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

DateDescription
January 7 Unit 1 Intro
January 9 Unit 2 Relational Data Model (2.1-3) Sqlite (data model)
January 11 Joins (continued), Aggregates (6.3-4) Sqlite (joins) Sqlite (aggregates)
January 14 CANCELED (makeup: 1/10, 4:30pm, BAG 131)
January 16 CANCELED (makeup: 1/22, 5:30pm, BAG 131)
January 18 Aggregates (6.3-4)
January 23 SQL wrap-up. Relational algebra (2.4 & 5.1)
January 25 More relational algebra (2.4 & 5.1)
January 28 Datalog (5.3-5.4)
January 30 Datalog (5.3-5.4)
February 1 Unit 3
February 4 CANCELED (Snow day)
February 6 JSon and SQL++
February 8 CANCELED (Snow day)
February 11 CANCELED (Snow day)
February 13 JSon and SQL++
February 20 Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2)
February 22 Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
February 25 Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
February 27 Unit 5 Parallel Databases (20.1) Introduction to Spark (no reading)
March 1 Unit 6 E/R Diagrams and Constraints (4.1-4.6)
March 4 Integrity Constraints
March 6 BCNF (3.1-3.4)
March 8 Unit 7 Introduction to Transactions (18.1) Sqlite demo
March 11 More Transactions (18.1-3)
March 13 Transaction Implementations (18.1-3)
March 15 Final Review