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.

"The courseware was a particular strength. I found the materials very clear and helpful and the ability to access the materials in electronic format has been very useful."

Senior Assessment Manager
University of London
London

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

"Very slick, well run and organised. Covered a lot in a short space of time, good that we have the opportunity to continue learning outside of the course. Thanks."

Performance Analyst
Leicestershire County Council
Leicester

"I had previously used SQL (pretty much blind) to query our extensive accommodation database without really knowing what I was doing. Now I'll be able to interpret the commands being used, modify them well, and also create new queries from scratch."

Accommodation Services Manager
ECA International
London

"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

"Found all the course useful. Was concerned that the mixture of experience was going to either hold some back or leave others head scratching. I am and pleased to say neither happened."

Communications Manager
Department for Work and Pensions
Newcastle Upon Tyne

"Next to no experience of SQL queries before this course so I found it all useful. The most useful things for me were learning how to generate and display queries in a neat and understandable format (means I can now unpick my departmental queries more easily!)."

Accommodation Services Manager
ECA International
London

"Think it will be very useful for me in the long run. All the materials will be great to refer back to. Have definitely learnt new things and (probably better!) ways of doing things."

Customer Insight Analyst
ASOS.com
London

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:

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

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