How To Contact The Trainer About This Public / Open Course


Thank you for using our site to search for training courses. We list courses for over 1200 different training organisations and we hope that you will find a course that matches your individual training needs. Please get in contact with us if there is anything else that we can do for you. Also, where possible please mention us at Underoak as the source of your enquiry when speaking to any of the trainers listed on our site. It really helps us.

To send an email enquiry to the training provider: Request Information For Free

You will be sent an email with the full contact details for the trainer.

To ring us please call: +44 (0)20 7371 7103 - (Mon - Fri : 9am - 5pm)

When calling us please quote the 'Course ID' for this course:

  • Course ID: 28135
  • Trainer ID: 793

We will then ask the trainer to send you course information.


We are a small business and are keen to support the MacMillan Cancer Charity. We will donate 25 pence to them each time you submit an email enquiry through us (max £1.00 donated per person per day - excl Medical courses which we list for free). Your use of our site helps us to do this. Thank you for your help.


Please See Below For Course Information On 'PL/SQL Stored Program Units'




Overview

Objectives: By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features. They will also be able to describe and use some of the Oracle-supplied packages. Together with the PL/SQL course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Who is it for?

Delegates: This course, designed for Oracle software development personnel and database administrators who need to write new, or maintain existing, PL/SQL triggers, program units and packages.

What will i learn?

Topics Covered: Creating DML Triggers Creating ON DATABASE and ON SCHEMA Triggers Managing Triggers Creating and Managing Stored Procedures Parameters and Parameter Modes Local Subprograms Autonomous Transactions Creating and Managing Stored Functions Deterministic Functions Using Stored Functions in SQL Creating and Managing Packages Implementing Package Features and Constructs Wrapping Packages Cursor Variables Using PL/SQL Records and Tables or Associative Arra

How will i be assessed?

Practical sessions throughout the course. This course will prepare you for the relevant exam.

Address

StayAhead Training, London, Leeds.

Travel Information

http://www.stayahead.com/StayAhead_Contact_Miscelleaneous/TrainingCentres.cfm


PLEASE HELP US AT UNDEROAK TO SUPPORT MACMILLAN BY USING OUR SITE:
"Macmillan Cancer Support would like to thank Underoak for helping to improve the lives of people affected by cancer. Without your help we could not continue to provide vital practical, emotional and medical support to thousands of people affected by cancer every year. Many thanks again for your support." K. Wardle, Fundraising Manager South West London, Macmillan Cancer Support