SQL training | on site

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

A Foundation in SQL (3 days)

LSQ-62: Introductory to intermediate level ANSI SQL training for developers or users who need to query and modify data stored in database servers like SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL.

"To be honest, all parts were very helpful, the clear knowledge and instructions have really helped. Most importantly, I enjoyed learning all the material and feel like I can go back to work much better equipped to deal with SQL!"

Operations Development Analyst
Vanquis Bank
Chatham

COURSE OUTLINE

This is an introductory to intermediate level SQL training course for those who need to manipulate data by interacting with relational database servers like Microsoft SQL Server, Oracle, IBM DB2, MySQL and PostgreSQL using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It teaches core SQL from the ANSI/ISO standards 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 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

Working with Subqueries

More SQL Joins

Inserting, Updating and Deleting Data

"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

"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

"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

"Absolutely brilliant, strongly recommended to others. Really glad I was entered onto the course. Thank you for your time and help!"

Analyst
Aimia Coalition Loyalty
London

"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

"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

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:

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

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