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 | basic1 |
|
| | | 1/16 | Basic SQL
|
| basic2 |
|
| | 3 | 1/21 | NO CLASS (MLK Day)
|
|
|
|
| | | 1/23 | Advanced SQL: INNER JOIN |
| join1 |
|
| | 4 | 1/28 | Proj1 Discussion
|
|
|
| Proj1 (1/29)
| | | 1/30 | Advanced SQL: OUTER JOIN |
| join2
(video) |
| Proj1 (Canvas)
| | 5 | 2/4 | Advanced SQL: GROUP BY |
| groupby |
|
| | | 2/6 | Advanced SQL: Subquery |
| subquery | hw1 |
| | 6 | 2/11 | SQL Jeopardy |
|
|
|
| | | 2/13 | Storage and Indexing |
| storage |
|
| | 7 | 2/18 | Storage and Indexing |
| index |
|
| | | 2/20 | NO CLASS (SNOWDAY)
|
|
|
|
| | 8 | 2/25 | Hands-on |
| b+tree |
| hw1 (2/24)
(solution)
| | | 2/27 | MIDTERM
|
|
|
|
| | 9 | 3/4 | Spring Break
|
|
|
|
| | | 3/6 | Spring Break |
|
|
|
| | 10 | 3/11 | Midterm Discussion
|
|
|
|
| | | 3/13 | NoSQL Foundation | lab2 | nosql |
|
| | 11 | 3/18 | Key-Value DB
|
|
|
|
| | | 3/20 | Eg, Redis |
| redis | hw2 |
| | 12 | 3/25 | Graph DB | DS talk | graphdb |
|
| | | 3/27 | Eg, Neo4j and Cypher |
| cypher | proj2 | hw2 (3/31)
(solution #1, #2)
| | 13 | 4/1 | Proj2 Discussion |
|
|
|
| | | 4/3 | Document-Oriented DB |
|
documentdb |
hw3 | Nittany AI Challenge Phase 2
| | 14 | 4/8
| Eg, MongoDB |
| mongodb |
|
| | | 4/10 | MapReduce & Hadoop
|
|
|
| hw3 (4/14)
(solution)
| | 15 | 4/15 | MapReduce & Hadoop | data.js | mapreduce |
|
| | | 4/17 | Wide-column DB
Eg, Apache HBase |
| hbase |
|
| | 16 | 4/22 | Proj2 Discussion
|
|
|
| proj2 (4/23) | | | 4/24 | Proj2 Presentation
|
| submissions |
|
| | 17 | 4/29
| FINAL EXAM
4:40-6:40pm @ E205
| |
| | |
|
|