| Available 24 Hours Monday - Friday | 01344208452
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 07/08/2017 Limited Seats Leicester
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Buxton
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Doncaster
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Chorley
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Milton Keynes
3 days £2499 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Wrexham
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats London
3 days £2199 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Poole
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Chatham
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Warrington
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Colchester
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Wakefield
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Heathrow
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Lincoln
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats York
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Maidstone
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Dereham
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Stoke-on-Trent
3 days £2799 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Newcastle
3 days £2499 Book now Enquire
Fundamentals of MySQL 07/08/2017 Limited Seats Watford
3 days £2799 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
 Contact Us  More Courses

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!
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.