Lecture
| Section
| Lab
| Exam
| Homework
| Office Hour
| Other
| Holiday
|
Subscribe to this calendar
September | ||||
Monday | Tuesday | Wednesday | Thursday | Friday |
25 | 26 | 27
16:30-17:30 OH (Gang)
HCK 132
23:00 WQ1 out: basic SQL
23:00 HW1 out: SQLite
|
28 | 29
14:15-15:15 OH (Robert)
CSE 220 |
October | ||||
Monday | Tuesday | Wednesday | Thursday | Friday |
02
13:30-14:30 OH (Ryan)
CSE 220 |
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 | 06
14:15-15:15 OH (Robert)
CSE 220 |
09
13:30-14:30 OH (Ryan)
CSE 220
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
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
23:00 WQ4 out: RA, RC, Datalog
|
16
13:30-14:30 OH (Ryan)
CSE 220
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
16:30-17:30 OH (Gang)
HCK 132 |
19
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 |
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 | 27
14:15-15:15 OH (Robert)
CSE 220 |
30
13:30-14:30 OH (Ryan)
CSE 220 |
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 | 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 | ||||
Monday | Tuesday | Wednesday | Thursday | Friday |
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 | 09
Section
Midterm Solution Review
23:00 HW4 due: RA and Datalog
|
10
Veterans Day
|
13
13:30-14:30 OH (Ryan)
CSE 220
23:00 HW6 out: Distributed Query Processing
|
14
13:00-14:00 OH (Amarpal)
CSE 021 |
15
16:30-17:30 OH (Gang)
HCK 132
23:00 HW5 due: JSON, NoSQL, and AsterixDB
|
16 | 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 |
21
13:00-14:00 OH (Amarpal)
CSE 021
23:00 HW7 out: Schema Design
23:00 WQ6 out: DB design
|
22
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
16:30-17:30 OH (Gang)
HCK 132
23:00 WQ7 out: transactions
|
30
23:00 WQ6 due: DB design
|
01
14:15-15:15 OH (Robert)
CSE 220
23:00 HW7 due: Schema Design
|
December | ||||
Monday | Tuesday | Wednesday | Thursday | Friday |
04
13:30-14:30 OH (Ryan)
CSE 220 |
05
13:00-14:00 OH (Amarpal)
CSE 021 |
06
16:30-17:30 OH (Gang)
HCK 132 |
07
23:00 WQ7 due: transactions
|
08
14:15-15:15 OH (Robert)
CSE 220
23:00 HW8 due: JDBC Application
|
11 | 12 | 13 | 14
14:30-16:20 Final Exam
|
15 |