dates of our public training courses
Belfast
Birmingham
Bristol
Cardiff
Carlisle
Cork
Dublin
Edinburgh
Leeds
London
Manchester
Newcastle
Swansea
A wealthy nation that can't afford to retire
McD's highest-calorie item yet
I rarely if ever watch television, so it was an odd experience on Monday to be glued to a screen for over four hours.
The Chief Rabbi Lord Sacks
Rev Dr Giles Fraser
Thought: 18 MAY 13 Rev Rob Marshall
In every parish in which I have served I have always enjoyed working closely with head teachers and teachers in the local schools.
Thought: 17 MAY 13 Lord Harries of Pentregarth
Europe has been in the news all week, again.
Thought: 16 MAY 13 Canon Angela Tilby
In spite of the wintry weather the wedding season is upon us.
Professor Mona Siddiqui
Thought: 14 MAY 13 The Chief Rabbi Lord Sacks
Tonight we begin Shavuot, the Jewish festival in which we recall the revelation at Mount Sinai in the days of Moses, thirty three centuries ago, when our ancestors made a covenant with God.
Rev Dr Giles Fraser
Thought: 11 MAY 13 Rev Rob Marshall
This afternoon's FA Cup Final is not, of course, the main football prospect of the weekend.
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
About the security content of QuickTime 7.7.4
Learn about the security content of QuickTime 7.7.4.
OS X Server: Configuring clients to use SSL for Open Directory binding
This article explains how to configure an Open Directory server and OS X client to use SSL encryption for Open Directory binding.
Xsan: Compatibility of Fibre Channel storage devices
This article lists the Fibre Channel storage hardware compatible with Xsan and OS X.
iTunes: About the "A secure network connection could not be established" alert
If you are unable to sign in or purchase content from the iTunes Store, you may see the following alert: "iTunes could not connect to the iTunes Store. A secure network connection could not be established. Make sure SSL 3.0 or TLS 1.0 is enabled in the Internet Options control panel, then try again."
MacBook Air (Late 2010): Installing Windows 7 drivers
Learn how to install Windows 7 drivers on your MacBook Air (11-inch, Late 2010) or MacBook Air (13-inch, Late 2010) computer.
Xsan: Compatibility of SAN clients with Xsan and StorNext controllers
Learn which versions of StorNext can be used in the same SAN with Xsan controllers, and which versions of Xsan can be used in the same SAN with StorNext controllers.
Printing to an AirPort Extreme / Express Base Station or Time Capsule from Windows XP
Learn about printing to an AirPort Extreme / Express Base Station or Time Capsule from Microsoft Windows XP.
Xsan 3: Invisible "__defragtmp" files are created after using snfsdefrag
When defragmenting a file with snfsdefrag, an invisible "__defragtmp" file may be created which cannot be deleted. This issue may occur when the following are true: The defragmented file's name contains precomposed Unicode characters, such as letters with diacritical marks (an accent, grave, or umlaut). snfsdefrag is run by root. snfsdefrag is run when the current working directory is on an Xsan volume, or snfsdefrag's recursive option (-r) is used.
Recovering a forgotten iTunes Store account name
You can easily recover your iTunes Store account name if you have forgotten it.
Wi-Fi: Guest network clients can communicate with each other, but cannot connect to the Internet
Computers and devices (Wi-Fi clients) that are connected to a Guest network may be able to communicate with each other, but cannot connect to the Internet. This can happen if the AirPort base station providing the Guest network is configured to use a DNS server on the local network.
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
Oracle PLSQL I
Programming Course
SynopsisPLSQL 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
Suggested Further Course(s)
PLSQL II
Forms 10g
Reports 10g
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