Fall 2023 Computer Science W4111 section 001

INTRODUCTION TO DATABASES

Call Number 11218
Day & Time
Location
TR 1:10pm-2:25pm
301 Pupin Laboratories
Points 3
Grading Mode Standard
Approvals Required None
Instructor Luis Gravano - homepage
Type LECTURE
Method of Instruction In-Person
Course Description

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, XML, query processing, physical database tuning, transaction processing, security. Programming projects are required.

Class Description Prerequisites: COMS W3134, COMS W3136, or COMS W3137; or the instructor's permission. 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.
Web Site Vergil, Section Homepage
Department Computer Science
Enrollment 203 students (225 max) as of 9:07PM Monday, July 15, 2024
Subject Computer Science
Number W4111
Section 001
Division Interfaculty
Open To Barnard College, Business, Columbia College, Engineering:Undergraduate, Engineering:Graduate, GSAS, General Studies, Journalism
Section key 20233COMS4111W001