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.

"Intense but enjoyable and very informative - I already feel much clearer and more positive about what I need to do in my SQL work."

Research Project Worker
Centre for Sustainable Energy
Bristol

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

"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

"Presented very well. I found the tutor to be knowledgeable and entertaining. He got me interested in a subject that would normally not be interesting."

Operations Manager
Instructus
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

"Superb course. The setup of tutor being able to see work in progress kept me on my toes! Would highly recommend this to our other DBA's."

SQL Server Database Administrator
The Land Registry
Plymouth

"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

"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

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:

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

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