- Module 1: Getting Started with MariaDB Server
- Module 2: MariaDB Server Files And Scripts
- Module 3: Configuring MariaDB
- Module 4: Using MariaDB
- Module 5: Security in MariaDB
- Module 6: Maintenance of MariaDB
- Module 7: Query Cache in MariaDB
- Module 8: Optimization of MariaDB
Module 1: Getting Started with MariaDB Server
- Installation in Windows
- Installation in Other Linux Distributions
- Installation in Ubuntu
Module 2: MariaDB Server Files And Scripts
- MariaDB Server and Client
- MariaDB Programs
- GUI tools usage
Module 3: Configuring MariaDB
- MariaDB file system layout
- Configuring files in Linux
- Understanding groups and Options
Module 4: Using MariaDB
- MySQL client
- Creating, Listing and Dropping Databases
- Creating, Listing and Dropping Tables
- Inserting, Reading, Updating and Deleting Data
MModule 5: Security in MariaDB
- User accounts and passwords
- Creating and Deleting user accounts
- Setting up permission using roles
- SSL connection
- Monitoring connections
- Authentication plugins
Module 6: Maintenance of MariaDB
- Log files in MariaDB
- Types of Backup
- Backup and Recovery
- Crash Recovery and Maintenance
- Getting Table Information
- Checking and Repairing Tables
Module 7: Query Cache in MariaDB
- Importance of Query Cache
- Configuring and Testing Query Cache
- Maintenance of Query Cache
Module 8: Optimization of MariaDB
- Controlling of optimizer strategies for MariaDB
- Configuring the MyISAM segmented key cache
- Configuring threadpool and Aria pagecache
- Optimizing queries and semi join subqueries