DSCI 512 Advanced Database Management
This course covers database management systems from the computer professional's point of view. It introduces the fundamental concepts necessary for designing, using, and implementing database systems. Topics include the database environment, database system concepts and architecture, data modeling using the entity-relationship approach, relational, network, and hierarchical data models, emphasizing the relational model, database design, relational database language SQL, and NoSQL. In this course, relations are developed based on the normalization process and implemented using Microsoft SQL Server and AWS NoSQL. Students will also study the processing of databases from application programs, including Web-based programs.
Prerequisite
CSCI 241 or permission of the instructor.