Oracle SQL training | on site

We deliver low cost Oracle SQL training in london  midlands  bristol  scotland  wales  uk-wide

PL/SQL Programming (2 days)

OSQ-74: PL/SQL training to develop solutions with Oracle's programming objects and procedural extensions.

"It's really good to have all the notes and examples to take away because we covered a lot of ground. I really liked working through the course on individual laptops. Being able to do exercises all the time is much better than sitting through a lot of PowerPoints!"

Project Officer
Centre for Sustainable Energy


This highly practical course is aimed at Oracle database developers or power users with existing SQL experience. It teaches how to utilize Oracle's procedural extensions (variables, conditionals, looping and cursors) to develop solutions with programming objects (stored procedures, user defined functions and triggers).

Suggested Prerequisites

Prior SQL experience is assumed. Ideally (though not mandatory), attendees will have either attended, or have the skill set from our introductory or foundation level SQL courses.

PL/SQL Basics

Working with Variables and Constants

Conditions and Flow Control

Stored Procedures and Functions

Error Handling


Working with Triggers

"The courseware is excellent. The notes are brilliant and the fact I can take them away with me will make life much easier when putting my learning into practice."

Business And Performance Information Manager
Wiltshire County Council

"Presented very well. I found the tutor to be knowledgeable and entertaining. He got me interested in a subject that would normally not be interesting."

Operations Manager

"All of the course was useful, although I have worked with SQL a lot I was always told that there's a certain way for things to be done, but never knew why. I am leaving the course with a full understanding around the reasoning of certain actions."

Operations Analyst
Vanquis Bank

"Met needs perfectly - a good grounding in SQL and the tools to take away to refresh myself if need be. The material to take away is ideal."

Senior Analyst
RWE Npower

"An excellent teacher. The course gets 10 out of 10 for presentation and preparation. Excellent. I would recommend this to others."

IT Team Leader
Prestige Underwriting Services

"Excellent course, would recommend to colleagues. The tutor did an excellent job of bringing alive what would otherwise have been quite a dry subject matter!"

Senior Account Manager

Lumia development

home | about us | 100% guarantee | comments | how to order | privacy policy | terms and conditions | contact us

For superior SQL training UK-wide: EMAIL US


To deliver this Oracle SQL training on your site, we charge an all-inclusive, fixed price of:

£1195.00 + vat per day for up to 6 attendees per course.


Our unique, tried and tested, practical methodology means we can successfully get the individal pace right for up to 15 attendees per course - email us now to find out how!


The price includes:

  • The tutor
  • All tutor expenses
  • Course laptops
  • Extension leads
  • Course software
  • Projection facility
  • Course notes
  • Example data
  • Certificate of attendance

Course notes and practical work are made available online for each attendee after the course.


All you have to organise is:

  • The attendees
  • The room


Yes We Can !

We can deliver our SQL training at your venue anywhere in the UK:

Belfast Oxford Portsmouth London Bristol Lancashire Essex the North East Glasgow Northern Ireland the North West Leicester Edinburgh the East Midlands Birmingham Leeds Plymouth Scotland Sheffield York Wales South Wales Nottingham the South East Cardiff Newcastle Upon Tyne the West Midlands Aberdeen Reading Manchester the South West Preston Sunderland Bedford Middlesbrough Chester Slough Liverpool Inverness Newport Nottinghamshire Bedfordshire Berkshire Milton Keynes Wolverhampton Yorkshire Hampshire Leicestershire Coventry Southampton Northamptonshire Cambridge Hull Port Talbot Brighton Peterborough Guildford Swansea Warrington Canterbury Colchester Huntingdon Suffolk Bath Warwickshire Lincoln Bournemouth Devon Swindon Northampton Exeter Warwick Perth Kent Telford Norwich Derby Gloucester Chelmsford Winchester Cheltenham Watford Ipswich Leamington Spa Livingston Loughborough Durham the North Newton Abbot Maidstone Pontypridd the West Eastleigh the East the South Salisbury Torquay

Contact us

For Oracle SQL training requirements in London, Midlands, Bristol, Scotland, Wales and across the UK, contact:

Lumia Development
Kemp House
152 City Road
United Kingdom