CS 6550 - Advanced Database Management Systems

Credits: (3)
Typically Taught Spring Semester: Full Sem
Course Fee: $25.00
Course Fee Purpose: Course fees are designed to cover the costs of lab equipment maintenance and replacement including desktop and server computer systems and software; consumable materials and supplies; and support for lab aides, student tutors, and online instructional resources.
Description: The course covers design, management, implementation, and programming of relational database systems in a high-volume data environment. Database design principles like E-R modeling, schema design and refinement, normal forms, and constraints are introduced. Data Definition Language queries and Data Manipulation Language queries are covered to implement and query a database. Other SQL implementation topics like stored procedures, functions, triggers, and indexes are covered. Advanced database topics like big data analytics, storage management principles, query processing and optimization, transaction management, concurrency control, parallel and distributed databases are covered. The course also introduces alternatives to relational databases.
Pre-requisite(s): CS 2550 or equivalent.