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.

"I was able to work at my own pace which was great, the instructor was very knowledgeable, I was learning something new with every module and I will be using the 'at home' set up to continue my development."

Data Architect
Proxima Support Services
Cwmbran

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

"I thoroughly enjoyed the course and the tutor was extremely helpful and easy going. Course was fun but I do feel I have learnt a lot."

Billing Administrator
Viridian Energy
Belfast

"All of the course was useful, although I have worked with SQL a lot I was always told that there's a certain way for things to be done, but never knew why. I am leaving the course with a full understanding around the reasoning of certain actions."

Operations Analyst
Vanquis Bank
Maidstone

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

"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

"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

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:

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

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