3credit hour(s)(Prerequisite: CIS 2520 or department approval)
Introduces Oracle’s PL/SQL programming language, which is a standard procedural language for relational databases. Students will learn and develop PL/SQL programs that use built-in SQL functions, conditional and iterative control structures, stored procedures, functions packages, triggers and how to trap exceptions. Each student benefits by learning the industry standards while utilizing the latest database software and online training materials. Prepares students for 2nd Test, which will award them with the Oracle Certified Associate Certification. Note(s) 30 theory + 45 lab hours