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 PDF

Print Print this course