Lecture
Section
Lab
Exam
Homework
Office Hour
Other
Holiday

Subscribe to this calendar

March
SundayMondayTuesdayWednesdayThursdayFridaySaturday
26 27
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
Introduction
Slides: large small
28
16:30-17:00 OH (Rajiv)
CSE 220
29
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
Data Models (2.1-3)
Slides: large small and SQL code
30
Section
SQLite Basics
Slides and SQL: exercises and solutions
10:30-11:30 OH (Ryan)
CSE 220
31
15:30-16:20 Lecture
THO 101
SQL Basics (6.1-2)
Slides: large small and SQL code and Java code and Web SQL (outside scope): HTML and Javascript and CSS
17:00-18:00 OH (Kevin)
CSE 212
01

April
SundayMondayTuesdayWednesdayThursdayFridaySaturday
02
23:00 WQ1 due: basic SQL
03
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
SQL Aggregates (6.3-4)
Slides: large small and SQL code: outer joins and aggregates and Data
04
16:30-17:00 OH (Rajiv)
CSE 220
23:00 HW1 due: SQLite
05
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
SQL Grouping (6.3-4)
Slides: large small and SQL code
06
Section
More SQL
Slides and SQL: exercises and solutions and Data: airport and gdp and population
10:30-11:30 OH (Ryan)
CSE 220
07
15:30-16:20 Lecture
THO 101
SQL Subqueries (6.3)
Slides: large small
17:00-18:00 OH (Kevin)
CSE 212
08
09
23:00 WQ2 due: SQL aggregates
10
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
SQL wrap-up
Slides: large small
11
16:30-17:00 OH (Rajiv)
CSE 220
23:00 HW2 due: SQL basics
12
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
RA: Relational Algebra (2.4 & 5.1)
Slides: large small
13
Section
Azure
Azure Setup Instructions and Slides
10:30-11:30 OH (Ryan)
CSE 220
14
15:30-16:20 Lecture
THO 101
RA cont. & Query Evaluation (5.2 & 16.3, skimming 16.3.2)
Slides: large small
17:00-18:00 OH (Kevin)
CSE 212
15
16
23:00 WQ3 due: SQL subqueries
17
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)
Slides: large small
18
16:30-17:00 OH (Rajiv)
CSE 220
19
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
Storage & Indexing cont.
20
Section
RA & Query Plans
Slides, exercises, solutions, and SQL Code
10:30-11:30 OH (Ryan)
CSE 220
21
15:30-16:20 Lecture
THO 101
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
Slides: large small
17:00-18:00 OH (Kevin)
CSE 212
22
23 24
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
Datalog (5.3-4)
Slides: large small
25
16:30-17:00 OH (Rajiv)
CSE 220
23:00 HW3 due: Advanced SQL and Tuning
26
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
Datalog cont.
27
Section
Midterm Review & Datalog
Review: exercises and solutions and Datalog: exercises and solutions
10:30-11:30 OH (Ryan)
CSE 220
28
15:30-16:20 Midterm Exam
29
30
23:00 WQ4 due: RA, RC, Datalog
01
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
NoSQL and JSON
Slides: large small
02
16:30-17:00 OH (Rajiv)
CSE 220
23:00 HW4 due: RA and Datalog
03
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
JSON and SQL++
Slides: large small
04
Section
AsterixDB
SQL++ Hints
10:30-11:30 OH (Ryan)
CSE 220
05
15:30-16:20 Lecture
THO 101
JSON and SQL++ cont.
17:00-18:00 OH (Kevin)
CSE 212
06

May
SundayMondayTuesdayWednesdayThursdayFridaySaturday
07 08
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
E/R Diagrams & Constraints (4.1-6, 7.1-2)
Slides: large small
09
16:30-17:00 OH (Rajiv)
CSE 220
10
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
Design Theory (3.1, 3.3-4)
Slides: large small
11
Section
Schema Design
exercises and solutions
10:30-11:30 OH (Ryan)
CSE 220
23:00 HW5 due: JSON, NoSQL, and AsterixDB
12
15:30-16:20 Lecture
THO 101
Design Theory cont.
17:00-18:00 OH (Kevin)
CSE 212
13
14
23:00 WQ6 due: DB design
15
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
Intro to Transactions (18.1)
Slides: large small and SQL code
16
16:30-17:00 OH (Rajiv)
CSE 220
17
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
More Transactions (18.1-3)
Slides: large small
23:00 HW6 due: Schema Design
18
Section
Transactions
Slides
10:30-11:30 OH (Ryan)
CSE 220
19
15:30-16:20 Lecture
THO 101
Transaction Implementation (18.3)
Slides: large small
17:00-18:00 OH (Kevin)
CSE 212
20
21
23:00 WQ7 due: transactions
22
14:00-15:00 OH (Weston)
CSE 220
15:30-16:20 Lecture
THO 101
Parallel Databases
Slides: large small
23
16:30-17:00 OH (Rajiv)
CSE 220
24
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
MapReduce
Slides: large small
23:00 HW7 due: JDBC Application
25
Section
AWS & Spark
10:30-11:30 OH (Ryan)
CSE 220
26
15:30-16:20 Lecture
THO 101
Spark
Slides: large small
17:00-18:00 OH (Kevin)
CSE 212
27
28 29
Memorial Day
30
16:30-17:00 OH (Rajiv)
CSE 220
31
10:00-11:00 OH (Antony)
CSE 021
15:30-16:20 Lecture
THO 101
Streaming Data
slides
01
Section
Big Data & Review: exercises and solutions
10:30-11:30 OH (Ryan)
CSE 220
02
15:30-16:20 Lecture
THO 101
Final Review
Slides: large small
17:00-18:00 OH (Kevin)
CSE 212
23:00 HW8 due: Distributed Query Processing
03

June
SundayMondayTuesdayWednesdayThursdayFridaySaturday
04 05 06 07 08
14:30-16:20 Final Exam
09 10