Oracle SQL training | on site

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

A Foundation in SQL for Oracle (3 days)

OSQ-73: Introductory to intermediate level Oracle SQL training for developers or users who need to query and modify data stored in Oracle database servers.

"The course was very well presented. The tutor was great and very helpful throughout the whole course. I wouldn't have anything negative to say about the course."

Collections
Vanquis Bank
Chatham

COURSE OUTLINE

This is an introductory to intermediate level Oracle SQL training course for those who need to manipulate data by interacting with Oracle relational database servers using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It teaches core Oracle SQL and is aimed at those who need to extract data from, and insert data into, existing databases to an in-depth level. The course is highly practical in nature and the focus throughout is on coding SQL 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

Working with Subqueries

More SQL Joins

Inserting, Updating and Deleting Data

"Excellent. The course content was pitched exactly where it should have been to take account of people who had used SQL before and people who hadn't."

Finance and Operations Director
Hays Travel
Sunderland

"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

"Excellent - I am a complete beginner to SQL and have been amazed at how much I have learned in these three days and how far I am going to be able to go on this basis."

Senior Information Analyst
NHS South East London
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

"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

"Absolutely brilliant, strongly recommended to others. Really glad I was entered onto the course. Thank you for your time and help!"

Analyst
Aimia Coalition Loyalty
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:

£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:

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

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