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: 28133
  • 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'




Overview

Objectives: By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs. Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL.

Who is it for?

Delegates: This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

What will i learn?

Topics Covered: Program Blocks Variables and Constants Data Types Using SQL Statements within PL/SQL Programs Generating SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and FOR Loops Nested and Labelled Loops Using Cursors Parameterised Cursors Handling Named and UnNamed Exceptions Generating User Defined Exceptions Nested and Labelled Block Structures Scope of Variables PL/SQL Records PL/SQL Tables of R

How will i be assessed?

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

Address

StayAhead Training, London, Leeds, Birmingham, Manchester, Bristol, Edinburgh.

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