Training agenda
  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)