Advanced PL/SQL & OCP Exam Prep
 Obtain the knowledge needed in advanced PL/SQL programming required for certification as an Oracle Certified Professional (OCP). The exam targeted is: 1Z0-146 Advanced PL/SQL. Professionals seeking this certification must already have their Oracle Certified Associate (OCA) certification or complete the following:
One of these exams:
1Z0-051: Oracle Database 11g SQL Fundamentals
1Z0-047: Oracle Database SQL Expert
as well as:
1Z0-147: Programming with PL/SQL
The course covers the details of advanced PL/SQL features in detail, with heavy emphasis on security, tuning and performance of programs. It includes, but is not limited to, the use of these concepts and functions:
- Using SQL*Developer to create PL/SQL; Creating Stored Procedures
- Building Functions and SQL Callable Functions
- Deploying Program Units using Packages; Advanced Package Concepts
- Using Parameters and their various Modes
- PL/SQL Error Handling; Leveraging built-in Packages
- Dynamic SQL; Developing Triggers with PL/SQL
- Working with Code objects in the Data Dictionary
- Manipulating Large Objects with PL/SQL
This is an 64-hour program designed for personnel who want to enhance their skills with comprehensive PL/SQL programming knowledge and prepare for the Oracle Certified Professional (OCP) Certification.
Course Details Frequently Asked Questions About This Course
|
