MySQL Database Administration - 5 days Online Classroom
3.450,00 EUR
- 5 days
Become a confident MySQL Database Administrator with the practical skills to install, configure, secure, and maintain high-performing MySQL databases. This hands-on course is designed for IT professionals responsible for managing MySQL environments in development, testing, and production. You'll learn how to administer databases, manage users and permissions, implement backup and recovery strategies, monitor server health, optimize performance, and troubleshoot common issues. The course also covers replication, security, storage engines, and routine maintenance to help ensure database availability, reliability, and scalability. By the end of the course, you'll be equipped to manage MySQL databases efficiently while applying industry best practices for administration, security, and performance.
Key Features
Language
Course and materials are in English
Level
Beginner - Intermediate level
5 days (40 hours) live classroom
with accredited trainers
60+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations, trainings, up-to-date content and tools)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Maintain
Learn transaction management, locking mechanisms, and concurrency control to maintain data integrity and optimize performance in multi-user environments.
Utilize
Automate routine database tasks using the MySQL Event Scheduler, including maintenance, backups, and scheduled operations.
Manage
Configure and manage MySQL replication, monitor replication health, troubleshoot issues, and implement high-availability strategies.
Optimize
Optimize MySQL using server configuration, indexing, query tuning, performance monitoring, and logging to improve speed and reliability.
Course timeline
Day 1: MySQL Administration Fundamentals
Lesson 01
- Introduction to MySQL architecture, server, clients, and administration tools
- Install and use MySQL Workbench
- Retrieve database metadata using SHOW, DESCRIBE, and INFORMATION_SCHEMA
- Configure MySQL server settings, variables, and auditing
- Manage SQL modes, logs, and binary logging
Day 2: Storage Engines & Database Maintenance
Lesson 02
- Understand MySQL architecture, memory, and storage management
- Configure and optimize the InnoDB storage engine
- Explore MyISAM and other storage engines
- Perform table maintenance, optimization, and repair
Day 3: Backup, Recovery & Security
Lesson 03
- Implement backup and recovery strategies with mysqldump and Percona XtraBackup
- Import and export databases using SQL and command-line tools
- Manage users, passwords, roles, and privileges
- Configure access control and resource management
Day 4: Transactions, Performance & Automation
Lesson 04
- Manage transactions, locking, concurrency, and deadlocks
- Tune MySQL performance using configuration variables and Performance Schema
- Automate database tasks with the MySQL Event Scheduler
Day 5: Replication & High Availability
Lesson 05
- Configure MySQL replication and GTID-based replication
- Monitor replication and troubleshoot replication issues
- Implement failover and high-availability strategies
- Apply advanced performance tuning and production best practices
Who Should Enroll in this Program?
MySQL database administrators (DBAs)
Linux and system administrators
DevOps and infrastructure engineers
Database support engineers
IT operations professionals
Developers responsible for administering MySQL databases
Prerequisites
- Basic knowledge of relational databases
- Familiarity with SQL fundamentals
- Basic Linux or Windows server administration experience
- Understanding of database concepts such as tables, users, and queries is recommended
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.