CSE 344 Summer 2018
Schedule

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

June
MondayTuesdayWednesdayThursdayFriday
18
14:20-15:20 Lecture
SIG 134
Introduction
Slides (with ink)
19 20
14:20-15:20 Lecture
SIG 134
Introduction to Relational Databases
Slides and SQL
21
14:20-15:20 Section
SIG 134
Git and Sqlite: Slides and SQL
22
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
Joins
Slides and SQL
25
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
Grouping and Aggregation
Slides and SQL
23:00 WQ1 due: SQL Basics
26
12:30-13:30 OH (Yao)
CSE 220
27
14:20-15:20 Lecture
SIG 134
Subqueries
Slides
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
23:00 HW1 due: SQL Basics and Sqlite (general and HW1 instructions)
28
14:20-15:20 Section
SIG 134
SQL: Slides, Worksheet, and Solutions
29
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
Relational Algebra (RA)
Slides
23:00 WQ2 due: SQL Aggregates

July
MondayTuesdayWednesdayThursdayFriday
02
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
Relational Algebra cont.
Slides
03
12:30-13:30 OH (Yao)
CSE 220
04
Independence Day
23:00 HW2 due: SQL Queries (instructions)
05
14:20-15:20 Section
SIG 134
Relational Algebra: Slides, Worksheet, and Solutions
06
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
Datalog
Slides
23:00 WQ3 due: SQL Subqueries
09
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
NoSQL
Slides and Video
17:00-19:00 OH (Andrew)
CSE 006
10
12:30-13:30 OH (Yao)
CSE 220
11
14:20-15:20 Lecture
SIG 134
Introduction to Semistructured Data
Slides and Video
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
23:00 HW3 due: Advanced SQL and Azure (instructions)
12
14:20-15:20 Section
SIG 134
Datalog: Slides, Worksheet, and Solutions
13
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
SQL++
Slides and Video
23:00 WQ4-5 due: Relational Algebra and Datalog
16
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
Physical Plans and Storage
Slides and Video
17:00-19:00 OH (Andrew)
CSE 006
17
12:30-13:30 OH (Yao)
CSE 220
18
14:20-15:20 Lecture
SIG 134
Indexing and Disk Access
Slides and Video
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
23:00 HW4 due: RA and Datalog (instructions)
19
14:20-15:20 Section
SIG 134
SQL++ and Review: Slides, Worksheet, and Solutions
20
9:30-10:30 OH (Ying)
CSE 021
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
Cost-based Optimization
Slides and Video
23
14:20-15:20 Lecture
SIG 134
Introduction to Parallel Databases
Slides and Video
17:00-19:00 OH (Andrew)
CSE 006
24
12:30-13:30 OH (Yao)
CSE 220
25
14:20-15:20 Lecture
SIG 134
MapReduce
Slides and Video
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
23:00 HW5 due: JSON, NoSQL, and AsterixDB (instructions)
26
14:20-15:20 Section
SIG 134
Midterm Review: Slides
27
12:30-13:30 OH (Kevin)
CSE 212
14:30-15:30 Midterm Exam (in class)
30
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
Entities and Relations (E/R)
Slides and Video
17:00-19:00 OH (Andrew)
CSE 006
31
12:30-13:30 OH (Yao)
CSE 220
01
14:20-15:20 Lecture
SIG 134
E/R Constraints
Slides and Video
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
02
14:20-15:20 Section
SIG 134
Design Theory: Slides, Worksheet, and Solutions
23:00 HW6 due: Parallel Processing and Spark (instructions)
03
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
Normalization
Slides and Video

August
MondayTuesdayWednesdayThursdayFriday
06
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
Lossless Decomposition and Views
Slides and Video
17:00-19:00 OH (Andrew)
CSE 006
23:00 WQ6 due: Database Design
07 08
14:20-15:20 Lecture
SIG 134
Transactions
Slides and Video
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
23:00 HW7 due: E/R and Database Design (instructions)
09
10:30-11:30 OH (Yao)
CSE 220
14:20-15:20 Section
SIG 134
Transactions: Slides, Worksheet (only partly covered), and Solutions
10
12:30-13:30 OH (Kevin)
CSE 212
14:20-15:20 Lecture
SIG 134
Scheduling
Slides and Video
13
11:00-12:00 OH (Ying)
CSE 021
14:20-15:20 Lecture
SIG 134
Isolation
Slides and Video
17:00-19:00 OH (Andrew)
CSE 006
23:00 WQ7 due: Transactions
14 15
14:20-15:20 Lecture
SIG 134
More Parallel & Advanced Topics
Slides and Video
17:30-19:30 OH (Andrew)
CSE 4th floor breakout
23:00 HW8 due: Transactions and Database Applications (instructions)
16
14:20-15:20 Section
SIG 134
Final Review: Slides
17
12:30-13:30 OH (Kevin)
CSE 212
14:30-15:30 Final Exam (in class)