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

intermediate

Course length

2 days

Language

Course code

KT21010145

Order

Category:

Database MySQL

Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term

Language

Place

Form

Price without VAT

18. - 19. 12. 2024

Language

Place

online

Form

virtual classroom

Code of the course: KT21010145-0021

Price without VAT

15 000 Kč

Order

6. - 7. 1. 2025

Language

Place

online

Form

virtual classroom

Code of the course: KT21010145-0022

Price without VAT

15 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010145-0003

Price without VAT

15 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010145-0004

Price without VAT

15 000 Kč

Order

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.

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

News with the course

Database 7. 4. 2021

Database systems trainings

Database systems are a great potential for today's companies. There are many database products on the market that compete on performance, reliability, scalability, and many other factors. In the field of databases, we offer courses in PostgreSQL, MongoDB, MySQL.

More news