SQL training | on site

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

Introduction to SQL (2 days)

LSQ-61: Practical Introductory ANSI SQL training for developers or users who need to query and modify data stored in database servers like SQL Server, Oracle and MySQL.

"The course materials are fantastic, well prepared and you can tell that they have been well constructed and refined over time."

Collections Loans Team Leader
Vanquis Bank
Chatham

COURSE OUTLINE

This practical introduction to SQL training course is for those who need to to be competent extracting data from, and updating data in, relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). In order to master the syntax of the language, the course is highly practical in nature - attendees learn by doing. 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.

Relational Databases and SQL: An Overview

Introducing SQL

Retrieving Data with SQL: First Steps

Using WHERE to Filter Results

Joining: Getting Results from Multiple Tables

Getting Confident with SQL Joins

Using Standard SQL Functions

Working with Dates

Grouping and Summarizing Results

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

"The courseware is excellent. The notes are brilliant and the fact I can take them away with me will make life much easier when putting my learning into practice."

Business And Performance Information Manager
Wiltshire County Council
Trowbridge

"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

"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

"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

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

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

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