System administrators who want to install and manage MySQL database service.
Course Prerequsities
Informations that required by participants before course:
Participants who will join this course should also have joined LSY103, LSY102, LSY101, MY101 courses before or mastered related subjects of these courses.
Course Goals
To learn the basic logic of MySQL,
To be able to install the MySQL service,
To connect to the MySQL service with a client and execute commands,
To restrict access to the MySQL service and make security settings,
To perform regular maintenance tasks for the MySQL service,
To examine the logs of the MySQL service,
To take backups of the MySQL service and restore from backups when necessary,
To know which metrics to examine for monitoring the MySQL service and how to retrieve these metrics.