NOTE: ID/PWD to access course materials will be distributed in the first class
| Week |
Date
|
Contents |
Ref. |
Download | Assigned |
DUE |
| 1 | 1/7
|
Introduction
|
|
intro (video)
| Proj1
|
|
| | 1/9 | Relational Model
|
| rel |
| | | 2 | 1/14
| Basic SQL | VLabs | SQL basic 1 |
|
| | | 1/16 | Basic SQL
|
| SQL basic 2 |
|
| | 3 | 1/21 | NO CLASS (MLK Day)
|
|
|
|
| | | 1/23 | Advanced SQL: INNER JOIN |
|
|
|
| | 4 | 1/28 | Proj1 Discussion
|
|
|
| Proj1 (1/29)
| | | 1/30 | Advanced SQL: OUTER JOIN |
|
|
| Proj1 (Canvas)
| | 5 | 2/4 | Advanced SQL: GROUP BY |
|
|
|
| | | 2/6 | Advanced SQL: Subquery |
|
| HW1 |
| | 6 | 2/11 | SQL Jeopardy |
|
|
|
| | | 2/13 | Storage and Indexing |
|
|
|
| | 7 | 2/18 | Storage and Indexing |
|
|
|
| | | 2/20 | NoSQL Foundation |
|
|
| HW1 (2/24) | | 8 | 2/25 | NoSQL Foundation |
|
|
|
| | | 2/27 | MIDTERM
|
|
|
|
| | 9 | 3/4 | Spring Break
|
|
|
|
| | | 3/6 | Spring Break |
|
|
|
| | 10 | 3/11 | Key-Value DB
|
|
| Proj2 |
| | | 3/13 | Eg, Redis |
|
|
|
| | 11 | 3/18 | Eg, Redis
|
|
|
|
| | | 3/20 | Graph DB |
|
|
|
| | 12 | 3/25 | Eg, Neo4j and Cypher |
|
| HW2 |
| | | 3/27 | Eg, Neo4j and Cypher |
|
|
|
| | 13 | 4/1 | Document-Oriented DB
|
|
|
|
| | | 4/3 | Eg, MongoDB |
|
|
| Nittany AI Challenge Phase 2
| | 14 | 4/8
| Eg, MongoDB |
|
|
|
| | | 4/10 | MapReduce & Hadoop
|
| |
| HW2 (4/14)
| | 15 | 4/15 | Column-Oriented DB |
|
|
|
| | | 4/17 | Eg, Apache HBase |
|
|
| Proj2 (4/21)
| | 16 | 4/22 | Proj2 Presentation
|
|
|
|
| | | 4/24 | Proj2 Presentation
|
|
|
|
| | 17 | 4/29-5/3
| FINAL WEEK
| |
| | |
|
|