Home  Courses  Custom dept.  Sales desk  Samples  Services  Help   

Phone 01636 893673
International
+44 1636 893673

Fax (0870) 051 7558
International
+44 870 051 7558

enquiries@firstalt.co.uk

Training Centres
Harwell, Oxon.
Newark, Notts

Administration office:
High Park Farm
Swinderby Road
Collingham
Nr. Newark
Notts NG23 7NZ.

OA1

Introduction to Oracle SQL

This three day course gives an introduction to ORACLE SQL*Plus and SQL, the Structured Query Language used to access a Relational Database. It is based on the ORACLE relational database but the principles learnt may be applied to databases as diverse as Informix, Microsoft SQL Server, Access and DB2.

Select here for related courses
Select here for a list of all courses

OBJECTIVES OF THE COURSE

To take students with minimal or no SQL knowkedge up to level which will allow them the productively use SQL functions.

COURSE CODE OA1 TUTORS Ken Marr email
DURATION 3 days VENUE Newark Training Centre **
PRICE £825 plus VAT * BOOKING CONTACT Mick Hosegood email
EXPERIENCE LEVEL Beginner TECHNICAL CONTACT Mick Hosegood email
*see note at bottom for special savings! for pricing for a course run especially for your organisation, please use our worksheet **Also available on your site for groups of four to ten.

COURSE DATES:

Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr May June
July
Available
onsite
only








INTENSITY: About 40% of the course is practicals, and 60% lectures.

RESOURCE: Each student will have exclusive use of a Sun workstation for the duration of the course. Each student will be provided with a full set of training notes relating to the course.

PREREQUISITES: Basic SQL knowledge would be an advantage, but no previous experience is assumed.

FOLLOW UPS: First Alternative offer an additional 2-day PL/SQL course - Oracle (Part 2).

PRACTICALS / TAKEAWAYS: Each student leaves the course with his own set of training notes for the material covered.

SOFTWARE VERSIONS: This course is based on Oracle 8.

 

TOPICS COVERED ON THE COURSE

Relational Databases
What is a Database; What is an RDBMS. Tables, Rows and Columns. Primary and Foreign Keys. Indexes. Referential Integrity.

Database Design.
The Sample Database.

Components of SQL
System Architecture. Database versus Instance. The database instance. The system global area. Process Structures. The database files. What tools are available? SQL*Plus. Server Manager. Enterprise manager. The oradim tool. Components of SQL - DML, DDL, DCL. Why use SQL. What is SQL*Plus. Starting SQL*Plus.

Data Retrieval
Select Syntax. SQL*Plus Commands. Where Clause. Order By Clause. Accepting User Input. The SQL*Plus Environment. Common Errors.

Multi-table Retrieval
Cartesian Product. Joining Tables. Creating Views.

Data Update
Insert and Update statements. Commit and Rollback. Delete and Truncate statements. Creating and using Sequences.

Functions
String Handling. Numeric Functions. Date Functions. Aggregate functions. Group By Clause. Having Clause.

Advanced Queries
Sub Selects. Grant and Revoke. Formatting Output - column braek and compute commands.

Data Definition
Create, Alter and Drop statements.

Utilities
Export and Import utilities. Spooling output data. Loading input data.

More Advanced Queries
Union, Intersect and Minus. Outer Joins. Correlated sub-queries. Statistics - Timing. Queries - using Explain Plan.

An Overview of PL/SQL
Block Structure. Variables. Program Flow. Exceptions. Procedures and Functions.

An Overview of Database Administration
System Architecture. Database Creation. Start up and Shutdown. User Management. Backup and Recovery.

 

SPECIAL SAVINGS FOR MULTIPLE AND PACKAGE BOOKINGS

Multiple Bookings
If you book more than one place on our courses on the same order, you are entitled to a 10% discount.

Package Bookings
Further discounts are available for certain packages of courses.

The complete package is available for £2100 for the 10 days of training (individually taken, the price would be £2675)

 
Fiercely inde dent
 

 

© 2006 First Alternative. All rights reserved.