If you manage MariaDB databases, this intensive five-day course is for you. Led by our knowledgeable trainers, the training builds on your existing SQL knowledge and introduces the core responsibilities of a MariaDB Database Administrator.
MariaDB Database Administration
Take control of your data with MariaDB administration
This MariaDB Database Administration course equips you with the practical skills to manage, maintain and secure MariaDB systems. These skills will help you drive performance, reliability and trust in your organisation’s data operations.
Learning objectives
- Install and configure MariaDB
- Perform backup and recovery
- Tune and optimise server performance
- Manage users, privileges and roles
- Understand InnoDB and other storage engines
- Configure and monitor replication
- Use logs and metadata effectively
- Implement high availability solutions
What you’ll learn
Build on your MariaDB knowledge with this practical, hands-on course. From SQL modes to high availability, this course teaches key MariaDB functions and tools to help you manage production systems with ease.
Configure and manage MariaDB servers
Gain hands-on experience setting up and maintaining a stable, secure server environment. You’ll learn how to install the MariaDB server and client tools, configure essential system variables, and start or stop the server safely. The course walks you through key components of server setup, giving you full visibility of how MariaDB operates under the surface.
Implement robust backup and recovery strategies
Explore how to protect data integrity and ensure continuity through a variety of reliable backup techniques. You’ll learn the difference between physical and logical backups, and when to use each method based on your organisation’s needs. By the end of the course, you’ll understand how to build a backup plan that supports both daily operations and disaster recovery scenarios.
Master user management and access control
In this section of the course, you’ll learn how to securely manage who can access your MariaDB databases and what they can do once connected. Discover how to create, rename, and remove user accounts, as well as how to set and update passwords. You’ll explore the use of privileges and roles to control access to databases, tables, and commands, helping you enforce least-privilege access across your systems.
Set up replication and support high availability
Learn to create resilient database environments that reduce downtime and support business continuity. You’ll explore replication concepts and architectures, including how to configure master-slave replication, set up GTID-based replication, and implement more complex topologies tailored to different use cases.
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
DBAs, Developers and Consultants who manage, monitor or support MariaDB databases and need practical, production-level skills.
Prerequisites
Basic MariaDB knowledge, SQL proficiency, and a working understanding of Linux/UNIX.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
The MariaDB Database Administration training equips you with crucial knowledge and hands-on experience needed to manage MariaDB databases, perform backups, optimise performance, and set up replication.
Who should attend this MariaDB course?
This course is designed for Database Administrators, Developers, and Technical Consultants who need to install, manage, and optimise MariaDB environments.
Is this course suitable for beginners?
Some prior experience is required. Learners should understand SQL and have basic MariaDB and Linux knowledge.
Instead, for beginners, we would recommend our Introduction to MariaDB course. This will provide a fundamental understanding of the technology before you progress to the MariaDB Database Administration training.
Does the course help with certification?
Yes. This course is closely aligned with the official curriculum for the MariaDB Certified Database Administrator Associate exam, and as such can be useful to help you prepare. However, before taking the exam we would recommend you check all other exam requirements and meet the recommended level of experience.
Please note: The exam is not available with this course. You will need to book this separately.
Will I get hands-on experience?
Absolutely. All our courses include live labs and practical exercises that simulate real-world DBA tasks.
Can this course be delivered privately for teams?
Yes. We offer tailored courses for businesses. These can be delivered onsite or virtually.
What our customers say
"I have taken a number of virtual training courses over the years, and I have to say this one was the best delivery wise. Stuart was engaging and explanatory, extremely patient and no question seemed unimportant or ridiculous."
Emma, Performance Analyst – Legal
"Really informative course, structured to support all forms of learning and at a good pace."
Owen, Graduate Trainee Engineer - Utilities
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs