Course code: GOC661« Back

MySQL administration

Students will acquire important information about the properties of the database system MySQL and acquire skills of effective management and maintenance. Among the important topics of the course include the setup process in Windows and Linux environments, backup and recovery strategy databases, security configuration, system monitoring and troubleshooting.

GOPAS Official Curriculum
 DateDurationCourse priceHandbook priceCourse languageLocation 
1/13/2020 5 22 500 CZK included in course price Český jazyk GOPAS Praha
 
5/25/2020 5 22 500 CZK included in course price Český jazyk GOPAS Praha
 
2/3/2020 5 22 500 CZK included in course price Český jazyk GOPAS Brno
 
10/21/2019 5 800,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
12/9/2019 5 800,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 22 500 CZK included in course price 50
Brno5 22 500 CZK included in course price 50
Bratislava5 800,00 EUR included in course price 50

User intensity level

Who is the course for

  • IT specialists who want to manage MySQL database system

After completing this course, students will be able to use new features in these areas:

  • MySQL overview
  • Install and configure MySQL on Windows
  • Install and configure MySQL on Linux
  • Configure and manage database
  • Principles and use backup and recovery
  • Database system security
  • Monitoring
  • Maintenance and automation tasks
  • Data import and export
  • Troubleshooting

Required skills

  • Basic knowledge of operating systems Microsoft Windows / Linux
  • Basic knowledge of databases

Teaching methods

Expert instruction with practical examples, computer practic

Literature

Printed presentation

Course Outline

MySQL overview

  • Properties, versions, editions, components, compared with other DB
  • Overview and tools for administrators
  • Architecture of the MySQL database system

Installation and configuration in a Windows environment

  • Preparing for installation (Windows)
  • Getting the installation media and the choice of distribution
  • Using multiple instances of MySQL on a single server
  • Installation procedure
  • Recommended configuration (CPU, Memory, etc.)

Installation and configuration in a Linux environment

  • Installing from the repository distribution
  • Installing from source package
  • Configure and start the database system

Configuration and database management

  • Overview of database structure  
  • System database  
  • Database configuration

Backing up and restoring databases

     
  • Properties backup process  
  • Types of database backups and their combinations  
  • Using Tools  
  • Database recovery scenarios and practical use

Security

  • Authentication mode of user connections  
  • Creating and managing users  
  • Types and set permissions  
  • Audit, logging and tracking users

MySQL monitoring

  • Tools for Monitoring MySQL  
  • Monitoring active connections  
  • Analysis of performance indicators  
  • Solving performance problems

Maintenance and automation tasks

  • Reason for using automation  
  • Design and creation of automated tasks  
  • Maintenance database system (defragmentation, etc.)

Data import and export

  • Overview and application of methods for data import  
  • Overview and application of methods for data export

Troubleshooting

  • Methods and procedures to identify and solve problems  
  • Troubleshooting service level  
  • Solving the concurency problems  
  • Troubleshooting the connection level
        Tištěné nebo elektronické studijní materiály GOPAS

        Price:
        included in course price
        The prices are without VAT.