MySQL Training Course - Take control of MySQL database management, from installation to performance
- Price
- Duration
- Number of Hours
Each session will take place even if only one person is registered (except in cases of force majeure).
Description
MySQL is one of the most widely used relational database engines in the world. But to ensure its performance and security in a production environment, skilled administration is essential.
This training course will teach you the skills you need to install, configure, monitor and secure your MySQL databases. You will learn how to manage users, automate backups, diagnose slowdowns and ensure the integrity of your data.
Format
Remote (recorded sessions).
GOOD TO KNOW
This training course includes numerous exercises (60% practical) to enhance learning. Each session will take place even if only one person is registered (except in cases of force majeure). A preliminary interview is held between the participant and/or a company representative in order to fully assess the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment : during the training course, the trainer assesses the participants’ progress through multiple-choice questions, role-playing exercises and practical work. Participants receive a certificate of completion at the end of the training course.
objectives of this MySQL Training Course
By the end, each participant will be able to :
- Properly install and configure a MySQL server
- Manage databases, users, privileges, and schemas
- Implement a reliable backup and restore strategy
- Optimise performance (queries, indexes, server configuration)
- Diagnose and resolve common incidents
- Apply security best practices (encryption, audits, access)
Prerequisites of this MySQL Training Course
- Basic knowledge of Linux/Windows systems
- SQL concepts recommended (SELECT, INSERT, etc.)
- No prerequisites in database administration
- Because each participant has a unique background and expectations, a preliminary interview with our expert allows us to precisely identify their objectives, level and professional challenges.
This enables us to tailor the training content to ensure relevant and personalised learning.
Target Audience
Ideal for system administrators, developers, integrators or any IT professional who manages MySQL environments locally or in the cloud.
Detailed of this MySQL Training Course
Introduction and installation of MySQL
General operation, architecture, installation on Linux or Windows, initial configuration.
Database and user management
Creation of databases, tables, rights management, roles and accounts, best practices for naming and structure.
Backups and restores
Manual and automated backups (mysqldump, scripts, third-party tools), integrity checks, crash recovery.
Performance et tuning
Analysis of slow queries, use of indexes, configuration of the my.cnf file, cache, logs.
Securing the MySQL environment
Network configuration, access protection, audits, updates, strengthening of rights and encryption.
Monitoring and troubleshooting
Error logs, deadlocks, memory consumption, monitoring tools (MySQL Workbench, CLI, etc.).
The advantages of this training course
This training course :
Is practical, with hands-on experience of a MySQL server
Provides concrete examples that can be replicated in a business environment
Covers the entire lifecycle of a database: from installation to scaling up
Is suitable for teams transitioning to more robust or cloud-based architectures
Our related training courses
MariaDB + Galera Cluster Training Course
Deploy a robust, fault-tolerant architecture optimised for service continuity.
Oracle Data Guard Training Course
Get trained in the comprehensive administration of Oracle Data Guard to ensure the continuity and resilience of your critical databases.
PostgreSQL Training Course
Install, secure, and monitor your PostgreSQL databases in production.
SQL Server 2025 Training Course
Manage, secure, and optimise SQL Server in a professional environment.
Would you like to know about upcoming sessions ?
Would you like to schedule this MySQL Training Course on a specific date ? Contact us by email or by filling out the contact form.