This is the course home page for the Fall 2021, Section 002 of COMS W4111 - Introduction to Databases.

From the Columbia (Course) Bulletin: "The course covers what a database system is, how to design databases effectively and in a principled manner, how to query databases, and how to develop applications using databases: entity-relationship modeling, logical design of relational databases, relational algebra, SQL, database application development, database security, and an overview of query optimization and transaction processing. Additional topics generally include NoSQL, graph, object-relational, and cloud databases, as well as data preparation and cleaning of real-world data. The course offers both programming and non-programming paths for homework and projects, to accommodate students with different programming skills and backgrounds.”

Core Information

  • Lecture: Fridays, 10:10 to 12:40. (309 Havemeyer)
  • Optional Recitation: Saturdays, 10:00 to 11:30.
  • Office Hours: Fridays, 8:30AM to 10:00AM and 4:00PM to 5:00PM ( CLIC Lab, AKA CSB 486)
  • There is a GitHub project and repository associated with the class.
    • The repository will contain lecture material, examples, project templates, etc. You can clone the repo or access through the web links.
    • The repository will contain additional information about HW and project information. I am working on the details and will explain how to use when ready.
  • Other interaction Forums:
    • I have enabled ED Discussions for the class. You should be able to access the forum
      • through the left navigation menu on the CourseWorks.
    • Slack: Join group and channel W4111-f21

Contact:

Donald F. Ferguson
Dept. of Computer Science
Columbia University
West 116th St. and Broadway
New York, NY 10027
E: dff@cs.columbia.edu
Slack: dff9@dff-columbia