Oracle Database 12c : Adcanced PL/SQL Developer Certified Professional (OCP)

Exploit the most advanced features of PL/SQL by earning the Oracle Database 12c: Advanced PL/SQL Developer Certified Professional consulting . From performance to maintainability to application code architecture, you will be able to provide guidance at a more strategic level, offering much higher value to your company and the marketplace. You need thorough knowledge of the PL/SQL language, its architecture, features, interactions with the SQL engine, programming constructs and datatypes. You should also have the ability to answer questions on subjects such as complex datatypes, dynamic cursors, external procedures, security features and considerations and performance related features such as caching, parallel execution and profiling. This Oracle Database 12c: Advanced PL/SQL consulting teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this program, you will be introduced to Oracle Database Exadata Express Cloud Service.

Certification by : Oracle

Program # Program Contents Exam # Exam Regular Track
(days)

1Z0-148

Oracle Database 12c: Advanced PL/SQL 1Z0-148 Oracle Database 12c: Advanced PL/SQL 3
  Total 3
  • Write powerful PL/SQL programs.
  • Explore programming efficiency.
  • Use external C and Java routines.
  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service

 Candidate must hold one of these programs.

  1. Oracle Database SQL Certified Associate
  2. Oracle Database SQL Certified Expert
  • Application Developers
  • Database Administrators