1

» Introduction and installation

• Versions and types of licenses.
• Mysql, mysqlshow, myphpadmin tools.
• Configuring the server (my.cnf, sql_mode, strict mode, etc.).
• Starting and stopping.
• Installations (binary, from source code, etc.).
• Mysqladmin.
• Installing MySQL Workbench.
• Changing versions, migration.
• Hands-on work ¤Installation in Linux/Windows. Installing MySQL Workbench.

2

» Objects of a MySQL database

• Types of tables (MyISAM, MEMORY, MERGE, etc.).
• Changing the definition of a table.
• Index.
• View management.
• The INFORMATION_SCHEMA database.
• Hands-on work ¤Creating and using views. Changing the definition of a table.

3

» Connections, access rights, security

• User authentication
• Structure of "mySQL" database tables.
• Managing users and their privileges.
• Rights to views and stored workflows.
• Using SSL.
• Hands-on work ¤Complete securing of post-installation. Creating MySQL accounts. Managing privileges and passwords.

4

» Storage engines and plug-ins

• MyISAM and InnoDB storage engines.
• Architecture and configuration of InnoDB.
• Transactional operation of the InnoDB engine.
• Locking tables.
• Plug-ins: Configuration and start-up.
• Hands-on work ¤Changing the InnoDB configuration. Implementing transactions

5

» Maintaining a MySQL server

• Session status (variables, "show status" command), force-killing a session.
• Loading: LOAD DATA, myimport, SELECT INTO OUTFILE, mysqldump.
• Logs (general, errors, slow queries, etc.).
• Backup strategies.
• InnoDB Hot Backup, mysqlbinlog.
• Incremental backup and restore.
• Scheduling.
• Hands-on work ¤Activating logs. Using loading/unloading tools. Backup and restore with "mysqldump". Using the binary log