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