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