MySQL - server installation and administration (EN)

Description

MySQL Course - Server installation and administration provides important information about the features of the MySQL database system and acquires skills of effective administration and maintenance. Important course topics include the installation and configuration process in Windows and Linux, database backup and recovery strategies, security configuration, system monitoring, and troubleshooting. 

Target

Contents

• Introduction to the MySQL database system - history, edition, comparison with other DB systems, advantages and disadvantages
• MySQL architecture - client / server, memory and storage usage, HW and SW requirements, plug-in interface
• Installation - download / obtain installation media, installation process, multiple instances on the server, differences in Windows installation vs. Linux
• Initial server configuration - configuration, Dynamic Server Variables, SQL modes, Log files, Status files
• MySQL clients - overview, mysql client, mysqladmin, third-party APIs
• Databases - structure, administration, database configuration, system databases
• Working with storage - MyISAM, InnoDB and MEMORY Storage Engines, differences and choosing the right one
• Table maintenance - maintenance, SQL statements, tools, differences according to the repository
• User accounts - create, manage, delete, set permissions, log users
• Server security - access levels, security risks, client access control
• Export and import - export and import of data, use of SQL scripts
• Database backup and recovery - backup planning, tools, RAW vs. Logical backup, log file backup, various backup methods, data recovery 

Study Materials

Followups