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: 28106
  • 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 'Oracle Fundamentals'




Overview

Objectives: By the end of this course, the delegate will be able to: Select data from an Oracle Database using SQL*Plus and SQL Developer Create SQL statements to select data from an Oracle Database Use SQL run time parameters Use aggregate functions Use numeric, character, date, conversion and miscellaneous functions Use subqueries Create and alter tables, indexes and views Create, update and delete records Manage sequences and synonymns Access the Data Dictionary Describe the Basic Structure of a PL/SQL Block Use PL/SQL IF Statements, Expressions and LOOP Constructs Declare and use Cursors Use record types and PL/SQL Tables Handle Errors and Exceptions within PL/SQL Scripts

Who is it for?

Delegates: This course is designed primarily for administrators, developers and support personnel who need to access and work with an Oracle Database.

What will i learn?

Topics Covered: The Structure of a Relational Database Using SQL*Plus and SQL Developer The Basic SQL Select Statement Selecting Data from Multiple Tables Grouping and Sorting Output Character, Date and Numeric Functions SQL*Plus Run-time Parameters and Variables Creating and Changing Tables, Indexes and Views Inserting, Updating and Deleting Data Related Data Dictionary Tables and Views The Structure of a PL/SQL Block Declaring and Using Variables and Constants Using

How will i be assessed?

Practical sessions throughout the course.

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