Who should attend
Aspiring database administrators, support engineers, developers who manage their own databases and system administrators who look after MySQL servers.
Prerequisites
Basic SQL (SELECT, INSERT, UPDATE, DELETE) and basic comfort with the Linux command line. The course starts MySQL administration from first principles.
Learning outcomes
- Install, configure and secure a MySQL server for a practice environment.
- Create and manage databases, users, roles and privileges using the principle of least privilege.
- Plan and carry out logical backups and restores, and explain point-in-time recovery using binary logs.
- Set up and monitor source-replica replication and describe failover options.
- Find slow queries, read execution plans and apply indexing and configuration improvements.
- Monitor server health, maintain tables and plan routine upgrades and maintenance.
Detailed curriculum
8 modules01Introduction to MySQL and the server architecture
- The role of a database administrator and typical DBA responsibilities
- MySQL editions, versions and release cycle
- Server architecture: connection handling, parser, optimizer and storage engines
- InnoDB basics: tablespaces, redo log, undo log and buffer pool
- Data directory layout and the main files and processes
02Installation, configuration and the lab environment
- Preparing a Linux lab machine or container
- Installing MySQL from packages and starting and stopping the service
- The configuration file, option groups and dynamic system variables
- Connecting with the client, MySQL Shell and remote connections
- Upgrading and uninstalling safely in a practice environment
03Databases, tables, data types and schema administration
- Creating databases, character sets and collations
- Data types and choosing them for storage and accuracy
- Tables, primary keys, foreign keys and constraints
- Altering tables and online schema changes
- Views, stored routines and triggers from an administrator's point of view
04Users, roles, privileges and security
- Authentication, accounts and host-based access
- Privilege levels and the GRANT and REVOKE statements
- Roles and the principle of least privilege
- Password policies, encrypted connections and TLS basics
- Auditing options, hardening checklist and common security mistakes
05Backup and recovery
- Backup types: logical, physical, full and incremental
- Logical backups and restores with mysqldump
- The binary log and point-in-time recovery with mysqlbinlog
- Physical backup approaches and where third-party tools fit
- Backup scheduling, verification and a written recovery plan
06Indexing and query performance tuning
- How InnoDB uses indexes: clustered and secondary indexes
- Designing indexes and avoiding redundant ones
- Reading EXPLAIN output and execution plans
- Slow query log, performance_schema and the sys schema
- Query rewriting and typical performance anti-patterns
07Replication and high availability
- Replication concepts: source, replica and the binary log
- Setting up asynchronous replication and GTID-based replication
- Monitoring replication health, lag and common errors
- Read scaling, switchover and failover planning
- Overview of InnoDB Cluster, Group Replication and load balancing options
08Monitoring, maintenance and operations
- Key server metrics, status variables and alert thresholds
- Memory, I/O, connection and buffer pool configuration
- Table maintenance, statistics and disk space management
- Change management, patching and version upgrade planning
- Troubleshooting checklist, incident notes and DBA runbooks
How you will practise
Learn through instructor-led sessions using realistic, live applications. Then apply each concept through guided assignments on a separate hands-on practice application, with feedback to help you build practical skills and confidence.
Practical exercises and labs
- Install MySQL on a Linux lab machine and adjust key configuration settings.
- Create users and roles for an application, then test and tighten their privileges.
- Back up a database with mysqldump, delete data on purpose and recover it, including a point-in-time recovery using binary logs.
- Build a two-server replication set-up and observe how a replica catches up after a break.
- Capture slow queries, inspect their execution plans and improve them with indexes.
Capstone project
Prepare and document a small production-style MySQL environment for a sample application: installation notes, configuration choices, user and privilege design, a tested backup and recovery plan, replication, a monitoring checklist and a tuning report with before-and-after evidence.
Tools and technologies
MySQL Community Server (version to be confirmed for each batch), MySQL client and MySQL Shell, mysqldump, mysqlbinlog, a Linux virtual machine or container for the lab environment, and a text editor. Third-party backup tools are shown as examples where relevant.
Assessment approach
- Module-wise knowledge checks or short practical tasks.
- Hands-on exercise review using an agreed checklist or rubric.
- Final project demonstration and explanation of design decisions, test evidence or outputs, as applicable.
- Completion criteria, attendance requirements and any certificate conditions must be separately approved and published by TrainingRite.
Schedule and fees
Upcoming batch schedules are shared by our TrainingRite team. Please submit an enquiry and our team will contact you by email or phone with the latest schedule. TrainingRite does not publish course fees or discounts on the website. Our counselling team will share the applicable course fee and other details with you by email or phone after you submit an enquiry.
Frequently asked questions
Who should join this course?
Aspiring database administrators, support engineers, developers who manage their own databases and system administrators who look after MySQL servers.
Do I need prior experience?
Basic SQL (SELECT, INSERT, UPDATE, DELETE) and basic comfort with the Linux command line. The course starts MySQL administration from first principles.
Is the training online?
TrainingRite programmes are delivered online.
Will I get hands-on practice?
Sessions are instructor-led and use realistic applications. You then apply each concept through guided assignments on a separate practice application.
How can I enquire about fees and the next batch?
Fees and batch schedules are not published on the website. Submit the enquiry form on this page and our counselling team will share them with you by email or phone.
