Lecture
Section
Lab
Exam
Homework
Office Hour
Other
Holiday

Subscribe to this calendar

Use your CSE accounts to access homework assignments

September
MondayTuesdayWednesdayThursdayFriday
26 27 28
WQ 1 (Basic SQL) out
HW1 (SQL Basics) out
13:30-14:20 Lecture
JHN 075
Introduction
14:30-15:30 OH (Lisa)
CSE 006
29
Section
Introduction to SQLite
Example Queries
16:30-17:30 OH (Alvin)
CSE 530
30
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Data Models (2.1-2.3)
Example queries

October
MondayTuesdayWednesdayThursdayFriday
03
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
SQL Basics (6.1-6.2)
Example queries
04
WQ 1 (Basic SQL) due
WQ 2 (Basic SQL and aggregates) out
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
05
HW1 (SQL Basics) due
HW2 (SQL Queries) out
13:30-14:20 Lecture
JHN 075
SQL Joins and Aggregates (6.3-6.4)
14:30-15:30 OH (Lisa)
CSE 006
06
Section
SQL Basics
airport.csv
gdp.csv
population.csv
class.csv
instructor.csv
teaches.csv
problem solutions
16:30-17:30 OH (Alvin)
CSE 530
07
13:30-14:20 Lecture
JHN 075
Grouping and Query Evaluation (6.3-6.4)
14:30-15:30 OH (Danial)
CSE 006
10
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
SQL Subqueries (6.3)
11
WQ 2 (Basic SQL and aggregates) due
WQ 3 (Nested Queries) out
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
12
HW2 (SQL Queries) due
HW3 (Advanced SQL and Physical Tuning) out
13:30-14:20 Lecture
JHN 075
SQL Wrapup and relational algebra (no reading)
14:30-15:30 OH (Lisa)
CSE 006
13
Section
Nested queries and relational algebra
Handout
data
problem solutions
16:30-17:30 OH (Alvin)
CSE 530
14
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Relational Algebra (2.4)
17
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
Relational Algebra and Query Evaluation (no reading)
18
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
19
13:30-14:20 Lecture
JHN 075
Data Storage and Indexing (14.1)
14:30-15:30 OH (Lisa)
CSE 006
20
Section
Relational algebra and cost estimation
Handout
problem solutions
16:30-17:30 OH (Alvin)
CSE 530
21
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Query Optimization and Cost Estimation (15.1-3, 15.6)
24
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
More Cost Estimation
25
WQ 3 (Nested Queries) due
WQ 4 (RA, RC, Datalog) out
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
26
HW3 (Advanced SQL and Physical Tuning) due
HW4 (Relational algebra, datalog, relational calculus) out
13:30-14:20 Lecture
JHN 075
Relational calculus (query language primer)
14:30-15:30 OH (Lisa)
CSE 006
27
Section
More cost estimation and relational calculus
Handout
problem solutions
16:30-17:30 OH (Alvin)
CSE 530
28
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Datalog (5.3-5.4, query language primer)
31
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
NoSQL and JSon (skim 11.1-3, 12.1)
17:30-18:30 OH (Alvin)
CSE 530
01
WQ 4 (RA, RC, Datalog) due
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
02
HW4 (Relational algebra, datalog, relational calculus) due
HW5 (JSon, NoSQL, and CouchBase) out
13:30-14:20 Lecture
JHN 075
CouchBase and N1QL (no reading)
14:30-15:30 OH (Lisa)
CSE 006
03
Section
N1QL
04
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Midterm Review

November
MondayTuesdayWednesdayThursdayFriday
07
12:30-13:30 OH (Amanda)
CSE 006
13:30-14:20 Midterm Exam
08
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
09
13:30-14:20 Lecture
JHN 075
E/R Diagrams and Constraints (4.1-4.6)
14:30-15:30 OH (Lisa)
CSE 006
10
Section
ER Diagrams
11
Veterans Day
HW5 (JSon, NoSQL, and CouchBase) due
HW6 (E/R and Conceptual Design) out
WQ 6 (E/R and Design Theory) out
14
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
Design Theory (3.1-3.4)
15
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
16
13:30-14:20 Lecture
JHN 075
BCNF (3.1-3.4)
14:30-15:30 OH (Lisa)
CSE 006
17
Section
BCNF
16:30-17:30 OH (Alvin)
CSE 530
18
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Introduction to Transactions (18.1)
21
HW6 (E/R and Conceptual Design) due
WQ 6 (E/R and Design Theory) due
HW7 (Transactions) out
WQ 7 (Transactions) out
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
More Transactions (18.1-3)
22
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
23
13:30-14:20 Lecture
JHN 075
Transaction Implementations (18.1-3)
14:30-15:30 OH (Lisa)
CSE 006
24
Thanksgiving
25
Thanksgiving
28
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
Parallel Databases (20.1)
29
WQ 7 (Transactions) due
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
30
HW7 (Transactions) due
HW8 (Distributed Query Processing) out
13:30-14:20 Lecture
JHN 075
More Parallel Databases and MapReduce (20.1-2)
14:30-15:30 OH (Lisa)
CSE 006
01
Section
MapReduce
14:00-15:00 OH (Alvin)
CSE 530
02
11:30-12:30 OH (Danial)
CSE 006
13:30-14:20 Lecture
JHN 075
Spark (no reading)

December
MondayTuesdayWednesdayThursdayFriday
05
11:30-12:30 OH (Amanda)
CSE 006
13:30-14:20 Lecture
JHN 075
More Spark (no reading)
06
10:30-11:30 OH (Amarpal)
CSE 006
12:30-13:30 OH (Yedi)
CSE 006
07
HW8 (Distributed Query Processing) due
13:30-14:20 Lecture
JHN 075
Finale (no reading)
14:30-15:30 OH (Lisa)
CSE 006
08
16:30-17:30 OH (Alvin)
CSE 530
09
11:30-12:30 OH (Danial)
CSE 006
12
14:30-16:20 Final Exam
13 14 15 16