INT-2082 Advanced Oracle and PL/SQL

Credits 4
Builds on INT 2081, continuing with Oracle database operations and introducing programming with PL/SQL. Includes advanced programming using procedures and functions, parameter passing, event driven programming. Includes an introduction to object oriented concepts in database development as well as a discussion of the capabilities of SQL vs. PL/SQL.

Prerequisite(s): INT-2081 with grade of C or higher.
Formerly offered as CIS-2082. Students may not receive credit for both CIS-2082 and INT-2082.
3 class/3 lab hours.
(Not offered summer.)

Course Outcomes

Create an Oracle Database instance
Develop the Oracle Network environment
Construct storage structures
Formulate data
Support users
Investigate the database performance
Create a cloud-based database