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 pace was very appropriate. The tutor sensed when we wanted to get stuck in and when we wanted to discuss something and let us run with either when they arose."

Commercial Business Insight Analyst
PRETTYLITTLETHING.com
Manchester

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

"Not knowing any SQL when I walked in the door I am now leaving with a good knowledge. So in my eyes, the level was perfect and at the right speed."

Commercial Systems and Processes Coordinator
NHBC
Milton Keynes

"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

"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

"The best course I have been on in a good number of years, I feel I have learnt a lot but also know there is so much more to learn. I will continue to use the material to enhance my learning."

Senior Analyst
RWE Npower
Sunderland

"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

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:

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