MySQL 8.0 for Database Administrators Course in UK
Build expert skills in tuning, backup & replication
40 hours of training program
In-depth course structure with 14 modules
Position yourself for high-demand DBA roles
Learn from Oracle-certified instructors
Includes hands-on labs and projects
Earn globally respected certification in MySQL 8.0
Access flexible sessions and batches for a busy schedule
Hassle-free payment options in instalments
4.9/54.9/5Overview
What our training includes:
- Easily install and upgrade MySQL on Linux systems
- Use Docker to create MySQL test environments quickly
- Set up a reliable InnoDB Cluster using MySQL Shell and Router
- Track system performance using Performance Schema and MySQL Enterprise Monitor
- Strengthen security with SSL, encryption and firewall rules
- Automate database backups with tools like mysqldump, mysqlpump and Enterprise Backup
- Improve query performance using index data and the Query Analyser
Upcoming sessions
Curriculum
Introduction to MySQL
MySQL Powers the Web
Practice 1-1: Course Environment
Installing and Upgrading MySQL
Linux MySQL Server Installation Directories
Starting and Stopping MySQL
Practice 2-1: Installing MySQL
Practice 2-2: Connecting to MySQL
Practice 2-3: Configuring the MySQL Service
Practice 2-4: Upgrading MySQL
Practice 2-5: Deploying MySQL with Docker
Understanding MySQL Architecture
Storage Layer
What Is a Data Dictionary?
Redo Logs
Practice 3-1: Configuring Tablespaces
Practice 3-2: Configuring the Buffer Pool
Configuring MySQL
Server System Variables
Practice 4-1: Modifying a Setting by Using Command-Line Arguments
Practice 4-2: Modifying the Configuration File
Practice 4-3: Changing Dynamic Settings
Practice 4-4: Persisting Global Variables
Practice 4-5: Configuring the Client
Practice 4-6: Running Multiple MySQL Servers on the Same Host with systemd
Monitoring MySQL
Status Variables
MySQL Enterprise Audit
MySQL Enterprise Monitor
Practice 5-1: Configuring the Slow Query Log
Practice 5-2: Using Performance Schema
Practice 5-3: Installing MySQL Enterprise Monitor
Practice 5-4: Monitoring Server Activity
Managing MySQL Users
Setting the Account Password
Authorization
Using Role Privileges
Practice 6-1: Quiz—User Management
Practice 6-2: Creating Users and Roles
Practice 6-3: Granting Permissions
Securing MySQL
Preventing MySQL Password Security Risks
Keyring
MySQL Enterprise Firewall
Practice 7-1: Quiz – Securing MySQL
Practice 7-2: Enabling SSL for Secure Connections
Practice 7-3: Encrypting MySQL Data-at-Rest
Practice 7-4: Configuring MySQL Enterprise Firewall
Maintaining a Stable System
Capacity Planning
Identifying the Causes of Server Slowdowns
Practice 8-1: Quiz—Maintaining a Stable System
Practice 8-2: Identifying the Cause of Slow Performance
Optimizing Query Performance
Index Statistics
Practice 9-1: Improving Query Performance with Indexes
Practice 9-2: Using MySQL Query Analyzer
Choosing a Backup Strategy
Backup Techniques
Practice 10-1: Quiz—Backup Strategies
Performing Backups
mysqldump and mysqlpump
Physical InnoDB Backups: Overview
Overview of practices for lesson 11
Practice 11-1: Backing Up with MySQL Enterprise Backup
Practice 11-2: Backing Up with mysqldump and mysqlpump
Practice 11-3: Restoring the Database Using the Binary Log
Administering a Replication Topology
Monitoring Replication
Troubleshooting MySQL Replication
Practice 12-1: Monitoring Replication with MySQL Enterprise Monitor
Practice 12-2: Troubleshooting Replication Errors
Practice 12-3: Performing a Replication Failover
Achieving High Availability with MySQL InnoDB Cluster
MySQL Shell (mysqlsh)
Managing Sandbox Instances
Practice 13-1: Creating MySQL InnoDB Cluster
Practice 13-2: Deploying MySQL Router and Testing the Cluster
Practice 13-3: Testing High Availability
Conclusion
Meet your Trainer
Our Trainers
Learners Point has a reputation for high-quality training that makes a difference in people's lives. We undertake a practical and innovative approach to working closely with businesses to improve their workforce. Our expertise is wide-ranging with ample support from our expert trainers who are globally recognized and hold a diverse set of experiences in their field of expertise. We are proud of our instructors who take ownership of our distinctive and comprehensive training methodologies, help our students imbibe those with ease, and accomplish gracefully.
We at Learners Point believe in encouraging our students to embark upon a journey of lifelong learning and self-development, with the aid of our comprehensive and distinctive courses tailored to current market trends. The manifestation of our career-oriented approach is what we assure through a pleasant professional enriched environment with cutting-edge technology, and an outstanding while highly acknowledged training staff that uses up-to-date methodologies and quality course material. With our aim to mold professionals to be future leaders, our industry expert trainers provide the best in town mentorship to our students while endowing them with the thirst for knowledge and inspiring them to strive for professional and human excellence.
Learning Outcomes
After the course is completed, you will be able to:
1
Set up MySQL on Linux and manage services to ensure smooth startups and shutdowns
2
Upgrade MySQL servers with minimal downtime using binary logs and version-safe methods
3
Use Performance Schema and MySQL Enterprise Monitor to detect slowdowns early
4
Secure your data with SSL, at-rest encryption and the MySQL Enterprise Firewall to guard against modern threats
5
Automate both logical and physical backups with mysqldump, mysqlpump and Enterprise Backup tools
6
Boost query speed by using index data and Query Analysis to reduce delays in application performance
Learners Point Certificate
Earn a Course Completion Certificate, an official Learners Point credential that confirms that you have successfully completed a course with us.
Prerequisites
To enrol in this MySQL 8.0 for Database Administrators Course in the UK, candidates must fulfil these eligibility requirements:
- A basic grasp of how databases work and standard database terms
- Familiarity with relational database systems (RDBMS)
- Some experience using command-line tools (CLI)
- Basic skills in SQL for data manipulation (SELECT, UPDATE, INSERT, DELETE)
- An understanding of basic computer operations, including how to run programs and work with file systems
Overall ratings by our students
Related courses
Learn now, pay later
Dive into your course now and pay in installments
Frequently asked questions
The MySQL 8.0 for Database Administrators Course in the UK offers a hands-on learning experience designed to help individuals with the skills to manage, secure and optimise MySQL databases in real-world environments. Our course is suited to meet the growing demand for skilled MySQL professionals in the UK's tech and enterprise landscape.
The MySQL 8.0 for Database Administrators Course in the UK covers a broad range of core focus areas that reflect the practical demands of today's data-driven organisations. These core areas are:
● Database installation and architecture
● User and access management
● Backup and recovery strategies
● Query optimisation and indexing
● Replication setup and troubleshooting
● Performance tuning and monitoring
The MySQL 8.0 for DBA Course in the UK covers a rich set of new and advanced features introduced in MySQL 8.0. This aligns with modern data management demands and enterprise-grade performance. These features are:
● Data Dictionary
● Improved JSON Support
● Common Table Expressions (CTEs)
● Window Functions
● Invisible Indexes
● Roles and Account Management
● InnoDB Enhancements
During the MySQL 8.0 for DBA course, you will gain experience with various industry-relevant tools and technologies in the UK. These tools are necessary for managing, securing and optimising modern MySQL environments. These tools are:
● MySQL Server 8.0
● MySQL Workbench
● MySQL Shell (mysqlsh)
● MySQL Enterprise Backup
● Performance Schema & SYS Schema
● MySQL Enterprise Monitor
● MySQL Router
● MySQL Replication Tools
The MySQL 8.0 for Database Administrators Training in the UK is designed to prepare you for the Oracle Certified Professional, MySQL 8.0 Database Administrator (Exam Code: 1Z0-908) exam. Our course aligns with the official exam syllabus and helps you to pass the exam confidently. This is how we help to prepare:
● Complete coverage of exam objectives
● Hands-on lab sessions
● Exam-focused practice questions & mock tests
● Oracle certified guidance trainers
● Real-world skill alignment
Do you want to learn more about Learners Point Academy?
- Learn more about courses
- Understand about our methodology
- Let’s talk about Corporate trainings
- Anything else that you want to know, we are here for you!