Schedule

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/9Relational Model

rel  
 
 2 1/14
Basic SQLVLabsSQL basic 1

  1/16Basic SQL

SQL basic 2

 3 1/21NO CLASS (MLK Day)




  1/23Advanced SQL: INNER JOIN



 4 1/28Proj1 Discussion



Proj1 (1/29)
  1/30Advanced SQL: OUTER JOIN


Proj1 (Canvas)
 5 2/4Advanced SQL: GROUP BY



  2/6Advanced SQL: Subquery

HW1
 6 2/11SQL Jeopardy



  2/13Storage and Indexing



 7 2/18Storage and Indexing



  2/20NoSQL Foundation


HW1 (2/24)
 8 2/25NoSQL Foundation



  2/27MIDTERM




 9 3/4Spring Break




  3/6Spring Break



 10 3/11Key-Value DB


Proj2
  3/13Eg, Redis



 11 3/18Eg, Redis




  3/20Graph DB



 12 3/25Eg, Neo4j and Cypher

HW2
  3/27Eg, Neo4j and Cypher



 13 4/1Document-Oriented DB




  4/3Eg, MongoDB


Nittany AI Challenge Phase 2
 14 4/8
Eg, MongoDB



  4/10MapReduce & Hadoop

 
HW2 (4/14)
 15 4/15Column-Oriented DB



  4/17Eg, Apache HBase


Proj2 (4/21)
 16 4/22Proj2 Presentation




  4/24Proj2 Presentation




 174/29-5/3
 FINAL WEEK