Oracle SQL training | on site

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

Introduction to SQL for Oracle (2 days)

OSQ-72: Introductory SQL training for those who need to extract data from, and update data in, Oracle databases.

"Very good course, I appreciate the time taken to provide assistance while stuck (sometimes on the most trivial of things!) and the high quality of the materials. Would recommend to other colleagues."

Lead IT Technician
Darlington Building Society
Darlington

COURSE OUTLINE

This introduction to SQL training course is specifically for those who need to to be competent extracting data from, and updating data in, Oracle relational databases. The course is highly practical in nature and the focus throughout is on coding SQL (with Oracle variances) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.

Suggested Prerequisites

No prior SQL, Oracle or relational database experience is assumed.

An Overview of Oracle Relational Databases

Introducing SQL for Oracle

Retrieving Data with Oracle SQL: First Steps

Some Oracle Specific SQL

Using WHERE to Filter Results

Joining: Getting Results from Multiple Tables

Getting Confident with SQL Joins

Using Standard Oracle Functions

Working with Dates

Grouping and Summarizing Results

Inserting, Updating and Deleting Data

"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

"I can honestly say that there was nothing in the course that was not useful. It was truly informative and I feel I know a lot more now."

Analysis Manager
NHS Sefton
Bootle

"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

"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

"Having had very little exposure to SQL, the content is perfect for all entry levels. It's also great that after the course the material can be worked on to gain further knowledge and experience of SQL."

Senior Staff Equipment Engineer
International Rectifier Corporation
Newport

"I thoroughly enjoyed the course and the tutor was extremely helpful and easy going. Course was fun but I do feel I have learnt a lot."

Billing Administrator
Viridian Energy
Belfast

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:

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

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