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 SQLVLabsbasic1

  1/16Basic SQL

basic2

 3 1/21NO CLASS (MLK Day)




  1/23Advanced SQL: INNER JOIN
join1

 4 1/28Proj1 Discussion



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

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

  2/6Advanced SQL: Subquery
subqueryhw1
 6 2/11SQL Jeopardy



  2/13Storage and Indexing
storage

 7 2/18Storage and Indexing
index

  2/20NO CLASS (SNOWDAY)




 8 2/25Hands-on
b+tree
hw1 (2/24)
(
solution)
  2/27MIDTERM




 9 3/4Spring Break




  3/6Spring Break



 10 3/11Midterm Discussion




  3/13NoSQL Foundation lab2nosql

 11 3/18Key-Value DB




  3/20Eg, Redis
redishw2
 12 3/25Graph DBDS talkgraphdb

  3/27Eg, Neo4j and Cypher
cypherproj2 hw2 (3/31)
(solution #1, #2)
 13 4/1Proj2 Discussion



  4/3Document-Oriented DB

documentdb

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

  4/10MapReduce & Hadoop



hw3 (4/14)
(solution)
 15 4/15MapReduce & Hadoopdata.jsmapreduce

  4/17Wide-column DB
Eg, Apache HBase

hbase

 16 4/22Proj2 Discussion



proj2 (4/23)
  4/24Proj2 Presentation

submissions

 174/29
 FINAL EXAM
4:40-6:40pm @ E205