CIS436 Oracle PL/SQL

This course will provide students with a working introduction to PL/SQL programming within the Oracle RDBMS environment. Students will be introduced to the PL/SQL language fundamentals of block program structure, variables, cursors, and exceptions. The course covers creating program units including procedures, functions, triggers and packages, and Oracle-supplied packages. Upon completion of this course, students will be able to write database programs using PL/SQL objects.

Prerequisite: CIS250; Co-requisite: CIS436L