| Available 24 Hours Monday - Friday | +60 1800812339
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 +60 1800812339 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 05/06/17 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 03/07/17 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 07/08/17 Limited Seats Kuala Lumpur
3 days $2845 Book now Enquire
Fundamentals of MySQL 04/09/17 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 02/10/17 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 06/11/17 Limited Seats Kuala Lumpur
3 days $2845 Book now Enquire
Fundamentals of MySQL 04/12/17 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 01/01/18 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 05/02/18 Limited Seats Kuala Lumpur
3 days $2845 Book now Enquire
Fundamentals of MySQL 05/03/18 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 02/04/18 Kuala Lumpur
3 days $3165 Book now Enquire
Fundamentals of MySQL 07/05/18 Limited Seats Kuala Lumpur
3 days $2845 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

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

Happy Customers

There hasn't been any testimonials submitted to this topic