MariaDB Database Administration - 5 days Online Classroom

MariaDB Database Administration - 5 days Online Classroom

Master the administration of MariaDB, one of the world's leading open-source relational database management systems. This hands-on course equips database administrators and IT professionals with the practical skills to install, configure, secure, monitor, and maintain MariaDB environments for optimal performance and reliability.

Through real-world exercises, you'll learn how to manage databases and users, configure server settings, implement backup and recovery strategies, monitor performance, optimize queries, and troubleshoot common database issues. You'll also explore security best practices, replication, and routine maintenance to ensure highly available and efficient database systems.

By the end of the course, you'll be able to confidently administer MariaDB databases in development, testing, and production environments.

Key Features

• Course and material in english
• Beginner level
• 5 days of live instructor-led virtual training (8 hours / day)
• Interactive hands-on labs
• All relevant course material
• 60+ recommended study hours
• Certificate included

Learning Outcomes

• MariaDB Fundamentals: Learn the core concepts of MariaDB, including its architecture, server management, installation, and file structure to build a strong foundation in database administration.
• Database Administration: Create and manage databases, tables, users, roles, permissions, and server configurations for secure database operations.
• Monitoring & Performance: Monitor MariaDB using logs, diagnostic tools, and SQL commands to identify issues, maintain system health, and optimize database performance.
• Storage Engines: Explore MariaDB storage engines such as InnoDB, MyISAM, Aria, and Memory, and learn how to choose the right engine for different application requirements.
• Backup, Recovery & Replication: Implement backup and restore procedures, configure replication, and maintain high availability and data integrity.

Target Audience

• Database administrators (DBAs)
• Linux system administrators
• DevOps and infrastructure engineers
• Backend developers managing databases
• IT operations professionals
• Anyone responsible for administering MariaDB servers

Prerequisites

• Basic knowledge of relational databases
• Familiarity with SQL fundamentals
• Basic Linux command-line experience
• Understanding of database concepts such as tables, users, and queries is recommended

Course Outline

Day 1: MariaDB Administration Fundamentals

• Understand MariaDB architecture, server, clients, and administration tools
• Retrieve database metadata using SHOW, DESCRIBE, and INFORMATION_SCHEMA
• Configure server settings, storage engines, variables, and auditing
• Manage SQL modes, logs, and binary logging

Day 2: Storage Engines & Database Maintenance

• Explore MariaDB architecture, memory, and storage management
• Configure and optimize the InnoDB storage engine
• Work with MyISAM, Aria, Memory, and other storage engines
• Perform table maintenance, optimization, and repair

Day 3: Backup, Recovery & Security

• Implement backup and recovery using MariaDB Backup, binary logs, and command-line tools
• Import and export databases
• Manage users, roles, passwords, and privileges
• Configure access control and resource management

Day 4: Performance Tuning & Server Management

• Manage transactions, locking, and concurrency
• Optimize tables and tune server performance
• Automate tasks with the Event Scheduler
• Install, upgrade, and secure MariaDB servers

Day 5: Replication & High Availability

• Understand high-availability concepts and architecture
• Configure and manage MariaDB replication, including GTID-based replication
• Monitor, troubleshoot, and optimize replication
• Implement failover and high-availability strategies using MariaDB Replication Manager

FAQ

When is the class held?

The majority of the class is a full-day online course from morning to afternoon CET with 8 hours / day straight. However, please contact us to confirm the final detailed schedules.

What is MariaDB?

MariaDB is an open-source relational database management system (RDBMS) developed as a community-driven fork of MySQL. It is widely used for enterprise applications, websites, and cloud services.

Who should take this course?

This course is designed for database administrators, Linux administrators, DevOps engineers, backend developers, and IT professionals responsible for managing MariaDB databases.

Do I need previous MariaDB experience?

No. However, a basic understanding of SQL and relational database concepts is recommended.

Will I learn backup and recovery?

Yes. You'll learn how to perform backups, restore databases, and implement recovery strategies to protect critical data.

Does the course cover database security?

Yes. The course includes user management, authentication, permissions, and security best practices to help protect MariaDB environments.

What skills will I gain?

You'll learn to install, configure, secure, monitor, optimize, back up, and maintain MariaDB databases while applying best practices for reliable and scalable database administration.

Which MariaDB versions are covered?

The course covers MariaDB 10.4 to 11.x, focusing on key features, administration practices, and capabilities used in modern database environments.

Will I learn about replication and high availability?

Yes. You'll learn how to configure and manage MariaDB replication, understand replication strategies, and apply failover and switchover techniques to improve system availability and reliability.