Worldwide [select]
MariaDB Database Administration Training Course
Overview
MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.
The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Requirements
Fundamental knowledge of any database and SQL language.
Duration
14.00 hours
Course Prices
Prices for Instructor-led Online Courses:
If your company is based in the UK, VAT will be applied to the prices above.
Too Expensive? Tell us your price!
Too Expensive? Tell us your price!
Course Outline
Installing MariaDB server
Installing in Ubuntu/Debian
Installing in other Linux Distributions
Installation on Windows
MariaDB Server Files and Scripts
MariaDB Programs
MariaDB Server
MariaDB Client
GUI Tools
MariaDB Server Configuration
server Options
The Server SQL Mode
Server System Variables
Dynamic System Variables
Server Status Variables
Shutdown Process
MariaDB Security Issues
Securing MariaDB Against Attacks
Security-Related Options
Security Issues with LOAD DATA LOCAL
MariaDB Access Privilege System
MariaDB Privilege System Overview
Privileges Provided by MariaDB
Connecting to the MariaDB Server - Stages
Access Control, Stage 1: Connection Verification
Access Control, Stage 2: Request Verification
Access Denied Errors
MariaDB User Account Management
Users and Passwords
Creating New Users
Deleting User Accounts
Limiting User Resources
Changing Passwords
MariaDB Database Maintenance
Backup and Recovery
Point-in-Time Recovery
Maintenance and Crash Recovery
myisamchk Syntax and Options
Getting Table Information
MariaDB Local Setting
National Characters and Sorting
MariaDB Server Time Zone
MariaDB Log Files
Error Log
General Query Log
Update Log
Binary Log
Slow Query Log
Log File Maintenance and Rotation
Running Multiple MariaDB Servers on the Same Machine
Running Multiple Servers in Windows
Running Multiple Servers in Windows as Services
Running Multiple Servers in Unix and Linux
Using Client Tools in a Multi-Server Environment
MariaDB Query Cache
The Concept of Query Cache
Testing Query Cache with SELECT
Configuring Query Cache
Checking Query Cache Status and Maintenance
