MySQL Training

We offer following authorized MySQL training courses.

MySQL 5.0 Performance Tuning (4 days)

Do you need to manage an increasing amount of data in your MySQL applications?
Do you want to monitor, diagnose problem areas and tune MySQL for optimal performance?
Do you want to write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing?
Do you want to Evaluates the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance

Then MySQL 5.0 Performance Tuning is the class for you! The MySQL 5.0 Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL.

This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.

more ...

MySQL High Availability (3 days)

Do you need to ensure that the MySQL database will experience a minimal loss of availability over time?
Do you want to increase the availability for MySQL?
Do you need to be able to present a MySQL high availability business case to the managerial positions which will make the final decision?

Then you will find MySQL High Availability is the course for you! This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL.

This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

more ...

MySQL 5.0 for DBA (5 days)

Is your MySQL database secure? Do your users have the correct privileges and access rights?
Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
Do you want to save time using features like Stored Procedures, Triggers and Views?
Do you want to utilize the new enterprise features of MySQL 5.0?

Then MySQL for DBAs is the class for you! An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!

This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new 5.0 features such as creating and using Stored Procedures, Triggers and Views.

more ...

MySQL 5.0 for Developers (5 days)

Do you want to learn how to develop database applications on MySQL?
Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
Do you want to transfer your data from one server to another?

Then MySQL for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.0

This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.

more ...

MySQL 5.0 : Upgrading and New Features (3 days)

Do you need to migrate your existing data driven applications to MySQL 5.0
Do you want to design and implement stored procedures and functions to improve productivity and provide additional security in your existing and future data driven applications?
Do you want to design and implement views to improve end-user productivity, server optimization and ensure sensitive information is not compromised?
Do you want to design and implement triggers to enforce complex business rules and ensure data integrity in your existing and future data driven applications?

Then MySQL 5.0: Upgrading and New Features is the class for you! This course is designed for Developers and Database Administrators who wish to migrate to MySQL 5.0. This course will prepare each student with the skills needed to utilize Stored Procedures, Triggers, Views, and the INFORMATION_SCHEMA metadata to enhance their productivity. Students will be exposed to the new storage engines, the ANSI SQL features and commands, the new status and configuration variables, the new precise math features and commands, and the new indexing and optimization features. In addition, this course will explain the MySQL recommended migration strategy.

more ...