In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.
To be a more effective Oracle Developer, we recommend basic knowledge of Oracle DBA. We can offer a 1 day customized course on Oracle DBA after the first module SQL Fundamentals.
|Boot Camp Schedule for Oracle Database 11g: Advanced PL/SQL Developer OCP|
|Course||Exam #||Regular Track (days)||Super Fast Track (Days)|
|Oracle Database: Introduction to SQL NEW||1Z0-051||6||3|
|Oracle Database: Program with PL/SQL NEW||1Z0-147||6||3|
|Oracle Database 11g: Advanced PL/SQL||1Z0-146||3||1.5|
|Balance Days for day of arrival, exam(s) and practice||5||3.5|