| Available 24 Hours Monday - Friday | 01344 203999
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

MySQL Training - MySQL courses

  • MySQL is the Most Commonly Used Open-Source Database
  • We are the Largest Provider of IT Technical Training Globally
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Develop Your Database Management Skills using MySQL
  • Learn How to Create a Relational Database Structure on a Web Server
  • The MySQL training course includes Material, Manuals and Exam Preparation
  • Courses delivered by World Class MySQL Training Instructors in Luxury Venues
  • Book Online or Call 01344 203999 to speak to a MySQL training advisor today
Schedule

Course Dates, Locations & Prices (Top) | View Course Info

Course Name Date Location Duration Price Book Online
Fundamentals of MySQL 01/05/2017 Limited Seats Poole
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Preston
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Teesside
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Darlington
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Buxton
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Guildford
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Doncaster
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats London
3 days £2199 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Bromley
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Peterborough
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Newcastle
3 days £2499 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Maidstone
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Edinburgh
3 days £2499 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Harrogate
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Bracknell
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Swindon
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Warrington
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Heathrow
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Corby
3 days £2799 Book now Enquire
Fundamentals of MySQL 01/05/2017 Limited Seats Glasgow
3 days £2499 Book now Enquire

Course Information (Top) | View Dates & Pricing

Overview

Introduction

Our introduction to MySQL course covers the basics of the SQL language

Who should attend this course?

Anyone who needs to access and work with a MySQL Database. 

What will I learn?

  • Using client programs to access a MySQL database
  • Creating, altering and dropping a MySQL database
  • Writing SQL statements to select data from a MySQL database
  • Writing joins and subqueries
  • Using SQL expressions
  • Using SQL aggregate functions and scalar functions
  • Inserting, updating, deleting and replacing rows
  • Creating and altering tables, indexes and views
  • Using transactions
  • Granting and revoking access privileges on tables and views
  • Exporting and importing data

Pre-requisites

There are no pre-requisites for this course.

Course Outline

  • Database concepts
  • Using the MySQL client
  • Basic Select
  • Limit, union and aggregate functions
  • Subqueries and joins
  • Date, time and other functions
  • Databases and tables
  • Indexes and views
  • Managing data
  • Access control

Exam required for Introduction to MySQL course:

1Z0-870 MySQL 5 Certified Associate Exam (1Z0-870).

FAQs
  • Course Availability

    The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.


  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am


  • What are the pre-requisites?

    There are no pre-requisites for this course.


  • What exam do I need to take?

    MySQL 5 Certified Associate Exam (1Z0-870).


  • What follow on course would you recommend?

    MySQL for Developers


  • Who is this course for?

    Anyone who needs to access and work with a MySQL Database.


  • What do the Knowledge Academy provide me with on the course

    The Knowledge Academy Courseware Book, MySQL 5 Certified Associate Exam (1Z0-870) preparation, Manual, Certificate, Experienced Instructor, Refreshments


What's Included?
  • The Knowledge Academy Courseware Book
  • MySQL 5 Certified Associate Exam (1Z0-870) preparation
  • Manual
  • Certificate
  • Experienced Instructor
  • Refreshments

best-price      customer-charter

Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews

29. Mar

APM Course Luton - Trainer Tim O'Connor

I recently attended APM Course with The Knowledge Academy and the course was delivered in Luton. I wanted to develop my understanding and knowledge of Project Management concepts and the appropriate Project Management methodologies and processes. It was great to attend the course as this enabled me to build on my practical work experiences. The training was conducted by Tim O'Connor , he was an excellent trainer and provided an enjoyable experience and welcome environment for learning. The course was delivered in a good location in Luton and course timing was great. We covered the course material , had time to go through questions and scenarios and reviewed any areas where I needed extra help. I am now more confident and have developed a stronger foundation in Project Management. Thanks to Tim for his professionalism and great teaching, I am most appreciative and glad that I attended the course and can now apply what I learned in my job. Thank you!

Read more >>

29. Mar

APM and APMP Course - Luton - Booking Process, Pre-Course Information ( Knowledge Academy Advisor - Simon Child)

Great customer service from Knowledge Academy team in particular Simon Child. I have an extremely busy schedule and needed the flexibility and options when I could attend the courses. Simon was very helpful and patient, provided the pre-course information I required and answered all my questions. Planning to come back to Knowledge Academy for another course. Thanks!

Read more >>

 Contact Us  More Courses

Send us your onsite requirements and we will
provide a tailor made course for you!

Happy Customers

Thank you to The Knowledge Academy, the course and the service were first class. TKA really did live up to their excellent reputation, I look forward to booking the MySQL for developers follow on course.
53
The course was very interesting and the instructor presented the topics clearly and in a manner which made it easier to understand. I look forward to booking the next course, thank you!
53
I had been recommended booking this course through The Knowledge Academy by a work colleague, and I am happy I did. The course covered the basics of MySQL and I now feel confident to go on a take the follow on course.
4.93