Lecture
Section
Lab
Exam
Homework
Office Hour
Other
Holiday

Subscribe to this calendar

June
SundayMondayTuesdayWednesdayThursdayFridaySaturday
18 19
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Introduction
20
11:30-12:30 OH (Ryan)
2nd Floor Breakout
21
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
Data Models (2.1-3)
Slides: PDF SQL: code
22
Section
SQLite Basics
Slides and SQL: exercises and solutions
23
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
SQL Basics (6.1-6.2)
Slides: PDF SQL: sql-basics
24
25
23:00 WQ1: basic SQL
26
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
SQL Joins and Aggregates (6.3-6.4)
Slides: PDF SQL: outer joins and aggregates and Data: Data
27
11:30-12:30 OH (Ryan)
2nd Floor Breakout
23:00 HW1: SQLite Introduction
28
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
Grouping and Query Evaluation (6.3-6.4)
Slides: PDF
29
Section
More SQL
Exercises: questions and data and solutions
30
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
SQL Subqueries (6.3)
Slides: PDF SQL: subqueries
01

July
SundayMondayTuesdayWednesdayThursdayFridaySaturday
02
23:00 WQ2: SQL aggregates
03
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
SQL Wrapup (no reading) Materials Slides: PDF SQL: subqueries
04
Independence Day
05
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
Relational Algebra (2.4, 5.1) Materials Slides: PDF
23:00 HW2: SQL basics
06
Section
Azure Account Poll Materials Slides and sql
07
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Relational Algebra and Query Evaluation (5.2) Materials Slides: PDF
08
09 10
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Data Storage and Indexing (14.1)
Slides: PDF
23:00 WQ3: SQL subqueries
11
11:30-12:30 OH (Ryan)
2nd Floor Breakout
12
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
Query Optimization and Cost Estimation (15.1-3, 15.6, 16.3-5)
Slides: PDF
13
Section
RA & Query Plans
Handout Solutions, and Slides,
14
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Relational Calculus query language primer (optional reference)
Slides: PDF
15
16 17
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Datalog (Ch 5.3–5.4) query language primer Materials Slides: PDF
18
11:30-12:30 OH (Ryan)
2nd Floor Breakout
23:00 HW3 due: Advanced SQL and Tuning
19
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
Datalong and Review
Slides: PDF
20
Section
Midterm Review & Datalog
Review: Slides and Exercises and Solutions and Datalog: Exercises and Solutions
21
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Midterm Exam
22
23 24
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
E/R Diagrams and Constraints (4.1-4.6, 7.1-7.2)
Slides: PDF
23:00 WQ4: RA, RC, Datalog
25
11:30-12:30 OH (Ryan)
2nd Floor Breakout
23:00 HW4: RA and Datalog
26
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
Design Theory (3.1, 3.3-4)
Slides: PDF
27
Section
Schema Design
Exercises and Solutions
28
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
BCNF (3.5-3.7)
Slides: PDF (large) PDF (small-annotations)
29
30 31
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Introduction to Transactions (18.1)
Slides: PDF
23:00 WQ6: DB design
01
11:30-12:30 OH (Ryan)
2nd Floor Breakout
23:00 HW6: Schema Design
02
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
More Transaction (18.1-3)
Slides: PDF
03
Section
Transactions
Slides and Exercises and Solutions
04
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Transaction Implementations (6.6, 18.4-6)
Slides: PDF
05

August
SundayMondayTuesdayWednesdayThursdayFridaySaturday
06 07
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Parrallel Databases (20.1)
Slides: PDF
23:00 WQ7: transactions
08
11:30-12:30 OH (Ryan)
2nd Floor Breakout
09
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
NoSQL (skim 11.1-3, 12.1) SQL vs NoSQL blog post (optional)
Slides: PDF
10
Section
NoSQL and Parallel DBMS
Slides and Exercises and Solutions
23:00 HW7: JDBC Application
11
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
MapReduce (20.2) Original research paper (optional)
Slides: PDF
12
13 14
10:00-12:00 OH (Trevor)
2nd Floor Breakout
14:20-15:20 Lecture
EEB 037
Spark Why Spark (quick overview)
Slides: PDF
15
11:30-12:30 OH (Ryan)
2nd Floor Breakout
16
11:00-13:00 OH (Trevor)
CSE 220
14:20-15:20 Lecture
EEB 037
ORMs and Review
Slides: PDF
17
Section
Review
Questions and Solutions
18
13:10-14:10 OH (Rob)
2nd Floor Breakout
14:20-15:20 Final Exam
19