Catalogue
/
Databases
/
MySQL Database Administration

MySQL Database Administration

Dive deep into the world of MySQL Database Administration with this comprehensive course. Learn to manage, secure, and maintain your MySQL server, ensuring optimal performance and security.

What will you learn?

Dive deep into the world of MySQL Database Administration with this comprehensive course. Learn to manage, secure, and maintain your MySQL server, ensuring optimal performance and security.

‍Embark on a comprehensive journey to master MySQL Database Administration. This training will empowering you with:

• An understanding of MySQL Database operations and available tools.

• Skills to secure the MySQL Database Server against potential threats.

• Proficiency in managing user accounts and understanding the MySQL Access Privilege System.

• Techniques to maintain your database, ensuring timely backups, recoveries, and crash management.

Requirements:

Participants should possess fundamental knowledge of any database and the SQL language.

Course Outline*:

*We know each team has their own needs and specifications. That is why we can modify the training outline per need.

Introduction to MySQL Server:

  • MySQL Server Files and Scripts
  • MySQL Programs and Client Tools
  • GUI Tools for MySQL

MySQL Server Configuration:

  • mysqld Options and Server SQL Mode
  • Understanding Server System Variables: Dynamic & Status Variables
  • The Shutdown Process of MySQL Server

Securing Your MySQL Server:

  • Key Security Issues and Solutions
  • Techniques to Secure MySQL Against Attacks
  • Security-Related mysqld Options and LOAD DATA LOCAL Concerns

MySQL Access Privilege System:

  • Overview and Importance of Privileges
  • Stages of Connecting to the MySQL Server
  • Managing Access Denied Errors

Managing User Accounts in MySQL:

  • Creating, Deleting, and Modifying User Accounts
  • Limitations and Resources for Users
  • Secure Password Management

Database Maintenance and Recovery:

  • Techniques for Backup and Point-in-Time Recovery
  • Understanding Maintenance and Crash Recovery
  • The myisamchk Syntax and Options
  • Gathering Crucial Table Information

MySQL Local Settings:

  • Importance of National Characters and Sorting
  • Setting and Understanding MySQL Server Time Zone

Log Management in MySQL:

  • Different Types of MySQL Log Files: Error, General Query, Update, Binary, Slow Query
  • Best Practices for Log File Maintenance and Rotation

Running Multiple MySQL Servers:

  • Guidelines for Multiple Servers on One Machine
  • Techniques for Multiple Servers in Windows and Unix/Linux
  • Client Tools in a Multi-Server Environment

Hands-on learning with expert instructors at your location for organizations.

2.022€*
Graph Icon - Education X Webflow Template
Level:
beginner
Clock Icon - Education X Webflow Template
Duration:
14
Hours (days:
2
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.
Get Quote

Master new skills guided by experienced instructors from anywhere.

987€*
Graph Icon - Education X Webflow Template
Level:
beginner
Clock Icon - Education X Webflow Template
Duration:
14
Hours (days:
2
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.
Get Quote