Catalog Course Search Details

 Department:    CS

 Course #:    320

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    11.0701

 EPC:    CSACSBS

 REV:    2024

 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  

Prerequisite: CS 233.

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Academic N/A  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

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

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

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