MySQL training | on site

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

SQL Querying for MySQL (2 days)

MSQ-67: Introduction to SQL training for developers or users who need only to extract (not modify) data from MySQL databases.

"The quality of the course was fantastic. The inclusion of notes, examples and answers before the projects was great, as were the individual projects themselves and how they progressed in difficulty as you moved your way through each module."

Commercial Business Insight Analyst
PRETTYLITTLETHING.com
Manchester

COURSE OUTLINE

This SQL training course is for those who need to extract data specifically from MySQL relational databases. While attendees gain much experience designing complex SQL queries using standard MySQL functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. The course is highly practical in nature and the focus throughout is on coding SQL (with MySQL variances) 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, MySQL or relational database experience is assumed.

An Overview of MySQL Relational Databases

Introducing SQL for MySQL

Retrieving Data with SQL: First Steps

Using WHERE to Filter Results

Getting Results From Multiple Tables

Using Standard MySQL Functions

Working with Dates

Grouping and Summarizing Results

Working with Subqueries

Working with Views

"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

"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

"Next to no experience of SQL queries before this course so I found it all useful. The most useful things for me were learning how to generate and display queries in a neat and understandable format (means I can now unpick my departmental queries more easily!)."

Accommodation Services Manager
ECA International
London

"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

"The best course I have been on in a good number of years, I feel I have learnt a lot but also know there is so much more to learn. I will continue to use the material to enhance my learning."

Senior Analyst
RWE Npower
Sunderland

"Excellent. The course content was pitched exactly where it should have been to take account of people who had used SQL before and people who hadn't."

Finance and Operations Director
Hays Travel
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 MySQL training on your site, we charge an all-inclusive, fixed price of:

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

Contact us

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