Pobierz kartę szkolenia

Administering MySQL/MariaDB database server

kod szkolenia: MySQL-ADM / ENG AA 3d

poziom Średnio zaawansowany

W celu uzyskania informacji skontaktuj się z działem handlowym. W celu uzyskania informacji skontaktuj się z działem handlowym.
3 800,00 PLN 4 674,00 PLN brutto

The training is addressed both to administrators who have just begun working with MySQL/MariaDB databases, and to administrators who would like to consolidate their knowledge.

 

The training provides you with a firm foundation in MySQL/MariaDB database server architecture, configuration and administration, including but not limited to:

  • software deployment,
  • security configuration,
  • database backup and recovery,
  • master-slave replication,
  • basic query performance management techniques,
  • server monitoring and troubleshooting.

General knowledge of computer science topics and terms related to relational databases (including SQL), as well as good computer skills.

ENG

  • 3 days of work with a trainer
  • Trainer’s supervision
  • Contact with community
  • Coursebook
  • Lab environment

Training method

  • lecture
  • workshops
  1. MySQL/MariaDB database server architecture and configuration (Pluggable Storage Engines, configuration files, configuration parameters, administrative tools, Data Dictionary, Performance Schema)
  2. Specific SQL language solutions in MySQL/MariaDB (data types, indexes, transactions, partitioned tables, stored procedures and functions, triggers, batch jobs)
  3. Database server management (installation, upgrade, initialisation, starting, stopping)
  4. Security management (privileges, roles, resource limits, user accounts)
  5. InnoDB storage engine (architecture, tablespaces)
  6. Preventing data loss due to failures (logical and physical backups, binlog, Disaster Recovery)
  7. Master-Slave replication
  8. Database server monitoring (logs, diagnostic commands)
  9. Overview of query optimisation topics (query optimiser, statistics, execution plans, guidelines)