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.

"Presented very well. The tutor was extremely friendly and engaging. He obviously has an excellent knowledge of the subject matter. He created a relaxed learning environment, where people weren't afraid to ask for help if needed."

Senior Pricing Analyst
Admiral Insurance
Cardiff

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

"I like how I was able to work at my own pace but also felt supported when required. I like how the modules are available to me after the course to complete so I can continue to learn."

Senior Analyst
RWE Npower
Sunderland

"Met needs perfectly - a good grounding in SQL and the tools to take away to refresh myself if need be. The material to take away is ideal."

Senior Analyst
RWE Npower
Sunderland

"Found all the course useful. Was concerned that the mixture of experience was going to either hold some back or leave others head scratching. I am and pleased to say neither happened."

Communications Manager
Department for Work and Pensions
Newcastle Upon Tyne

"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

"An excellent teacher. The course gets 10 out of 10 for presentation and preparation. Excellent. I would recommend this to others."

IT Team Leader
Prestige Underwriting Services
Belfast

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:

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

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