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

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 PDF

Print Print this course