sql training | xml training | on site

We deliver low cost SQL training in london | midlands | scotland | wales | uk wide

Database Querying with Oracle SQL (2 days)

OSQ-71: Fixed price Oracle SQL training delivered on your site at any UK location.

"The pace of the course was excellent, as I could work at my own pace."

Technical Support Administrator
ACCA
(Glasgow )

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 and can be delivered with or without the SQL*Plus query tool enhancements (please specify). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.

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

Getting Results From Multiple Tables

Using Standard Oracle Functions

Grouping, Summarizing and Ranking Results

Working with Subqueries

Working with Views

Oracle SQL and Regular Expressions

lumia development
"Very good. Met my objectives." - The Patent Office attendee

FIXED PRICE !

For on site SQL training, we charge an all inclusive, fixed price of:

£695.00 + vat per day for up to 6 attendees per course.

NO EXTRAS !

The price includes:

  • The tutor
  • All tutor expenses
  • Course laptops
  • Course software
  • Projector
  • Course notes
  • Example data
  • Extension leads

Additionally, each attendee is given a USB pen drive containing course data files.

EASY !

All you have to organise is:

  • The attendees
  • The room

EMAIL US NOW !

Yes We Can !

We can deliver our SQL training and XML training on your site anywhere in the UK:

London Birmingham West London the Midlands Manchester the East Midlands South London Glasgow Leeds North London Scotland Central London Wales the West Midlands Bath Bedford Bournemouth Bradford Brighton East London Bristol Camberley Cambridge Canary Wharf Cheltenham Coventry Derby Docklands Dorking Durham Ealing Eastbourne Eastleigh Exeter Felixstowe Feltham Gloucester Derbyshire Godalming Gravesend Guildford Halifax Harlow Harrogate Harrow Harwich Hatfield Hertford Hounslow Huddersfield Huntingdon Ipswich Kingston Leamington Spa Leicester Letchworth Lichfield Lincoln Liverpool Loughborough Maidenhead Maidstone Middlesbrough Milton Keynes Newbury Newcastle Newhaven Newmarket Newport Northampton Norwich Nottingham Oxford Peterborough Plymouth Poole Portsmouth Preston Reading Richmond the City of London Rugby Runcorn St Albans St Helens Salford Salisbury Sheffield Shrewsbury Slough Southampton Southend Southport Stafford Staines Stevenage Stockport Stoke Stourbridge Stratford Stroud Sunderland Sutton Coldfield Swindon Tamworth Telford Tilbury Uxbridge Wakefield Wandsworth Warrington Warwick Watford Wellingborough West Byfleet Weybridge Whitehaven Wigan Winchester Windsor Woking Wokingham Wolverhampton Worcester Workington Worthing Yeovil York Cardiff Swansea Wrexham Belfast Aberdeen Dundee Edinburgh Stirling Livingston Perth Inverness Cumbernauld Kirkcaldy Hamilton Stirling Grangemouth Douglas Guernsey Jersey

Contact us

For SQL training and XML training requirements in London, Midlands, Scotland, Wales and across the UK, contact:

London enquiries:

Lumia Development
2nd Floor
145-157 St John St
London
EC1V 4PY
0207 608 5009

UK-wide enquiries:

Lumia Development
Parkfield House
Park St
Stafford
ST17 4AL
01785 223253