Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

MySQL - server installation and administration (EN)

David Solnař

Kurzem Vás provede David Solnař

Základní info

Popis kurzu

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. 

Určeno pro

MySQL server administrator

Obsah kurzu


  • 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 

Studijní materiály

Materials are in electronic form.

Návaznosti

MySQL - advanced administration

MySQL - server installation and administration (EN)

Vybraný termín:

30.8.2021 –  1.9.2021  ONLINE

Cena
15 500 Kč + 21% DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je osm a devět ? Součet zapište číslicemi.