Skip to main content

New and Updated Course Descriptions

CIS 221 - Applied Database Concepts with an Oracle Database

This course has been deactivated and no longer offered at MCC

3 Credits

A sound introduction to database concepts using the database Oracle. Emphasis will be on using Oracle to build and maintain relational databases. The student will create databases, queries, custom forms and reports, and use PL/ SQL.

Prerequisite: CSC 101 or CIS 200 with a grade of C or higher

Course Learning Outcomes
1. Define database terminology
2. Develop a table design from user requirements.
3. Implement a table design in a database.
4. Develop a query of a database from specifications.
5. Convert a set of un-normalize tables to the Third Normal Form (3NF).
6. Implement a selection, update and delete query in a database using SQL.
7. Develop an input form from specifications.
8. Develop a custom report from specifications
9. Explain the responsibilities of the database administrator.

Course Offered Spring

Use links below to see if this course is offered:
Fall Semester 2024
Spring Semester 2024
Summer Session 2024