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
Bristol

COURSE OUTLINE

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

More PL/SQL

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
Trowbridge

"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
Instructus
London

"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
Maidstone

"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
Sunderland

"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
Belfast

"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
CBSA
Dudley

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

FIXED PRICE !

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.

NEED MORE ?

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!

NO EXTRAS !

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.

EASY !

All you have to organise is:

  • The attendees
  • The room

EMAIL US NOW !

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
London
EC1V 2NX
United Kingdom
enq@lumia.com