Course overview
MySQL is one of the most widely used open-source relational database management systems in the world. Known for its speed, reliability, and ease of use, it powers everything from small websites to large-scale enterprise applications. For professionals working with MySQL, effective database administration is essential to ensure performance, security, and scalability.
The MySQL Database Administration course provides a comprehensive introduction to managing MySQL databases. You will learn how to install, configure, and maintain MySQL, as well as how to manage users, optimise performance, and ensure database security. The course also covers backup and recovery strategies to protect data and maintain business continuity.
Delivered by expert instructors with real-world experience in database administration, this training combines in-depth demonstrations with practical exercises. By working through realistic scenarios, you will develop the knowledge and confidence to manage MySQL databases effectively in a professional environment.
Read More
Course highlights
- Expert-led training from experienced database administrators
- Learn how to install, configure, and manage MySQL databases
- User management, permissions, and security best practices
- Performance monitoring and optimisation techniques
- Backup and recovery strategies for business continuity
- Storage engines and database architecture explained
- Practical exercises based on real-world administration tasks
- Certificate of completion to validate your skills
- Pathway to advanced MySQL, database development, or DevOps courses
Why you should attend
- MySQL is trusted by organisations worldwide, from startups to Fortune 500 companies. By attending the MySQL Database Administration course, you will:
- Gain essential DBA skills: Learn the core administration tasks required to manage MySQL effectively.
- Improve system performance: Understand how to monitor, troubleshoot, and optimise databases.
- Enhance data security: Apply best practices in user management, permissions, and data protection.
- Protect business continuity: Develop robust backup and recovery plans to safeguard critical data.
- Boost your career opportunities: MySQL administration expertise is in demand across IT, software development, and data-driven industries.
- Learn from industry experts: Receive practical guidance from trainers with years of hands-on database experience.This course gives you the knowledge to ensure that the databases you manage are secure, efficient, and reliable.
Who should attend
The MySQL Database Administration course is suitable for:
- Database administrators responsible for managing MySQL environments
- Developers or system administrators looking to expand into database management
- IT professionals supporting applications powered by MySQL
- Data engineers and DevOps professionals working with open-source databases
- Anyone seeking to build a foundation in MySQL administration
- Database Administrators, Database Developers and Technical Consultants who need to setup, administer, monitor and support MySQL databases and servers.
Read Less
Entry requirements
A working knowledge of MySQL is required. Delegates should have knowledge of relational database concepts; have knowledge of MySQL data types; be able run Queries using SQL; join tables and run basic DDL and DML statements. This knowledge can be gained by attendance on the Introduction to MySQL course.
Exam
Exams are not included as part of the course.
Learning objectives
At the end of the MySQL Database Administration course, delegates will have the knowledge to use the features available to administer, monitor and support MySQL databases and servers.
Syllabus – key points
You’ll gain a clear understanding of how MySQL operates and learn how to configure, manage and optimise it for performance, reliability and security. From mastering essential tools to implementing replication for high availability, you’ll apply skills in hands-on live labs that reflect real-world database administration challenges.
Server, clients and tools
Build a solid foundation in MySQL administration by exploring the MySQL Server architecture, supported versions and release cycles. Learn to install, configure and manage the server on Linux, connect using secure protocols, and work with essential client tools including MySQL Workbench, the mysql CLI and mysqladmin. You’ll practise using key commands and configure log files for monitoring. This course also covers managing status files, starting and stopping the server, and using the MySQL Enterprise Edition auditing plugin.
Storage engines
Discover how storage engines determine how MySQL stores, retrieves and processes data. You’ll examine the InnoDB engine in depth, including its system tablespace, file-per-table configuration, buffer pool, undo logs and shutdown options. The module also covers MyISAM’s strengths and limitations, along with specialist engines such as Archive, Memory, Blackhole, CSV, Spider and MyRocks. You’ll learn how to choose the right engine for performance and reliability, mix storage engines within a database, and maintain tables effectively with important operations.
Backup and recovery
Develop a complete backup and recovery strategy by learning the advantages and trade-offs of different backup methods. You’ll perform hot and cold backups, logical and binary backups for both InnoDB and MyISAM tables and understand what to back up beyond just the data. The module includes practical exercises using mysqldump, mysqlimport and other tools, plus import/export techniques from the command line and within SQL. You’ll also work with MySQL Enterprise Backup, test restores and troubleshoot common recovery challenges to minimise downtime.
User and privilege management
Master the process of creating, renaming, and deleting user accounts, along with secure password management and validation plugins. You’ll learn how to grant and revoke privileges at different scopes, apply resource limits to control usage, and manage roles for more streamlined permission handling. Practical exercises cover reading from the mysql.user table and ensuring secure yet functional access policies. You’ll also explore connection validation and techniques for locking down the system without affecting productivity.
Reviews
There are no reviews yet.