Catalogue
/
Databases
/
MariaDB Database Administration

MariaDB Database Administration

Discover the intricate world of MariaDB administration in this comprehensive course. Learn to install, configure, secure, and optimize the MariaDB server, ensuring robustness and high performance for your business needs.

What will you learn?

Discover the intricate world of MariaDB administration in this comprehensive course. Learn to install, configure, secure, and optimize the MariaDB server, ensuring robustness and high performance for your business needs.

• Dive deep into MariaDB administration over 14 hours, spread across 2 days. By the end of this course, participants will:

• Master the installation of MariaDB across various platforms.

• Grasp the essence of MariaDB server files, programs, and configurations.

• Understand MariaDB security measures and how to fortify against potential threats.

• Be proficient in user account management, ensuring tight access control.

• Gain expertise in database maintenance, from backups to crash recovery.

• Explore advanced features such as query caches, storage engines, and dynamic columns.

• Harness tools and strategies for MariaDB optimization, enhancing performance and efficiency.

Requirements:

Participants should have a fundamental understanding of any database and familiarity with SQL language.

Course Outline*:

*We know each team has their own needs and specifications. That is why we can modify the training outline per need.

Installing MariaDB Server:

  • Ubuntu/Debian Installation
  • Installation on Other Linux Distributions
  • Windows Installation

Understanding MariaDB Architecture:

  • Server Files and Scripts
  • MariaDB Programs: Server, Client, and GUI Tools

MariaDB Server Configuration:

  • Server Options
  • SQL Mode, System Variables, and Status Variables
  • Shutdown Process

Securing MariaDB:

  • Protection Against Attacks
  • Security Options & Issues with LOAD DATA LOCAL

MariaDB Access and Privilege System:

  • Privilege System Overview
  • Connecting to the Server and Access Control
  • Handling Access Denied Errors

User Account Management:

  • Creating, Deleting, and Managing User Accounts
  • Password Management and User Resource Limits

Database Maintenance:

  • Backup, Recovery, and Crash Recovery
  • Table Information Retrieval and myisamchk Utility

Localization in MariaDB:

  • National Characters, Sorting, and Server Time Zones

Logging in MariaDB:

  • Error, Query, and Log File Maintenance
  • Running Multiple MariaDB Servers

Advanced MariaDB Features:

  • Query Cache
  • CONNECT Storage Engine
  • Dynamic and Virtual Columns

Performance and Usage Monitoring:

  • Audit Plugin Installation and Usage
  • Engine-independent Statistics and Performance Schema

Optimizing MariaDB:

  • SHOW STATUS Command and Optimizer Strategies
  • Configurations for InnoDB, MyISAM, Aria, and More
  • Advanced Query Optimization Techniques

Hands-on learning with expert instructors at your location for organizations.

3.072€*
Graph Icon - Education X Webflow Template
Level:
intermediate
Clock Icon - Education X Webflow Template
Duration:
14
Hours (days:
2
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.

Master new skills guided by experienced instructors from anywhere.

2.037€*
Graph Icon - Education X Webflow Template
Level:
intermediate
Clock Icon - Education X Webflow Template
Duration:
14
Hours (days:
2
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.