+49 (0) 30 5201 4923
info@orb-experts.com
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.
Participants should possess fundamental knowledge of any database and the SQL language.
*We customize the course outline and content to your specific needs and relevant use cases.
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.
Master new skills guided by experienced instructors from anywhere.
