Oracle Advanced PL SQL

Duration: 
3 days
Codes: 
STA-OAP,SQL,PL

Overview

Not available. Please contact.

Audience

Software development personnel and Oracle database administrators who need to take advantage of the advanced features of PL/SQL in Oracle Database 11g R2 and Oracle Database 12c.

Practical experience of Oracle SQL or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Writing code to interface with external applications and the operating system
  • Creating PL/SQL applications that use collections
  • Implementing a virtual private database with fine-grained access control
  • Manipulating large objects
  • Administering SecureFile LOBs
  • Designing PL/SQL packages and program units for execution efficiency
  • Tuning PL/SQL Code for Performance
  • Improving memory usage with SQL and PL/SQL Result Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Safeguarding SQL code
  • Miscellaneous New 12c Features

Miscellaneous New 12c Features Course Objectives Course Objectives

By the end of this Oracle Advanced PL/SQL course delegates will be able to effectively tune PL/SQL code; create subtypes; create and use collections; execute external C programs and Java programs from PL/SQL; use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result sets and apply coding standards to avoid SQL injection attacks.

Prerequisites

Practical experience of Oracle SQL and the PL/SQL programming language is required. This can be gained by attendance on the pre-requisite courses. Familiarity with the Oracle Database is also required.

Course Outline

The delegate will learn and acquire skills as follows:

  • Writing code to interface with external applications and the operating system
  • Creating PL/SQL applications that use collections
  • Implementing a virtual private database with fine-grained access control
  • Manipulating large objects
  • Administering SecureFile LOBs
  • Designing PL/SQL packages and program units for execution efficiency
  • Tuning PL/SQL Code for Performance
  • Improving memory usage with SQL and PL/SQL Result Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Safeguarding SQL code
  • Miscellaneous New 12c Features

Miscellaneous New 12c Features Course Objectives Course Objectives

By the end of this Oracle Advanced PL/SQL course delegates will be able to effectively tune PL/SQL code; create subtypes; create and use collections; execute external C programs and Java programs from PL/SQL; use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result sets and apply coding standards to avoid SQL injection attacks.

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London3 2250 £2250 2019-10-30
London London3 2250 £2250 2019-10-30