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.
Level
Designed for participants without knowledge and experience
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
Materials
Materials are in electronic form.
Lecturers
David Solnař
Freelance Consultant and Trainer Oracle, SQL Server, MySQL, .NET, WPF, ASP.NET
Do you want thistailor-made course for your company?