Skip to main content

Description

Our MySQL 8 Administration training is designed to provide a comprehensive introduction to the administration of MySQL 8 databases. Participants will learn how to install, configure, and maintain MySQL 8 databases in a production environment. This training covers the principles of MySQL server architecture, security, backup and recovery, performance optimization, and monitoring.

Day 1:

  • Introduction to MySQL 8 Administration
  • Installing and Configuring MySQL Server
  • Understanding MySQL Server Architecture
  • Managing MySQL Users and Privileges

Day 2:

  • Securing MySQL Server and Databases
  • Managing MySQL Storage Engines
  • Backup and Recovery Strategies
  • Database Maintenance and Monitoring

Day 3:

  • Optimizing MySQL Server Performance
  • Configuring MySQL Replication
  • Scaling MySQL with Sharding
  • MySQL Server Troubleshooting

Day 4:

  • Monitoring MySQL Server and Databases
  • Advanced Topics in MySQL Administration
  • Best Practices in MySQL Administration

This training is suitable for database administrators, developers, software architects, and project managers who want to learn the fundamentals of MySQL 8 administration.

Participants should have a basic understanding of database concepts and principles, including SQL queries and data modeling. Familiarity with the Linux command line is also recommended.

By the end of this training, participants will be able to:

  • Install and configure MySQL 8
  • Understand the architecture of the MySQL server
  • Secure MySQL server and databases
  • Backup and recover MySQL databases
  • Optimize the performance of MySQL databases
  • Monitor and troubleshoot MySQL server and databases

We design, build and support digital products for clients who want to make a positive impact in their industry. Creative with technology, we develop great solutions to help our clients grow and especially by strengthening our relationships based on continuous improvement, maintenance, support and hosting services.

Follow us