Show all

MySQL - advanced administration

The MySQL - Advanced Administration course introduces MySQL database server administrators to important advanced administration options. Participants will learn in detail the differences between individual storage engines, explain partitioning and access to metadata, learn to use replication as a supplement to backup for high availability, try to recover data from backups in case of problems and learn basic principles and procedures for optimizing database system performance. 
Level
Designed for participants with basic knowledge and experience
intermediate
Course length
2 days
Language
 cz  eu
Course code
KT21010145
MySQL
Category:
Do you want this tailor-made course to your company? Contact us

Courses on a specific date with a live lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
26. - 27. 6. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010145-0018
Price without VAT
15 000 Kč
15. - 16. 7. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010145-0020
Price without VAT
15 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010145-0003
Price without VAT
15 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010145-0004
Price without VAT
15 000 Kč

Target audience

MySQL server administrator

Course content

  • Storage Engines in detail - InnoDB, MyISAM, MEMORY, CSV, MERGE, FEDERATED, ARCHIVE
  • Partitioning - principle, reasons for use, creation of partitioned tables, modifications and configuration, partitioning and locking
  • Metadata - access to metadata, INFORMATION_SCHEMA, use of SHOW and DESCRIBE, mysqlshow command
  • Replication - Introduction to High Availability (HA), principle, design, procedures, use and monitoring of replication
  • Backup and recovery - scheduling, tools, backup options, replication and backup, method comparison, Log and Status file backup, data recovery options
  • Disaster Recovery (DR) - differences between HA and DR, planning, testing
  • Basics of performance optimization - EXPLAIN for analysis, table optimization, MySQL server variables, best practice 

Materials

Materials are in electronic form.

Lecturers

David Solnař
David Solnař

Freelance Consultant and Trainer Oracle, SQL Server, MySQL, .NET, WPF, ASP.NET

Do you want this tailor-made course for your company?

Contact us

Previous courses

Do you want this tailor-made course for your company?

Contact us

Why with us