Oracle SQL training | on site

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

Database Querying with Oracle SQL (2 days)

OSQ-71: Introduction to SQL training for developers or users who need only to extract (not modify) data from Oracle databases

"Having an environment in which we could freely play with SQL was great. Being able to go over areas where I was lacking understanding and being able to work at 'my' pace was really helpful."

ICT Officer
Norfolk County Council
Norwich

COURSE OUTLINE

This SQL training course is for anyone who needs to extract data from Oracle relational databases. While attendees gain much experience designing complex SQL queries using standard Oracle functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. 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

"The content of the course was self-governed to a large extent and each person got to a level at which they were comfortable."

Network Analysis Team Leader
National Grid
Sindlesham

"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

"I like how I was able to work at my own pace but also felt supported when required. I like how the modules are available to me after the course to complete so I can continue to learn."

Senior Analyst
RWE Npower
Sunderland

"The overall course was great, I'm pleased I got to come back for a second time to further the knowledge I picked up on the first course. The course material was really useful and the course teacher was really helpful with any problems!! Great course!!"

Analytics Analyst
LV
Bournemouth

"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

"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

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:

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

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