MySQL Training UK: MySQL Courses at GBdirect

MySQL Training and MySQL Certification

This section of our training site provides details of the MySQL training courses that we deliver in the UK.

MySQL Certification lays the foundation for becoming a trusted and valuable resource for your comapany and customers. MySQL Certifications are available for Developers, DBAs and for those specialising in MySQL Cluster technologies.

Courses offered in this topic are as indicated ( Open Public Course  Closed In-House Course)

• Introduction to MySQL — A 3-Day Course
• MySQL for Developers I — A 2-Day Course
• MySQL for Developers II — A 3-Day Course
• MySQL Database Administration — A 5-Day Course
• MySQL Database Administration for Experienced Database Administrators — A 3-Day Course
• MySQL Performance & Tuning — A 3-Day Course

Route Options to Certification

GBdirect offer MySQL certification courses.

Please click on the boxes below to be taken to the relevant course outline, or see below for further information.

Introduction to MySQL

The Introduction to MySQL course covers the basics of the SQL language and is designed to give delegates paractical experience in writing SQL statements using the MySQL client program and MySQL Query Browser.

Oracle Certified Associate, MySQL 5

• Exam: 1Z0-870
• Guide Price: £131 + VAT

The Certified Associate credential provides a foundation for further MySQL certification. It is inteneded for those who are relatively new to using the MySQL database server and covers basic database management system concepts as well as basic SQL.

MySQL for Developers I

The MySQL for Developers I course is designed for MySQL Developers who have a basic understanding of a MySQL database and experience using basic MySQL commands.

MySQL for Developers II

The MySQL for Developers II course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Events.

Oracle Certified Professional, MySQL 5 Developer

• Exams: 1Z0-871 & 1Z0-872 (may be taken in either order)
• Guide Price: £131 + VAT per exam

The Certified Professional Developer credential is targeted at candidates who will be developing applications that use MySQL as back-end storage.

MySQL Database Administration

This MySQL Database Administration course is for MySQL DBAs with a basic understanding of a MySQL Database and SQL commands.

MySQL Database Administration for Experienced DBAs

This MySQL Database Administration for Experienced DBAs course is for DBAs who already have substantial experience in the administration of antother relational database such as Oracle or Microsoft SQL Server. (Not MS Access).

Oracle Certified Professional, MySQL 5 Database Administrator

• Exams: 1Z0-873 & 1Z0-874 (may be taken in either order)
• Guide Price: £131 + VAT per exam

The Certified Professional DBA credential is targeted at candidates who will take the administrative role of tuning, planning, and optimizing one, or many, database servers.

MySQL Performance and Tuning

This MySQL Performance and Tuning course is designed for Database Administrators who wish to monitor and tune the performance of MySQL servers and databases.

Why MySQL Training?

When our consultants are asked to recommend an RDBMS, their stock response is to ask: “What do you want the database to do?”, “What skills have you already got?” “What database systems have you already committed resources and data to?”

We are most likely to recommend an investment in MySQL training, if you are resourcing a new project, especially one with a web focus, because supporting database-driven websites is one of the things that MySQL does best. MySQL is probably the world’s most popular website backend (on all major operating systems, Windows, Linux, Unix, Mac, etc), because it is stunningly fast at reading data, i.e. the thing that data-driven websites do most of the time. The price isn’t bad either!

MySQL is also a pretty good choice for generic database applications in small and medium sized business (SME/SMB) environments, providing power and reliability beyond the likes of MS Access, and price/performance advantages over unecessarily heavy duty RDBMSes like Oracle, DB2 and SQL Server.

MySQL is not currently the best choice for massively complex data centre operations in very large enterprises (e.g. processing hundreds of millions of records in highly interdependent systems), but it is rapidly acquiring many of the features which have previously excluded it from this domain (e.g. transactions, sub-selects, triggers, etc). Although most of these features appear in the latest MySQL development releases, we are not yet confident enough of their maturity to recommend them for the largest business-critical applications.

Why GBdirect MySQL Training?

Well, unlike most of the other training companies in this field, we and our clients have been running serious business operations on MySQL since the mid-1990s. Web sites and ecommerce applications that we’ve built using MySQL have done millions of pounds worth of business and have handled millions of page impressions per day, without drawing breath.

Like any database, MySQL has its quirks, but having worked with it over so many years and so many increasingly capable versions, we like to think that our MySQL trainers have more experience than most in coaxing it into doing the right thing.

In all the years that our consultants have been deploying and integrating MYSQL applications, they have also been developing and teaching the MySQL courses that we offer here, i.e. our MySQL training has been tried and tested in battle by real teachers, real students and real users.

Finally, we practice what we preach when it comes to open standards compliance and cross-platform portability. GBdirect MySQL training courses are taught pretty-much identically on Windows, Linux or Unix and are designed for maximum practical compliance with the ANSI/ISO SQL standards (SQL-92 and SQL-99). Indeed, the differences between MySQL on Windows and Linux is so miniscule that we can have delegates using both operating systems in the same classroom. Where MySQL differs significantly from the SQL standard or other variants of SQL, our MySQL training courses try to flag up the major problems and workarounds.

You may also be interested in the following related training courses:

• PHP and MySQL for Web Development

MySQL public courses schedule