MariaDB Database Administration - 5 days Online Classroom
3.450,00 EUR
- 5 days
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
Language
Course and materials are in English
Level
Beginner level
5 days (40 hours) live classroom
with accredited trainers
60+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Build
Learn the core concepts of MariaDB, including its architecture, server management, installation, and file structure to build a strong foundation in database administration.
Create
Create and manage databases, tables, users, roles, permissions, and server configurations for secure database operations.
Optimize
Monitor MariaDB using logs, diagnostic tools, and SQL commands to identify issues, maintain system health, and optimize database performance.
Implement
Implement backup and restore procedures, configure replication, and maintain high availability and data integrity.
Explore
Explore MariaDB storage engines such as InnoDB, MyISAM, Aria, and Memory, and learn how to choose the right engine for different application requirements.
Course timeline
Day 1: MariaDB Administration Fundamentals
Lesson 01
- 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
Lesson 02
- 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
Lesson 03
- 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
Lesson 04
- 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
Lesson 05
- 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
Who Should Enroll in this Program?
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
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.