Lecture
Exam
Homework
Office Hour
Other
Holiday

Subscribe to this calendar

March
SundayMondayTuesdayWednesdayThursdayFridaySaturday
25 26
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
Introduction (large) (small)
27
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
28
13:00-14:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
Relational Data Model (large) (small) (2.1-3)
Sqlite Demo
29
Section
VM, Git/GitLab, SQLite
16:30-17:30 OH (Boyan)
CSE 021
30
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
SQL Basics (large) (small) (6.1-2)
Sqlite Demo
31

April
SundayMondayTuesdayWednesdayThursdayFridaySaturday
01 02
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
SQL Aggregates (large) (small) (6.3-4)
03
HW1: SQLite and SQL Basics due
WQ1: Simple SQL due
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
04
12:00-13:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
SQL Aggregates (large) (small) (6.3-4)
Sqlite Demo
Sqlite Demo Data
05
Section
A SeQueL to SQL
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
06
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
SQL Subqueries (large) (small) (6.4)
07
08 09
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
SQL wrap-up (large) (small)
10
HW2: Basic SQL Queries due
WQ2: SQL Aggregates due
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
11
12:00-13:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
Datalog (large) (small) (5.3-5.4)
12
Section
Grouping and (Un)Nesting
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
13
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
More Datalog (large) (small) (5.3-5.4)
Souffle Demo 1
Souffle Demo 2
Souffle Demo 3
Souffle Demo 4
14
15 16
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
Relational algebra (large) (small) (2.4 & 5.1)
17
HW3: Advanced SQL and Azure due
WQ3: SQL Subqueries due
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
18
15:30-16:20 Lecture
THO 101
More relational algebra (large) (small)
16:30-17:30 OH (Alvin)
CSE 530
19
Section
Relational Algebra and Datalog
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
20
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
Introduction to NoSQL (large) (small)
21
22 23
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
JSon and SQL++ (large) (small)
(SQL++ tutorial, Pages 6-25, 28-35 (skip SELECT VALUE), 41-65)
24
HW4: Finding the Mitochondrial Eve due
WQ4: Datalog due
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
25
13:00-14:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
SQL++ (large) (small)
26
Section
NoSQL, SQL++
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
27
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
SQL++ Wrapup (large) (small)
28
29 30
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
From RA to Query Evaluation, Parallel Databases (large) (small) (5.2 & 16.3, skim 16.3.2, 20.1)
01
HW5: json, nosql, and asterixdb due
WQ5: Relational Algebra due
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
02
13:00-14:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
MapReduce and Spark (large) (small) (no reading)
17:00-19:00 Midterm review
Review questions
Review questions solutions
Datalog questions
Datalog questions solutions
MUE 153
03
Section
Parallel Databases
16:30-18:30 OH (Boyan and Vineeth)
CSE 4th floor breakout
04
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Midterm Exam
05

May
SundayMondayTuesdayWednesdayThursdayFridaySaturday
06 07
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
Spark (large) (small) (no reading)
08
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
09
13:00-14:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
E/R Diagrams (large) (small) (4.1-4.6)
10
Section
Integrity Constraints
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
17:00-18:00 OH (Kodiak)
CSE 4th floor breakout
11
HW6: Parallel Data Processing and Spark due
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
Design Theory (large) (small) (3.1-3.4)
12
13 14
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
BCNF (large) (small) (3.1-3.4)
15
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
16
13:00-14:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
Introduction to Transactions (small) (18.1)
17
Section
BCNF and Views
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
17:30-18:30 OH (Kodiak)
CSE 4th floor breakout
18
HW7: Entity Relationship Diagrams and Conceptual Design due
WQ6: Entity Relationship Diagrams due
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
More Transactions (small) (18.1-3)
19
20 21
13:00-14:00 OH (Jack)
CSE 025
14:00-15:00 OH (Cindy)
CSE 021
15:30-16:20 Lecture
THO 101
Transaction Implementations (small) (18.1-3)
22
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
23
13:00-14:00 OH (Alvin)
CSE 530
15:30-16:20 Lecture
THO 101
Storage & Indexing Basics (small) (8.3-4 & 14.1-1.7, skim 14.2-3)
24
Section
Transactions and Isolation Levels
handout
solutions
16:30-17:30 OH (Boyan)
CSE 021
25
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
More Storage & Indexing (small) (15.{1,3,4.6,6} and 16.4-5)
26
27 28
Memorial Day
29
12:30-13:30 OH (Kodiak)
CSE 2nd floor breakout
14:00-15:00 OH (Jonathan)
CSE 3rd floor breakout
15:30-16:30 OH (Vineeth)
CSE 2nd floor breakout
30
HW8: Database Application and Transaction Management due
WQ7: Transactions due
12:00-13:00 OH (Jack)
CSE 220
13:00-14:00 OH (Cindy)
CSE 220
15:30-16:20 Lecture
THO 101
More Operator Costs (small) (15.{1,3,4.6,6} and 16.4-5)
31
Section
Analysis and Optimization
handout
solutions
16:30-17:30 OH (Boyan)
CSE 303
16:30-17:30 OH (Alvin)
CSE 303
01
9:30-10:30 OH (Ying)
CSE 021
15:30-16:20 Lecture
THO 101
Intro to Query Optimization (small)
02

June
SundayMondayTuesdayWednesdayThursdayFridaySaturday
03
14:30-17:00 Final review
Review questions
SMI 102
04 05 06 07
14:30-16:20 Final Exam
08 09