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

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

Training Course Outline

IT Vendor Courses Oracle Developer Training Courses

SQL Fundamentals

Course Duration: 5 days

Course Code: OSF

Course Description:

This course is designed for anyone who needs to access and work with an Oracle9i Database. 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 PL/SQL and Oracle Forms Developer

This course includes the following modules:

Course topics:

The Structure of a Relational Database
The Basic SQL and iSQL Select Statement
Selecting Data from Multiple Tables
Using Inner Joins, Outer Joins and Self Joins
Using Standard Oracle and ANSI Standard Joins
Sub-Queries
Grouping and Sorting Output
Advanced Group Functions
Character, Date and Numeric Functions
Oracle9i Datatypes and Functions
Run-Time Parameters and Variables
SQL Control Parameters
Producing Reports with SQL*Plus
Creating and Changing Tables and Views
Inline Views and Top-'N' Analysis
Constraints and Indexes
Inserting, Updating and Deleting Data
Inserting Rows into Multiple Tables
Simple and Searched CASE Expressions
Merging Data into Tables
External Tables
Basic Transaction Control
Table Locking
Controlling Access to the Database
Creation of User, Profiles and Roles
Related Data Dictionary Tables and Views

Location	Duration	RRP	Oct	Nov	Dec	Jan	Feb	Mar
Click on course date to make a booking, check availability, or find out about available discounts.
London	5 days	£1595	20 - 24	17 - 21		12 - 16	23 - 27	23 - 27

<< 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