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

 




SQL*Plus



This course has been integrated in to the Oracle SQL course.


Course Duration: 3 days


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:

An understanding of IT is required.


Relevant Certifications:

Oracle Internet Application Developer Rel. 6i Certified Professional


This course includes the following modules:

Course topics:

  • The Structure of a Relational Database
  • The Basic SQL Select Statement
  • Selecting Data from Multiple Tables
  • Inner Joins, Outer Joins and Self Joins
  • Sub-queries
  • Grouping and Sorting Output
  • Character, Date and Numeric Functions
  • Run-time Parameters and Variables
  • SQL*Plus Control Parameters
  • Producing Reports with SQL*Plus
  • 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

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.


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