Subscribe to this calendar (google, iCal, etc.)
| January | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 06
09:30-10:20 Lecture
MGH 389 Syllabus; Relational Model |
07 | 08
09:30-10:20 Lecture
MGH 389 SQL SELECT-WHERE, Set builder semantics, Nested loop semantics |
09
Section
SQL Basics |
10
09:30-10:20 Lecture
MGH 389 (Inner) Joins |
| 13
09:30-10:20 Lecture
MGH 389 Outer Joins and SQL NULL |
14 | 15
09:30-10:20 Lecture
MGH 389 Database design for collections
23:59 HW1 due
|
16
Section
Joins; Connecting to SQLite from Java |
17
09:30-10:20 Lecture
MGH 389 Aggregation and SQL GROUP BY |
| 20
MLK Day
|
21 | 22
09:30-10:20 Lecture
MGH 389 Combining Aggregation and Joins
23:59 HW2 due
|
23
Section
Aggregation |
24
09:30-10:20 Lecture
MGH 389 Subqueries |
| 27
09:30-10:20 Lecture
MGH 389 Implementing predicate logic with subqueries |
28 | 29
09:30-10:20 Lecture
MGH 389 More subqueries
23:59 HW3 due
|
30
Section
Subqueries |
31
09:30-10:20 Lecture
MGH 389 Relational Algebra |
| February | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 03
09:30-10:20 Lecture
MGH 389 Entity-Relationship (ER) modeling |
04 | 05
09:30-10:20 Lecture
MGH 389 (canceled for snow)
23:59 HW4 due
|
06
Section
Relational Algebra, E-R design |
07
09:30-10:20 Lecture
MGH 389 Functional Dependencies |
| 10
09:30-10:20 Lecture
MGH 389 Normalization; BCNF |
11 | 12
09:30-10:20 Midterm
|
13
Section
FDs and BCNF |
14
09:30-10:20 Lecture
MGH 389 Transaction Basics |
| 17
President's Day
|
18 | 19
09:30-10:20 Lecture
MGH 389 Transaction Serializability
23:59 HW5 due
|
20
Section
Transactions |
21
09:30-10:20 Lecture
MGH 389 Transaction Locks |
| 24
09:30-10:20 Lecture
MGH 389 Application data management |
25 | 26
09:30-10:20 Lecture
MGH 389 CRUD |
27
Section
Locks; SQL injection; intro to flights app |
28
09:30-10:20 Lecture
MGH 389 Query execution |
| March | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 03
09:30-10:20 Lecture
MGH 389 Indexing and external memory algorithms |
04 | 05
09:30-10:20 Lecture
MGH 389 Query Optimization |
06
Section
Query execution and indexing |
07
09:30-10:20 Lecture
MGH 389 Class canceled (James traveling)
23:59 HW6 due
|
| 10
09:30-10:20 Lecture
MGH 389 Cardinality estimation |
11 | 12
09:30-10:20 Lecture
MGH 389 OLAP workloads |
13
Section
Query optimization |
14
09:30-10:20 Lecture
MGH 389 Cloud-based OLAP
23:59 HW7 due
|
| 17 | 18 | 19
08:30-10:20 Final exam
|
20 | 21 |