CS 5550 - Advanced Database Management Systems

Credits: (3)
Typically Taught Summer Semester: Full Sem
Typically Taught Fall Semester: Full Sem
Typically Taught Spring Semester: Full Sem
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 3550