SAGE Computing Services

Oracle 10g SQL and SQL*Plus Training

Introduction

The course is designed to provide the student with a basis for developing systems using the Oracle database. The SQL language is covered from simple to complex constructs. Guidelines are provided on writing SQL for optimum performance and ease of maintenance.

Prerequisites

No previous experience is required.

Duration

4 days

Agenda

The Relational Model
The SQL Language
SQL*Plus and iSQL*Plus
Oracle SQL Developer
More about SELECT
Substitution Variables
Using SQL*Plus for Formatting Output
Functions
Joins
Group and Analytical Functions
Set Operators
Subqueries
Data Manipulation Language
Database Objects
Constraints
Views and Sequences
Indexes
Clusters
Security
Locking and Read Consistency
More Advanced SQL

Complete Agenda

Download the complete course catalog.

Interested in booking training?

us to enquire about our course

Who are our trainers?

Penny Cookson Oracle Educator of the Year 2004 and an Oracle ACE, and Chris Muir Oracle ACE Director of the Year 2009 head our team of experienced consultants and trainers.

Back to top.

About us
Meet our staff who specialise in all things Oracle.

Consulting
We can do it for you, and we'll show you how it was done.

[ Training ]
Learn to do it for yourself with our training courses.

Presentations
Pick up some Oracle tips & tricks.

Newsletters
Like to hear from us more often?

Blogs
Our staff even blog about Oracle.

Contact us
Want to talk us?