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.

"Was very refreshing to do a course that was nearly all practical. Learnt much more than any previous courses and have the ability and tools to go away and learn further."

ICT Officer
Supreme Court of the United Kingdom
London

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

"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

"The courseware is excellent. The notes are brilliant and the fact I can take them away with me will make life much easier when putting my learning into practice."

Business And Performance Information Manager
Wiltshire County Council
Trowbridge

"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

"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

"Having had very little exposure to SQL, the content is perfect for all entry levels. It's also great that after the course the material can be worked on to gain further knowledge and experience of SQL."

Senior Staff Equipment Engineer
International Rectifier Corporation
Newport

"Absolutely brilliant, strongly recommended to others. Really glad I was entered onto the course. Thank you for your time and help!"

Analyst
Aimia Coalition Loyalty
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:

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