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: 99454
  • 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 'SQL'




Overview

Objectives: By the end of this course, the delegate will be able to: Describe the basic structure of a relational database Use the command line features of SQL*Plus Use SQL Developer to access an Oracle Database 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 Use the Data Dictionary

Who is it for?

Delegates: This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for anyone intending to sit the Oracle Database 11g: SQL Fundamentals (IZ0-051) examination. Together with the Oracle SQL Advanced course, this course is suitable for delegates intending to sit the following exams: Introduction to Oracle9i: SQL Oracle Certified Professional (1Z0-007) Oracle Database SQL Expert (IZ0-047)

What will i learn?

Topics Covered: The Structure of a Relational Database Using SQL*Plus Using SQL Developer The Basic SQL Select Statement Selecting Data from Multiple Tables Inner Joins, Outer Joins and Self Joins Grouping and Sorting Output Sub-queries and In-line Views Character, Date and Numeric Functions SQL*Plus Run-time Parameters and Variables Creating and Changing Tables and Views Constraints and Indexes Inserting, Updating and Deleting Data Basic Transaction Control Controlling Access to the Database Related Data Dictionary Tables and Views

How will i be assessed?

Practical sessions throughout the course. This course helps prepare delegates for the following Oracle exam - Introduction to Oracle9i: SQL Oracle Certified Professional (1Z0-007) Oracle Database SQL Expert (IZ0-047)

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