Oracle Database 10g: Advanced PL/SQL

Overview


  • Design PL/SQL packages and program units that execute efficiently
  • Write code to interface with external applications and the operating system
  • Create PL/SQL applications that use collections
  • Write and tune PL/SQL code effectively to maximize performance
  • Implement a virtual private database with fine-grained access control
  • Perform code analysis to find program ambiguities, test, trace, and profile PL/SQL code

Days:

Course Code:

2

O10GPL

Pre-Requisites


  • Oracle Databas
Content


  • Introduction
  • PL/SQL Programming Concepts Review
  • Design Considerations
  • Collections
  • Advanced Interface Methods
  • PL/SQL Server Pages
  • Fine Grained Access Control
  • Performance and Tuning
  • Analyzing PL/SQL Code
Objectives


  • Design PL/SQL packages and program units that execute efficiently
  • Write code to interface with external applications and the operating system
  • Create PL/SQL applications that use collections
  • Write and tune PL/SQL code effectively to maximize performance
  • Implement a virtual private database with fine-grained access control
  • Perform code analysis to find program ambiguities, test, trace, and profile PL/SQL code
Target Audience


  • PL/SQL Developer
  • Technical Consultant
  • Database Designers
vendors Course Code Course Title Days Date
Oracle Certifications in UAE
O10GPL Oracle Database 10g: Advanced PL/SQL 2 View All Dates

This public courses are pre-scheduled throughout the year at our premises

Online, live and interactive training accessible from anywhere

We can deliver standard or customised training at any time and location that suits your employees

Guaranteed courses are confirmed to run on the specific dates shown