MySQL - server installation and administration

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

basic

Course length

3 days

Language

Course code

KT21010144

Order

Category:

Database MySQL

Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term

Language

Place

Form

Price without VAT

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010144-0003

Price without VAT

15 500 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010144-0004

Price without VAT

15 500 Kč

Order

Target audience

MySQL server administrator

Course content

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.

Do you want this tailor-made course for your company?

News with the course

Database 7. 4. 2021

Database systems trainings

Database systems are a great potential for today's companies. There are many database products on the market that compete on performance, reliability, scalability, and many other factors. In the field of databases, we offer courses in PostgreSQL, MongoDB, MySQL.

More news