DB-302
MySQL Administration
Cost: $1000
Duration: 5
Day
s
Skill Level: Intermediate
Course Overview
This course will help trainees to acquire the necessary skills to administer and operate MySQL on a daily basis.
Learning Outcomes
At the end of the course, trainees will be able to:
- Perform performance monitoring and tuning
- Configure database backups and restoration
- Configure high availability and clustered setups
- Implement database security
- Implement database upgrades
Suitable For
Current and aspiring MySQL administrators
Course Outline
MySQL Administration
- Database Backups and Restoration
- Logical Backups and Restoration using mysqldump
- Binlog Backups and Restoration using mariabackup
- Performance Monitoring and Tuning
- Indexes
- Denormalization
- Query Explain
- performance_schema
- Server parameters
- CPU, Memory, and Disk
- OS Parameters
- Scaling and High Availability
- Master-Slave
- Multi-Master using Galera
- MySQL Router
- Database Security
- RBAC
- SQL Injection
- Prepared Statements
- Database Migration and Upgrades
- Strategies: Lower to Higher Version
- Strategies: Lift and Shift
Hardware Requirements
- Laptop or Computer
- Intel i3 or greater
- 8GB RAM Minimum
- 100 GB Disk Space
Software Requirements
- Linux or Windows
- Docker Desktop
EXCLUSIVE TRAINING FOR YOU COMPANY
AT YOUR PREFERRED SCHEDULE
Tailored to the needs of your organization, we also offer cadetship
programs which include a series of our standardized O&B Academy courses.
Get a quote