CS145 - Fall 2013
Introduction to Databases
News
Schedule
Schedule is subject to adjustments
Suggested readings for each topic appear on the Textbook Readings page of the CS145 Class2Go Site

Week Videos Classes Assignments
#1
Sept. 23 & 25
-- Introduction  (14 min)
-- Relational Databases  (15 min)
-- XML Data  (44 min)
Monday: Introduction to course
Wednesday: Data management challenges at Facebook & Twitter
     Raghotham Murthy (Facebook)
     Utkarsh Srivastava (Twitter)
Assignment #1
due Oct. 7
#2
Sept. 30 & Oct. 2
-- JSON Data  (36 min)
-- Relational Algebra  (38 min)
Monday: Unix help session
Wednesday: Schema design activity
#3
Oct. 7 & 9
-- SQL  (125 min) Monday: Relational algebra activity
Wednesday: SQL help session
Assignment #2
due Oct. 14
#4
Oct. 14 & 16
-- Relational Design Theory  (103 min) Monday: SQL activity
Wednesday: Project overview and part 1 help session
Assignment #3
due Oct. 21
#5
Oct. 21 & 23
-- Querying XML  (76 min) Monday: Design theory activity
Wednesday: Database research talk
    Data, Uncertainty, and Lineage
Assignment #4
due Oct. 28
#6
Oct. 28 & 30
-- Unified Modeling Language  (53 min)
-- Indexes  (14 min)
Monday: Midterm exam review
Wednesday: Midterm exam
Assignment #5
due Nov. 11
#7
Nov. 4 & 6
-- Constraints and Triggers  (119 min) Monday: SQL vs. XQuery bakeoff
Wednesday: NoSQL solutions at Twitter & Facebook
     Dmitry Ryaboy (Twitter)
     Ravi Murthy (Facebook)
#8
Nov. 11 & 13
-- Transactions  (45 min)
-- Views  (95 min)
Monday: Triggers activity
    Activity files: P1template.txt   P2template.txt   P3template.txt
Wednesday: Project part 3 help session
Assignment #6
due Nov. 20
#9
Nov. 18 & 20
-- Authorization  (11 min)
-- Recursion in SQL  (63 min)
Monday: Transactions activity   (solutions)
Wednesday: NoSQL activity
Nov. 25-29
Thanksgiving recess Assignment #7
due Dec. 5
#10
Dec. 2 & 4
-- On-Line Analytical Processing  (45 min)
-- NoSQL Systems  (47 min)
Monday: Winning project demos
Wednesday: Final exam review
#11
Dec. 13

Friday morning: Final exam 9:00-11:30 AM