MySQL training | on site

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

Introduction to SQL for MySQL (2 days)

MSQ-69: Introductory SQL training for those who need to extract data from and update data in MySQL databases.

"Met needs extremely well. Having used online resources with Microsoft and having had brief previous training sessions, this is the first time I feel confident in leaving having acquired new skills and knowledge."

Industry Reads Lead
First Utility
Warwick

COURSE OUTLINE

This introduction to SQL training course is specifically for those who need to to be competent extracting data from, and updating data in, MySQL relational databases. 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

Inserting, Updating and Deleting Data

"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 content of the course was self-governed to a large extent and each person got to a level at which they were comfortable."

Network Analysis Team Leader
National Grid
Sindlesham

"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

"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

"Excellent - I am a complete beginner to SQL and have been amazed at how much I have learned in these three days and how far I am going to be able to go on this basis."

Senior Information Analyst
NHS South East London
London

"Think it will be very useful for me in the long run. All the materials will be great to refer back to. Have definitely learnt new things and (probably better!) ways of doing things."

Customer Insight Analyst
ASOS.com
London

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:

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

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