|Day & Time
301 Pupin Laboratories
|Instructor||Luis Gravano - homepage|
|Method of Instruction||In-Person|
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|
|Enrollment||204 students (225 max) as of 11:06AM Sunday, December 10, 2023|