MySQL for Developers — A 5 day course

contact usEnquire about this course


This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling.


To provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.

The delegates will practise:


Client/Server Concepts

The MySQL Client Program

Data Types



Tables & Indexes

Querying for Data

SQL Expressions & Functions

Updating Data


Obtaining Database Metadata





Import & Export

User Variables & Prepared Statements

Introduction to Stored Routines

Stored Routines - Program Logic

Stored Routines - Exception Handlers & Cursors

Procedures with Parameters



Basic Optimizations

More About Indexes

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 3 December 2021, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1495 (+VAT)

Suitable For

MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.

Follow-On Courses


A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.


Together with the Introduction to MySQL course, the content of this MySQL for Developers course will teach the major topics required for the delegate to work towards achieving the MySQL 5.6 Developer Certified Professional Exam (1Z0-882).

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course, nor in the course fee.