Course Overview:
MariaDB is a comprehensive, hands-on training program designed to develop the practical skills required to administer, maintain, secure, monitor, and optimize MariaDB database environments. The course begins with MariaDB installation and configuration across Linux and Windows platforms, followed by an introduction to core MariaDB concepts, server operations, and essential administrative tools. Participants will learn how to manage and maintain MariaDB server logs, including error, general query, binary, and slow query logs, while gaining an understanding of log maintenance and rotation.
The course also covers essential database administration tasks, including data types and character sets, schema objects, views, triggers, table partitioning, storage engines, transactions, data locking, users, roles, and database security. Participants will gain practical knowledge of backup and restoration strategies, resource utilization, performance monitoring and tuning, replication, and high availability. By the end of the course, participants will be better prepared to perform essential MariaDB administration tasks and maintain secure, reliable, and high-performing database environments.
Course Objectives:
By the end of this course, participants will be able to:
- Install and configure MariaDB Server on Ubuntu, Debian, other Linux distributions, and Windows.
- Understand MariaDB architecture, features, components, and essential administration concepts.
- Perform MariaDB server startup and shutdown operations.
- Configure, activate, and manage MariaDB server logs.
- Understand and manage error, general query, binary, and slow query logs.
- Apply appropriate log file maintenance and rotation practices.
- Understand MariaDB data types, character sets, and database objects.
- Work with views, triggers, and table partitioning.
- Compare and select appropriate MariaDB storage engines for different workloads.
- Understand transactions, locking, and concurrency concepts.
- Manage MariaDB users, roles, privileges, and database security.
- Understand data-at-rest encryption and apply appropriate security practices.
- Perform database backup and restoration using different backup methods.
- Monitor MariaDB resource utilization and identify potential performance issues.
- Apply practical performance tuning and optimization techniques.
- Understand MariaDB replication and monitor replication environments.
- Understand high-availability concepts and their application to MariaDB.
- Apply effective database administration and maintenance practices in real-world environments.
Pre-requisites:
- Basic SQL knowledge
- Working knowledge of MariaDB is recommended, but not needed
Target Audience:
- Admins and Development
Course Duration:
- 21 hours – 3 days
Course Content:
Installing MariaDB server
- Installing in Ubuntu/Debian
- Installing in other Linux Distributions
- Installation on Windows
Introduction
- What is MariaDB
- Features of MariaDB
- Perform the MariaDB start and shutdown operations
- Activate and Manage MariaDB server logs
MariaDB Log Files
- Error Log
- General Query Log
- Update Log
- Binary Log
- Slow Query Log
- Log File Maintenance and Rotation
Performance and Usage Statistics
- Describe MariaDB Server Essentials
- Evaluate the data types and character sets
- Understand MariaDB schema objects such as views, triggers, and table partitioning
- Compare and gain an understanding of the multiple storage engines in MariaDB
- Understand transactions and data locking in Maria DB
- Manager users, roles and security including data at rest encryption
- Perform back and restore operations using different backup methods
- Maria DB resources utilization
- Performance tuning techniques
- High availability
- Monitor MariaDB replication
- PL/SQL and Windows functions on Maria DB
- Summary and Closing Remarks
