In a business world today an operation without a database is simply unthinkable. All companies have a need for systematic operations tracking using modern IT systems, which almos always are using some kind of a database. Knowledge about the most popular open source database, MySQL, is some of the highest expectations from a developer of both desktop applications, dynamic websites or services of all kinds.

One of the great advantages of MySQL is reflected in the fact that there are versions ready for all major (and most of minor) operating systems, and it is fully GPL licensed. And above of it all, MySQL is a very powerful database management, capable of working in a clusters and serving for the worlds most demanding projects in the World. With MySQL's unique flexibility and power features - you can't go wrong.
 

Objectives

Identify existing knowledge and skills needed to install and configure MySQL. We will introduce and applications that emerged from the main MySQL project, such as MariaDB or PerconaServer. After that, we will introduce various advanced functionality of the new generation of MySQL that make it one of the most databases today - replication, scaling, clustering. Adopt you technical details about the internal design of MySQL that is necessary for acquiring advanced skills such as optimization, to achieve high availability and proper installation of the cluster. We will end up with advanced knowledge about data security.
 

Target audience

Education is intended for IT professionals who already work with MySQL and would like to gain much deeper, advanced knowledge about the world's most popular open source database. Let us teach you how to become your company's MySQL guru.

• MySQL Architecture
• Finding Bottlenecks: Benchmarking and Profiling
• Schema Optimization and Indexing
• Query Performance Optimization
• Advanced MySQL Features
• Optimizing Server Settings
• Operating System and Hardware Optimization
• Replication
• Scaling and High Availability
• Application-Level Optimization
• Backup and Recovery
• Security
• MySQL Server Status
• Tools for High Performance

• This seminar is a logical continuation of the seminar MySQL Essentials.

• Bernard Toplak