Lecture
Section
Lab
Exam
Homework
Office Hour
Other
Holiday

Subscribe to this calendar

September
MondayTuesdayWednesdayThursdayFriday
25 26 27
15:30-16:20 Lecture
HCK 132
Introduction
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
23:00 WQ1 out: basic SQL
23:00 HW1 out: SQLite
28
Section
Azure + AWS setup
Azure Setup Instructions and AWS Account Setup
29
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
Data Models (2.1-3)
Slides: large small and SQL code

October
MondayTuesdayWednesdayThursdayFriday
02
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
SQL Basics (6.1-2)
Slides: large small and SQL code and Java code and Web SQL (outside scope): HTML and Javascript and CSS
03
13:00-14:00 OH (Amarpal)
CSE 021
23:00 WQ2 out: SQL aggregates
23:00 HW2 out: SQL basics
04
15:30-16:20 Lecture
HCK 132
SQL Aggregates (6.3-4)
Slides: large small and SQL code: outer joins and aggregates and Data
16:30-17:30 OH (Gang)
HCK 132
05
Section
SQLite Basics
Slides and SQL: exercises and solutions
06
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
SQL Grouping (6.3-4)
Slides: large small and SQL code
09
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
SQL Subqueries (6.3)
Slides: large small
23:00 HW1 due: SQLite
23:00 WQ3 out: SQL subqueries
10
13:00-14:00 OH (Amarpal)
CSE 021
23:00 WQ1 due: basic SQL
11
15:30-16:20 Lecture
HCK 132
SQL wrap-up
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
12
Section
More SQL
Slides 1 and SQL: exercises and solutions and Data: airport and gdp and population and Slides 2
23:00 HW3 out: Advanced SQL and Tuning
13
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
RA: Relational Algebra (2.4 & 5.1)
Slides: large small
23:00 WQ4 out: RA, RC, Datalog
16
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
Datalog (5.3-4)
Slides: large small
23:00 HW2 due: SQL basics
23:00 HW4 out: RA and Datalog
17
13:00-14:00 OH (Amarpal)
CSE 021
23:00 WQ2 due: SQL aggregates
18
15:30-16:20 Lecture
HCK 132
Datalog cont. + NoSQL and JSON
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
19
Section
RA & Query Plans
Slides, exercises, solutions, and SQL Code
23:00 WQ3 due: SQL subqueries
20
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
NoSQL and JSON cont.
23:00 HW5 out: JSON, NoSQL, and AsterixDB
23
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
JSON and SQL++
Slides: large small
24
13:00-14:00 OH (Amarpal)
CSE 021
25
15:30-16:20 Lecture
HCK 132
JSON and SQL++ cont.
16:30-17:30 OH (Gang)
HCK 132
26
Section
AsterixDB
SQL++ Hints
27
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
RA cont. & Query Evaluation (5.2 & 16.3, skimming 16.3.2)
Slides: large small
30
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)
Slides: large small
31
13:00-14:00 OH (Amarpal)
CSE 021
01
15:30-16:20 Lecture
HCK 132
Storage & Indexing cont. + Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
02
Section
Midterm Review & Datalog
Review: exercises and solutions and Datalog: exercises and solutions
03
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
Query Optimization Basics cont., by Magdalena Balazinska
23:00 WQ4 due: RA, RC, Datalog

November
MondayTuesdayWednesdayThursdayFriday
06
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Midterm Exam
07
13:00-14:00 OH (Amarpal)
CSE 021
23:00 HW3 due: Advanced SQL and Tuning
08
15:30-16:20 Lecture
HCK 132
Parallel Databases (20.1), by Dan Suciu
Slides: large small
09
Section
Midterm Solution Review
23:00 HW4 due: RA and Datalog
10
Veterans Day
13
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
MapReduce (20.2)
Slides: large small
23:00 HW6 out: Distributed Query Processing
14
13:00-14:00 OH (Amarpal)
CSE 021
15
15:30-16:20 Lecture
HCK 132
Spark (23.1-2)
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
23:00 HW5 due: JSON, NoSQL, and AsterixDB
16
Section
AWS & Spark
17
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
Spark Cont.
20
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
E/R Diagrams & Constraints (4.1-6, 7.1-2)
Slides: large small
21
13:00-14:00 OH (Amarpal)
CSE 021
23:00 HW7 out: Schema Design
23:00 WQ6 out: DB design
22
15:30-16:20 Lecture
HCK 132
Design Theory (3.1, 3.3-4)
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
23
Thanksgiving
24
Thanksgiving
27
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
Design Theory cont.
23:00 HW6 due: Distributed Query Processing
28
13:00-14:00 OH (Amarpal)
CSE 021
23:00 HW8 out: JDBC Application
29
15:30-16:20 Lecture
HCK 132
Intro to Transactions (18.1)
Slides: large small and SQL code
16:30-17:30 OH (Gang)
HCK 132
23:00 WQ7 out: transactions
30
Section
Schema Design + Transactions
exercises and solutions and Slides
23:00 WQ6 due: DB design
01
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
More Transactions (18.1-3)
Slides: large small
23:00 HW7 due: Schema Design

December
MondayTuesdayWednesdayThursdayFriday
04
13:30-14:30 OH (Ryan)
CSE 220
15:30-16:20 Lecture
HCK 132
Transaction Implementation (18.3)
Slides: large small
05
13:00-14:00 OH (Amarpal)
CSE 021
06
15:30-16:20 Lecture
HCK 132
DB techniques for ML
Slides: large small
16:30-17:30 OH (Gang)
HCK 132
07
Section
Big Data & Review: exercises and solutions
23:00 WQ7 due: transactions
08
14:15-15:15 OH (Robert)
CSE 220
15:30-16:20 Lecture
HCK 132
Final Review
Slides: large small
23:00 HW8 due: JDBC Application
11 12 13 14
14:30-16:20 Final Exam
15