Subscribe to this calendar (Google, iCal, etc.)
January | ||||||
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
06 | 07
11:30-12:20 OH (Ying)
Allen 021 |
08
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
09
9:00-10:00 OH (Walter)
Allen 4th fl br |
10
16:30-17:20 Makeup Lecture (Room: BAG 131): SQL Basics (6.1-2)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
11
15:30-16:20 OH (Shana)
Gates 152 |
12
22:00-23:00 WQ1: Simple SQL
|
13 | 14
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 CANCELED (makeup: 1/10, 4:30pm, BAG 131) |
15
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
23:00 HW1: SQLite (1 wk)
|
16
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134 CANCELED (makeup: 1/22, 5:30pm, BAG 131) |
17
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
18
13:30-14:20 Lecture
SIG 134 Aggregates (6.3-4) |
19
22:00-23:00 WQ2: SQL Aggregates
|
20 | 21
MLK Day
|
22
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br
17:30-18:20 Makeup Lecture (Room BAG 131): SQL Subqueries (6.3)
23:00 HW2: SQL basics (1 wk)
|
23
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134 SQL wrap-up. Relational algebra (2.4 & 5.1)
15:30-16:20 OH (Dan)
Allen 662
22:00-23:00 WQ3: SQL Nested Queries
|
24
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
25
13:30-14:20 Lecture
SIG 134 More relational algebra (2.4 & 5.1) |
26
22:00-23:00 WQ4: Relational Algebra
|
27 | 28
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 Datalog (5.3-5.4) |
29
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
30
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134 Datalog (5.3-5.4)
15:30-16:20 OH (Dan)
Allen 662 |
31
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
01
22:00-23:00 WQ5: Datalog
|
02 |
February | ||||||
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
03 | 04
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 CANCELED (Snow day) |
05
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
06
9:00-10:00 OH (Walter)
Allen 4th fl br
15:30-16:20 OH (Dan)
Allen 662 |
07
Section
JSON/SQL++ and Midterm review slides Midterm general practice Additional midterm datalog practice Midterm general practice solutions Additional midterm datalog practice solutions
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
08
13:30-14:20 Lecture
SIG 134 CANCELED (Snow day) |
09 |
10 | 11
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 CANCELED (Snow day) |
12
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
13
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134 JSon and SQL++
15:30-16:20 OH (Dan)
Allen 662 |
14
16:30-17:20 Midterm Review (Room BAG 131)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
15
13:30-14:20 Midterm
|
16 |
17 | 18
President's Day
|
19
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
20
9:00-10:00 OH (Walter)
Allen 4th fl br
15:30-16:20 OH (Dan)
Allen 662 |
21
Section
AWS and SPark Setup
16:30-17:20 Makeup Lecture: Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) (Room BAG 131)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
22
13:30-14:20 Lecture
SIG 134 Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) |
23 |
24 | 25
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) |
26
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
27
9:00-10:00 OH (Walter)
Allen 4th fl br
15:30-16:20 OH (Dan)
Allen 662 |
28
16:30-17:20 Makeup Lecture: More Spark (Room BAG 131)
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
01 | 02 |
March | ||||||
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
03 | 04
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 Integrity Constraints |
05
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
06
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134 BCNF (3.1-3.4)
15:30-16:20 OH (Dan)
Allen 662
22:00-23:00 WQ6: Conceptual Design
|
07
Section
Functional Dependencies, Views Slides Worksheet Worksheet Solutions Supplementary Notes on Design Theory
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
08 | 09 |
10 | 11
11:30-12:20 OH (Ying)
Allen 021
13:30-14:20 Lecture
SIG 134 More Transactions (18.1-3) |
12
9:30-11:00 OH (Natalie)
Allen 007
11:00-13:00 OH (Jonathan)
Allen 4th fl br |
13
9:00-10:00 OH (Walter)
Allen 4th fl br
13:30-14:20 Lecture
SIG 134 Transaction Implementations (18.1-3)
15:30-16:20 OH (Dan)
Allen 662
22:00-23:00 WQ7: Transactions
|
14
16:30-17:30 OH (Shana)
Gates 150
17:30-18:30 OH (Jack)
Gates 150 (or Allen 4th fl br) |
15
13:30-14:20 Lecture
SIG 134 Final Review |
16 |
17 | 18
14:30-16:20 Final exam
|
19 | 20 | 21 | 22 | 23 |