Company Information
Public Courses
Check out the
dates of our public training courses
London
Edinburgh
Leeds
Belfast
Manchester
Bristol
Dublin
Cardiff
Birmingham
Newcastle
Swansea
dates of our public training courses
London
Edinburgh
Leeds
Belfast
Manchester
Bristol
Dublin
Cardiff
Birmingham
Newcastle
Swansea
Data Dog - Training your Data
Oracle
Microsoft
Java Training
Management
Information
On-Site Training - Have wheels will travel !!
SQL Courses
Essential SQL
10g SQL
9i SQL
SQL for Users
Query Builder
Using SQL with SQL Developer
SQL Developer Part I
SQL Developer Part II
Discoverer Courses
Discoverer 11g Desktop
Discoverer 10g Desktop
Discoverer 10g Plus
Discoverer 9i Desktop
Discoverer 9iAS
Discoverer 4i Desktop
Discoverer 3.1 User
Discoverer Administrator 11g
Discoverer Administrator 10g
Discoverer Administrator 9i
Discoverer Administrator 4i
Discoverer Administrator 3.1
Developer Courses
PLSQL I
PLSQL II
PLSQL 10g
PLSQL 9i
9i New Features for Developers
8i New Features for Developers
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports 10g
Reports 9i
Reports 6i
Reports 6i New Features
Oracle Graphics
Database Administration
10g New Features for DBAs
10g DBA I
10g DBA II
9i New Features for DBAs
9i DBA I
9i DBA II
9i Database Tuning
9i Network Administration
9iAS Basic Administration
8i New Features for DBAs
8i DBA I
8i DBA II
8i Database Tuning
8i Network Administration
Essential SQL
10g SQL
9i SQL
SQL for Users
Query Builder
Using SQL with SQL Developer
SQL Developer Part I
SQL Developer Part II
Discoverer Courses
Discoverer 11g Desktop
Discoverer 10g Desktop
Discoverer 10g Plus
Discoverer 9i Desktop
Discoverer 9iAS
Discoverer 4i Desktop
Discoverer 3.1 User
Discoverer Administrator 11g
Discoverer Administrator 10g
Discoverer Administrator 9i
Discoverer Administrator 4i
Discoverer Administrator 3.1
Developer Courses
PLSQL I
PLSQL II
PLSQL 10g
PLSQL 9i
9i New Features for Developers
8i New Features for Developers
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports 10g
Reports 9i
Reports 6i
Reports 6i New Features
Oracle Graphics
Database Administration
10g New Features for DBAs
10g DBA I
10g DBA II
9i New Features for DBAs
9i DBA I
9i DBA II
9i Database Tuning
9i Network Administration
9iAS Basic Administration
8i New Features for DBAs
8i DBA I
8i DBA II
8i Database Tuning
8i Network Administration
Contents
This intensive hands on
PLSQL I training course is broken down into twelve sections and includes the following aspects:
Basic structure of PLSQL program
Oracle Explicit and Implicit Cursors
Oracle PLSQL Database Objects - Functions, Procedures, Packages and Triggers
Using PLSQL to communicate with the Operating System
Advanced Techniques such as PLSQL %rowtype
Using PLSQL to create Oracle Dynamic SQL
Exercises
There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include:
Simple PLSQL processing - Inserting records
Using For, While, Explicit and Implicit Loops in Oracle PLSQL
Creating Database Objects such as Triggers, Functions, Procedures and Packages
Using PLSQL to read and write ascii files
Simple Dynamic PLSQL using Execute Immediate
Duration
Three Days
This intensive hands on
PLSQL I training course is broken down into twelve sections and includes the following aspects:
Basic structure of PLSQL program
Oracle Explicit and Implicit Cursors
Oracle PLSQL Database Objects - Functions, Procedures, Packages and Triggers
Using PLSQL to communicate with the Operating System
Advanced Techniques such as PLSQL %rowtype
Using PLSQL to create Oracle Dynamic SQL
Exercises
There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include:
Simple PLSQL processing - Inserting records
Using For, While, Explicit and Implicit Loops in Oracle PLSQL
Creating Database Objects such as Triggers, Functions, Procedures and Packages
Using PLSQL to read and write ascii files
Simple Dynamic PLSQL using Execute Immediate
Duration
Three Days
Synopsis
PLSQL language is Oracle's versatile procedural extension to SQL, which capitalises on SQL's functionality and can increase database efficiency, effectiveness, scalability, portability and security.
This is part one of a two part course and takes Developers up to a stage where they are able to create Database objects such as triggers and packages, as well as work with PLSQL in Forms and Reports.
Course Preview
The following options give examples of Course content ...
Pre-Requisite Course(s)
Essential SQL
Next Course(s)
PLSQL II
Forms 10g
Reports 10g
PLSQL language is Oracle's versatile procedural extension to SQL, which capitalises on SQL's functionality and can increase database efficiency, effectiveness, scalability, portability and security.
This is part one of a two part course and takes Developers up to a stage where they are able to create Database objects such as triggers and packages, as well as work with PLSQL in Forms and Reports.
Course Preview
The following options give examples of Course content ...
Pre-Requisite Course(s)
Essential SQL
Next Course(s)
PLSQL II
Forms 10g
Reports 10g