Company Information
QRCode for Mobile Website
Our Blog
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
Advanced 11g SQL
10g SQL
9i SQL
SQL for Users Part I
SQL for Users Part II
SQL for Users Part III
Query Builder
Using SQL with SQL Developer
SQL Developer Part I
SQL Developer Part II
Discoverer Courses
Discoverer 11g Desktop
Discoverer 11g Plus
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 11g
Advanced PLSQL 11g
PLSQL 10g
Advanced PLSQL 10g
PLSQL 9i
Forms 11g
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports 11g
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
Advanced 11g SQL
10g SQL
9i SQL
SQL for Users Part I
SQL for Users Part II
SQL for Users Part III
Query Builder
Using SQL with SQL Developer
SQL Developer Part I
SQL Developer Part II
Discoverer Courses
Discoverer 11g Desktop
Discoverer 11g Plus
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 11g
Advanced PLSQL 11g
PLSQL 10g
Advanced PLSQL 10g
PLSQL 9i
Forms 11g
Forms 10g
Forms 9i
Forms 6i
Forms 6i New Features
Reports 11g
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 training course is broken down into eight sections and includes the following aspects of Oracle 9i:
CASE function in PL/SQL
Extensions to Group by clause
Timestamp Data Type
New Built in Functions Nullif, Coalesce
Merge statements
Multiple table inserts
Utl_file enhancements
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:
Creation and use of new datatypes
Usage of Merge and Multiple table insert functions
Usage of CASE and other new PL/SQL functions
Course Duration
One day
This intensive hands on training course is broken down into eight sections and includes the following aspects of Oracle 9i:
CASE function in PL/SQL
Extensions to Group by clause
Timestamp Data Type
New Built in Functions Nullif, Coalesce
Merge statements
Multiple table inserts
Utl_file enhancements
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:
Creation and use of new datatypes
Usage of Merge and Multiple table insert functions
Usage of CASE and other new PL/SQL functions
Course Duration
One day
Synopsis
The Oracle 9i database is the most complete and comprehensive platform for building and deploying internet and enterprise applications.
The 9i database has many new features that offer improved performance, functionality and reliability to developers building applications.
It is essential for Developers to understand these new features in order to take advantage of the full power of 9i.
Course Preview
Pre-Requisite Course(s)
Introduction to SQL
PLSQL I
8i New Features for Developers
Suggested Further Course(s)
10g DBA I
This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.
On completion all delegates receive a certificate.
On Site or Off Site ?
On Site
All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.
Off Site
If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).
Weekday or Weekend ?
This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.
Standard or Customised ?
If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).
Contact Details
Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com
The Oracle 9i database is the most complete and comprehensive platform for building and deploying internet and enterprise applications.
The 9i database has many new features that offer improved performance, functionality and reliability to developers building applications.
It is essential for Developers to understand these new features in order to take advantage of the full power of 9i.
Course Preview
The following options give examples of Course content ...
Pre-Requisite Course(s)
Introduction to SQL
PLSQL I
8i New Features for Developers
Suggested Further Course(s)
10g DBA I
This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.
On completion all delegates receive a certificate.
On Site or Off Site ?
On Site
All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.
Off Site
If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).
Weekday or Weekend ?
This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.
Standard or Customised ?
If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).
Contact Details
Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com