In this course, MySQL Administration, you’ll acquire essential skills for managing, optimizing, and securing MySQL databases. First, you’ll explore MySQL administration concepts, roles, and architecture. You’ll learn to install, configure, and use MySQL command-line tools and utilities. Next, you’ll focus on performance optimization, covering server tuning, query analysis, and index optimization to enhance database performance and scalability. Finally, you’ll learn to secure MySQL databases with backup and recovery strategies, user account management, and security measures. By the end of this course, you’ll have a solid understanding of MySQL administration, enabling you to effectively manage and optimize MySQL databases, ensuring high performance, security, and scalability.
Author Name: Pinal Dave
Author Description:
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Table of Contents

• Course Overview
  1min
• Exploring Core MySQL Administration
  19mins
• Optimizing, Tuning, and Monitoring Performance
  47mins
• Securing and Protecting MySQL
  31mins
• Advanced Administration Techniques and Scaling Solutions
  20mins