Units:

3

Instructor:

Eugene Wu Office Hours: Weds after class in MUDD 421

Professor Wu and Varun will also be on google hangouts for their office hours. Click here to go to the google hangout

Staff / Office Hours

Mon 10:00AM - 11:00AM Mengqi Wang

Tue 10:00AM - 12:00PM Qi Wang

Wed 1:15PM - 2:15PM Aayush Mudgal

Fri 3:00PM - 5:00PM Varun Shetty

Meetings:

MW 2:40pm-3:55pm, 614 Schermerhorn

Description:
The goal of this class is two-fold. First, to introduce you to core database concepts (e.g., data modeling, logical design, SQL) so that you too can build a billion dollar application. Second, to teach enough about database engine internals (e.g., physical database design, query optimization, transaction processing) so you have a good sense of why queries may be running slowly/incorrectly. Students are expected to be comfortable with data structures and Python.

Basic Info:

Grading:
Grading will be based on exams and successful completion of homeworks and projects.

Homeworks 15%
Project 1 15%
Project 2 5%
Midterm 25%
In class test 2 40%
Scribe Notes Up to or greater than 5%
See Syllabus for grading info

Useful Links:
Discuss the class on Piazza. Aside from personal questions, please use Piazza rather than emailing the staff!
Check out the course github repository (including lecture notes, code, homeworks, and slides!).

Ephemeral Announcments

Midterm 2 solutions: Midterm 2 Solutions
Past midterm 2 solutions: 2015 Fall Sol 2016 Spring Sol

Midterm 2 Details

Please note that the location details are not the same as for Midterm 1!!
  • Location: 614 Schermerhorn if LAST DIGIT of your UNI is < 5 303 Mudd otherwise
  • Duration: 75 minutes
  • Cumulative
  • In class, Dec 5th
  • 1 page cheat sheet, both sides
  • No calculators, electronics
Concurrency practice problems
Past midterm 2s: 2015 Fall 2016 Spring
Access path and join ordering practice problems
Midterm 1 Solutions

Class Schedule

Date

Topic

Readings

Assigned

Due

Sponsors


Many thanks to Instabase.com for donating computing, hosting, and repository resources for our assignments.