COLUMBIA UNIVERSITY COMS W4111.002

W4111 Fall 2018 Syllabus (Section 002)

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.

Course website: http://w4111.github.io/

Textbook

Prerequisites

Programming Resources

Assignment Collaboration Policies AKA Cheating

Homework Submission Policy

Grading

Grading Policy

Notes on grading (please read):

Extra Credit

Extra credit is a way for students to illustrate their understanding of the course material in ways beyond formal assignments and exams. Extra credit is added to the final grade after computing the curve. We first compute the curve and grade cut-offs using scores that do not include any extra credit, and then add extra credit afterwards. This means it does not affect other students’ final grades, and can only help.

Due to the additional work that the staff must take to assess and manage extra credit opportunities, we have fairly strict deadlines for extra credit opportunities.

Late Days

Homeworks

Projects

Additional late day rules

Alternative procedures to submit late homework:

When using late days, note that homeworks tend to get harder later in the course.

Communication

How to ask for help:

  1. Search google and see if it answers your question. Then tell us:
  2. What are you trying to do?
  3. What steps did you think would work and which have you tried?
  4. How did it fail and why do you think it failed (OK to say I don’t know why it failed)?
  5. What error did it produce?