MariaDB Database Administration

Select your learning method

Overview Learning objectives What you’ll learn Key facts FAQs What our customers say Get in touch

Learn essential skills

Course overview

Designed for those with prior experience working with MariaDB, this course will teach you how to keep your systems secure, efficient and resilient. Equip yourself with the skills to take on day-to-day DBA responsibilities and support your team with deeper technical capabilities.

Download course outline

Master the art of MariaDB administration

Over five intensive days, this course develops core DBA skills. You’ll cover everything from configuration and backups to replication and performance. Build on your existing skills, grow your confidence and achieve a MariaDB certification.

Learning objectives

Configure and install MariaDB systems
Administer user access and roles
Work with InnoDB and alternative engines
Explore high availability approaches
Optimise database performance
Set up and manage replication
Execute backup and recovery strategies
Monitor metadata and log files

What you’ll learn

With a strong focus on hands-on practice and access to our live labs, this course will help you build the confidence and capability to manage MariaDB systems. You’ll explore how to manage users and permissions, monitor performance, interpret logs, and use different storage engines effectively.

Get started with MariaDB

Start by gaining an understanding of the fundamentals of MariaDB: how it works, its architecture, version history, and how it can be used in professional environments. You’ll learn how to start, stop and restart the server safely, manage installation directories, and understand the default file structure. This section sets the foundation for the rest of the course, preparing you to confidently deploy MariaDB.

Monitoring and system health

Monitoring is central to effective database administration. This course shows you how to keep your MariaDB systems running smoothly. You’ll learn how to configure and interpret various log files to identify issues before they impact performance. Also, understand how diagnostic tools and SQL commands can be used to gather real-time insights into database activity. These skills will enable you to maintain system reliability, identify bottlenecks quickly, and optimise the database for different workloads.

Understand storage engines

MariaDB’s pluggable storage engine architecture gives you flexibility in how data is stored and accessed. Explore the key features, strengths and limitations of the major storage engines, including InnoDB, MyISAM, Aria, Memory, and others. Learn when to use each engine depending on your application needs, and how to mix storage engines within the same database to get the best results.

What’s included

5 days of instructor-led training in a live virtual classroom
Interactive, hands-on live labs
All relevant course materials
Course completion certificate

Key facts

Ideal for

This course is perfect for Developers, System Administrators, and DBAs responsible for the deployment and ongoing management of MariaDB servers.

Prerequisites

Prior exposure to MariaDB, proficiency with SQL, and a working knowledge of Linux or UNIX are essential.

Learning experience

Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.

FAQs

With ILX’s expert-led MariaDB Database Administration course, you’ll gain the hands-on experience needed to confidently configure, optimise and secure MariaDB databases.

Is this MariaDB course right for me?

This course is designed for IT professionals such as DBAs, Systems Administrators, and Developers who want to deepen their skills in managing, tuning, and securing MariaDB.

Is the certification exam included in the course?

While this course is closely aligned with the MariaDB Certified Database Administrator Associate certification, the exam is not included with this course. However, you'll leave with the knowledge and confidence needed to get certified independently.

What versions of MariaDB does this course cover?

This course is designed to support professionals working with MariaDB versions 10.4 through to 11.x. It addresses the key features and functionality introduced across these releases, ensuring you understand both the foundational and more advanced capabilities of the platform. The training is relevant and version-aware, reflecting real-world database environments.

Will I learn how to handle replication and high availability?

Yes, this course provides in-depth training on setting up and managing replication to support high availability in MariaDB environments. You’ll start by understanding the core principles of replication, including when and why to use it, and the differences between synchronous and asynchronous approaches. As well as exploring techniques for controlled switchover and failover, ensuring your systems can maintain uptime and data integrity even during maintenance or unexpected failures.

What our customers say

"Always good courses from ILX. Tutor explained the course very well."

Paul, Development Analyst, Application Support – Transport

"Stuart was very good in explaining, and very patient, finding alternative ways to explain concepts where understanding was not grasped on the first attempt."

Stuart, Assurance Manager - Government

Why study with ILX

500,000+ learners

Join the half a million learners developing their skills with our training

5,000+ businesses

A trusted partner to thousands of organisations worldwide

96% customer satisfaction

Our passionate team goes above and beyond to support customer needs

Similar courses

MariaDB

Course

Introduction to MariaDB

From $1,675.00

Linux

Course

Linux Introduction

From $1,915.00

MariaDB

Course

MariaDB Performance & Tuning

From $1,540.00

MariaDB

Course

MariaDB for Developers

From $2,790.00

Web & Application Server

Course

Apache Web Server

From $2,185.00