+49 (0) 30 5201 4923
info@orb-experts.com
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.
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.
Participants should have a fundamental understanding of any database and familiarity with SQL language.
*We customize the course outline and content to your specific needs and relevant use cases.
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.
Master new skills guided by experienced instructors from anywhere.
