Home > Training Course Catalogue > IT Vendor Courses > Oracle Developer Training Courses > Current Page


Perpetual Solutions
Tuition House
27-37 St Georges Road, London
SW19 4DS

+44 (0)20 7620 0033
+44 (0)20 7620 0055

 




Oracle Introduction for Experienced SQL Users



View course dates


Course Duration: 2 days


Course Code: OIEU


Course Description:


This course is designed for anyone who needs to access and work with an Oracle Database.  In conjunction with the Oracle PL/SQL course, this course is suitable for delegates intending to sit the; Introduction to Oracle: SQL and PL/SQL Oracle Certified Professional examination (1Z0-001).  In conjunction with the Oracle9i SQL Advanced course, this course is suitable for delegates intending to sit the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).


Prerequisites:

Experience of using SQL with another relational database is required.


Relevant Certifications:

Oracle Internet Application Developer Rel. 6i Certified Professional


This course includes the following modules:

Course topics:

  • The Basic SQL Select Statement
  • Selecting Data from Multiple Tables
  • Inner Joins, Outer Joins and Self Joins
  • Hierarchical Queries
  • Sub-queries
  • Grouping and Sorting Output
  • CUBE and ROLLUP features
  • Character, Date and Numeric Functions
  • Run-time Parameters and Variables
  • SQL*Plus Control Parameters
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Multi-Table Inserts and Merges
  • Basic Transaction Control
  • Controlling Access to the Database
  • Related Data Dictionary Tables and Views

 

Location

Duration

RRP

Mar

Apr

May

Jun

Jul

Aug

Click on course date to make a booking, check availability, or find out about available discounts.

London

2 days

£725

 

 

11 - 12

 

20 - 21

 


<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.


Save as PDFSave as PDF

PrintPrint this course



© Perpetual Solutions Ltd 2008.   Perpetual Solutions, Tuition House, 27-37 St Georges Road, London, SW19 4DS. +44 (0)20 7620 0033 +44 (0)20 7620 0055