INFO.4670 PL/SQL II: Advanced Oracle 11g PL/SQL (Formerly 90.467)

Description

This course introduces students to advanced features of PL/SQL used to design and interface with the Oracle 11g database. Students learn the benefits of Oracle 11g powerful extended PL/SQL functionality by exploring and utilizing advanced Oracle-supplied packages, procedures, REF cursors, extended interface methods, PL/SQL block debugging, case statement flows, bulk binds, code tuning considerations, and advanced object types. Students will engage in hands-on lab work using advanced techniques learned throughout the course to design PL/SQL applications that solve today's most complex business problems. This course will aid students in preparation for certification as an Oracle PL/SQL Developer Certified Associate. Prerequisite: 90.459 Credits: 3.0

Course prerequisites/corequisites are determined by the faculty and approved by the curriculum committees. Students are required to fulfill these requirements prior to enrollment. For courses offered through online or GPS delivery, students are responsible for confirming with the instructor or department that all enrollment requirements have been satisfied before registering.