index-old.md

layout
default

Note: This GitHub repository supports the Dept. of Computer Science, Columbia University course COMS W4111-Introduction to Databases. The current content is for the Spring 2019 semester, section 2, taught by Donald F. Ferguson.

W4111 - Introduction to Databases

Overview

From the Columbia University course bulletin:

""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, query processing, transaction processing. Programming projects are required.""

Office Hours Calendar

<iframe src="https://calendar.google.com/calendar/embed?src=columbia.edu_jbkdjs20p6d1vvstnsebrfg0b0%40group.calendar.google.com&ctz=America%2FNew_York" style="border: 0" width="800" height="600" frameborder="0" scrolling="no"></iframe>

Course Material

There are four subdirectories in this project:

1. Lectures contains HTML pages and PPT for each of the lectures. Direct web links for viewing the HTML lectures are:
   • Lecture 1: Introduction and Overview
   • Lecture 2: Relational Model Introduction
   • Lecture 3: Relational Model: Keys, Select, Project
   • Lecture 4: Web Applications, Select and Complex Query
   • Lecture 5: SELECT Continued, Views, Constraints, HW 2
   • Lecture 6: HW2, Join, Union
   • Lecture 7: CRUD, Views, Inheritance, Triggers, Procedures
   • Lecture 8: Datamodeling Patterns, Analytics
   • Lecture 9: HW3, Moneyball 1
   • Lecture 10: Introduction to Information Integration and Analytics
   • Lecture 11: Normalization and Analytics
   • Lecture 12: Analytics Continued
   • Lecture 13: HW 3 and Sample Midterm
   • Lecture 14: DB Implementation, HW4
2. CodeSamples contains the same programs from lectures.
3. DataAndSchema contains SQL, CSV and other data files used in projects.
4. Notebooks contains the Jupyter Notebooks used for lectures.

More to come[]