SQL training | on site

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

Database Querying with SQL (2 days)

LSQ-60: Introductory ANSI SQL training for developers or users who only need to extract (not modify) data stored in database servers like: SQL Server, Oracle and MySQL.

"Very well presented. Insightful information that wasn't overly bogged down with a half-day history lesson about the subject at hand. Tutor was knowledgeable and interacted with the group well. I would suggest other staff attend this if needed."

Net Developer
gocompare.com
Newport

COURSE OUTLINE

This SQL training course is for those who need to extract data from relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). While attendees gain much experience designing complex SQL queries using standard functions, aggregate functions and joins, SQL action statements which facilitate data or database modification do not form part of this course. So as to master the syntax of the language, 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 training or relational database experience is assumed.

An Overview of Relational Databases

Introducing SQL

Retrieving Data with SQL: First Steps

Using WHERE to Filter Results

Learning to Join

Getting Confident with SQL Joins

Using Standard SQL Functions

Working with Dates

Grouping and Summarizing Results

"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

"Think it will be very useful for me in the long run. All the materials will be great to refer back to. Have definitely learnt new things and (probably better!) ways of doing things."

Customer Insight Analyst
ASOS.com
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 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

"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

"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

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

Contact us

For 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