CS 320 - Databases and Information Management Systems

Credits: 5
Variable Credit Course: No

Lecture Hours: 55
Lab Hours: 0
Worksite/Clinical Hours: 0
Other Hours (LIA/Internships): 0

Course Description: Exploration and practice with relational and non-relational databases, including cloud databases. Learn practical techniques for designing solutions for managing persistent data.

Prerequisite: CS 233 with a grade of C or higher. Admission to BSCS program and Dept. Chair permission.
Meets FQE Requirement: No
Integrative Experience Requirement: No

Student Learning Outcomes

Describe relational database design theory and organization, including SQL tables, joins, and transactions.
Compare and contrast SQL, NoSQL, and NewSQL database design and development, including pros and cons of each.
Compare and contrast NoSQL and NewSQL models, services, and stores (e.g., Hadoop, MongoDB, Couchbase, etc.)
Recommend appropriate database programming tools to manage large datasets. (e.g., Pig, Hive).
Compare and contrast techniques for storing persistent data, including cloud technologies and serverless programming.
Normalize data including adding appropriate rules to assure data integrity.
Integrate a robust database into a software solution, such as a mobile app using the database.

Course Contents

Concepts of relational database design theory and organization, including SQL tables, joins, and transactions.
SQL, NoSQL, and NewSQL database design and development, including pros and cons of each.
NoSQL and NewSQL models, services, and stores (e.g., Hadoop, MongoDB, Couchbase, etc.).
Database programming tools to manage large datasets. (e.g., Pig, Hive).
Techniques for storing persistent data, including cloud technologies and serverless programming.
Data including adding appropriate rules to assure data integrity.
Databases into a software solution, such as a mobile app using the database.

Instructional Units: 5