COMS W4111.001-Introduction to Databases
Columbia University
Spring 2018

Collaboration and Academic Honesty | Homework and Project Policies | Contests and Rewards | CourseWorks and Piazza Discussion Board | Announcements | Lecture Schedule and Readings | Project 1: Part 1, Part 2, Part 3 | Project 2 | Grading Statistics

Course Description: You will learn what a database system is, how you can design databases effectively and in a principled manner, and how you can develop applications using databases. The course will focus on relational and object-relational databases.

Prerequisites:

You need to get permission from the instructor if you do not have these prerequisites. This course is intended for both Computer Science majors as well as nonmajors.

Topics: The fundamentals of database design and application development using databases: entity-relationship modeling, logical design of relational databases, relational data definition and manipulation languages, SQL; object-relational databases; query processing; physical database tuning; transaction processing.

Textbook: Raghu Ramakrishnan, Johannes Gehrke: Database Management Systems, 3rd edition, McGraw-Hill, 2002. ISBN: 0072465638. On reserve in the Science and Engineering Library.

Lectures: Tuesdays and Thursdays, 2:40-3:55 p.m., 501 Northwest Corner Building

Grades:

Instructor: Prof. Luis Gravano

Instructional Assistants, Office Hours:

All instructional assistants hold their office hours in the TA/CA Room.