MySQL training | on site

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

A Foundation in SQL for MySQL (3 days)

MSQ-70: SQL training for MySQL developers or users who need to both query and modify MySQL data and create MySQL databases and tables.

"Presented really well. The tutor was patient, enthusiastic and extremely knowledgeable. He kept me awake and entertained during the day (which is often hard in courses!)."

Systems Analyst
Unite Integrated Solutions
Bristol

COURSE OUTLINE

This is a course for those who need to manipulate data by interacting with MySQL relational databases using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It is aimed at those who need to extract data from, and insert data into, existing MySQL databases to an in-depth level and who also need to create and modify MySQL databases and tables. The course is highly practical in nature and the focus throughout is on coding MySQL-based 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, 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

Inserting, Updating and Deleting in a Transaction Environment

Creating and Modifying Tables

"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

"I can honestly say that there was nothing in the course that was not useful. It was truly informative and I feel I know a lot more now."

Analysis Manager
NHS Sefton
Bootle

"Not knowing any SQL when I walked in the door I am now leaving with a good knowledge. So in my eyes, the level was perfect and at the right speed."

Commercial Systems and Processes Coordinator
NHBC
Milton Keynes

"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

"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

"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

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

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