MySQL 8.0 for Database Administrators Course in Saudi Arabia
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 a globally respected certification in MySQL 8.0
Access flexible sessions and batches for a busy schedule
Convenient payment options in instalments
4.8/58758 EnrolledEnrolled Learners
4.8/58758 EnrolledEnrolled Learners
Overview
What we are going to teach you:
- Install and upgrade MySQL on Linux systems, and use Docker to build test environments for MySQL
- Deploy a stable InnoDB Cluster using MySQL Shell and MySQL Router
- Monitor system performance with Performance Schema and MySQL Enterprise Monitor
- Enhance database security using SSL, data encryption, and firewall configurations
- Automate backup processes using tools such as mysqldump, mysqlpump, and MySQL Enterprise Backup
- Optimize query performance by using indexes and the Query Analyzer
Upcoming sessions
Curriculum
1
Introduction to MySQL
2
MySQL Powers the Web
3
Practice 1-1: Course Environment
1
Installing and Upgrading MySQL
2
Linux MySQL Server Installation Directories
3
Starting and Stopping MySQL
4
Practice 2-1: Installing MySQL
5
Practice 2-2: Connecting to MySQL
6
Practice 2-3: Configuring the MySQL Service
7
Practice 2-4: Upgrading MySQL
8
Practice 2-5: Deploying MySQL with Docker
1
Understanding MySQL Architecture
2
Storage Layer
3
What Is a Data Dictionary?
4
Redo Logs
5
Practice 3-1: Configuring Tablespaces
6
Practice 3-2: Configuring the Buffer Pool
1
Configuring MySQL
2
Server System Variables
3
Practice 4-1: Modifying a Setting by Using Command-Line Arguments
4
Practice 4-2: Modifying the Configuration File
5
Practice 4-3: Changing Dynamic Settings
6
Practice 4-4: Persisting Global Variables
7
Practice 4-5: Configuring the Client
8
Practice 4-6: Running Multiple MySQL Servers on the Same Host with systemd
1
Monitoring MySQL
2
Status Variables
3
MySQL Enterprise Audit
4
MySQL Enterprise Monitor
5
Practice 5-1: Configuring the Slow Query Log
6
Practice 5-2: Using Performance Schema
7
Practice 5-3: Installing MySQL Enterprise Monitor
8
Practice 5-4: Monitoring Server Activity
1
Managing MySQL Users
2
Setting the Account Password
3
Authorization
4
Using Role Privileges
5
Practice 6-1: Quiz—User Management
6
Practice 6-2: Creating Users and Roles
7
Practice 6-3: Granting Permissions
1
Securing MySQL
2
Preventing MySQL Password Security Risks
3
Keyring
4
MySQL Enterprise Firewall
5
Practice 7-1: Quiz – Securing MySQL
6
Practice 7-2: Enabling SSL for Secure Connections
7
Practice 7-3: Encrypting MySQL Data-at-Rest
8
Practice 7-4: Configuring MySQL Enterprise Firewall
1
Maintaining a Stable System
2
Capacity Planning
3
Identifying the Causes of Server Slowdowns
4
Practice 8-1: Quiz—Maintaining a Stable System
5
Practice 8-2: Identifying the Cause of Slow Performance
1
Optimizing Query Performance
2
Index Statistics
3
Practice 9-1: Improving Query Performance with Indexes
4
Practice 9-2: Using MySQL Query Analyzer
1
Choosing a Backup Strategy
2
Backup Techniques
3
Practice 10-1: Quiz—Backup Strategies
1
Performing Backups
2
mysqldump and mysqlpump
3
Physical InnoDB Backups: Overview
4
Overview of practices for lesson 11
5
Practice 11-1: Backing Up with MySQL Enterprise Backup
6
Practice 11-2: Backing Up with mysqldump and mysqlpump
7
Practice 11-3: Restoring the Database Using the Binary Log
1
Administering a Replication Topology
2
Monitoring Replication
3
Troubleshooting MySQL Replication
4
Practice 12-1: Monitoring Replication with MySQL Enterprise Monitor
5
Practice 12-2: Troubleshooting Replication Errors
6
Practice 12-3: Performing a Replication Failover
1
Achieving High Availability with MySQL InnoDB Cluster
2
MySQL Shell (mysqlsh)
3
Managing Sandbox Instances
4
Practice 13-1: Creating MySQL InnoDB Cluster
5
Practice 13-2: Deploying MySQL Router and Testing the Cluster
6
Practice 13-3: Testing High Availability
Meet your Trainer
Our Trainers
We, at Learners Point, take immense pride in our teaching methods and instructors. Our instructors are some of the best experts in their fields and employ a practical approach to learning. Many of them are globally recognised and have a diverse set of experience in their field of expertise. You are always sure to have the best in the industry as your teachers who are ready to guide you at every step and make the experience informative yet enjoyable. Apart from the focus on learning your chosen course, our instructors also encourage students to develop communication skills and interpersonal skills necessary to excel in the practical world.
Our cutting edge teaching methods make every program an immersive and productive experience for the learners. Our learning methods are research-driven and are continuously updated to stay relevant to present times as well as the future. You will enjoy practical applications of everything learned through theory and regular mock examinations to help monitor your progress. Our courses are led by an instructor in a classroom setup and we do offer online high-quality sessions as well for individuals. We also monitor the training sessions with a progress tracker to maintain high standards of instruction & ethics.
Learning Outcomes
Successful completion of the training will help you to:
1
Install MySQL on Linux and manage services to ensure proper startup and shutdown processes
2
Perform MySQL server upgrades with minimal downtime using binary logs and version-compatible techniques
3
Utilize Performance Schema and MySQL Enterprise Monitor to identify and resolve performance bottlenecks
4
Implement SSL, encryption for data at rest, and the MySQL Enterprise Firewall to protect against current security threats
5
Enhance query performance by using index data and the Query Analyzer to reduce latency and improve application speed
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 Dubai, candidates must fulfil these eligibility requirements:
- A basic grasp of how databases work and common 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
Frequently asked questions
Our MySQL 8.0 for Database Administrators Course in Saudi Arabia teaches professionals how to install, configure, secure, and manage MySQL 8.0 databases. It is a 40-hour intensive program designed for IT professionals, DBAs, and developers working with data-heavy applications. This training builds strong skills in performance tuning, security, and real-world MySQL deployment.
This course is a great fit for database administrators responsible for managing MySQL systems. It also suits system admins who want to learn about MySQL configuration and performance, as well as developers working with production databases. It’s ideal for IT professionals preparing for certifications or looking to grow their careers in database management.
Our program covers essential topics like MySQL architecture, data types, and InnoDB storage engines. Students learn performance tuning, security practices, and how to manage user privileges. You also explore advanced replication methods and key tools such as MySQL Shell, Performance Schema, and MySQL Enterprise Monitor for real-world database operations.
This course strengthens your expertise in MySQL 8.0, a vital skill for organizations relying on database-driven systems. We improve your chances of securing roles in industries like telecom, banking, and IT services. You also gain the knowledge needed to pass MySQL certifications, boosting your resume and helping you become a valuable asset to employers in Saudi Arabia.
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!
