| 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

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

Course Name Date Location Duration Price Book Online
Fundamentals of MySQL 03/04/2017 Buxton
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Guildford
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Poole
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 London
3 days £2449 Book now Enquire
Fundamentals of MySQL 03/04/2017 Doncaster
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Preston
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Teesside
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Darlington
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Bromley
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Edinburgh
3 days £2749 Book now Enquire
Fundamentals of MySQL 03/04/2017 Newcastle
3 days £2749 Book now Enquire
Fundamentals of MySQL 03/04/2017 Maidstone
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Peterborough
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Heathrow
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Corby
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Swindon
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Bracknell
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Harrogate
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Warrington
3 days £3049 Book now Enquire
Fundamentals of MySQL 03/04/2017 Oxford
3 days £3049 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
Video

We do not currently have a video for this topic

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