SQL training | on site

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

Database Querying with SQL (2 days)

LSQ-60: Introductory ANSI SQL training for developers or users who only need to extract (not modify) data stored in database servers like: SQL Server, Oracle and MySQL.

"Presented very well - felt reassured that I had support if I needed it, and getting it before I realised how much I needed it!"

IT Manager
the reader
Liverpool

COURSE OUTLINE

This SQL training course is for those who need to extract data from relational database servers like Microsoft SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL using ANSI standard Structured Query Language (SQL). While attendees gain much experience designing complex SQL queries using standard functions, aggregate functions and joins, SQL action statements which facilitate data or database modification do not form part of this course. So as to master the syntax of the language, 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

"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

"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

"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

"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

"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

"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

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:

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

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