MariaDB Database Administration Training Course
Node ID: 15141
Duration
14 hours
Requirements
Fundamental knowledge of any database and SQL language.
Public Course Dates
Can't find a course date that suits your needs below?
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
| Date | Venue | Price | ||
|---|---|---|---|---|
| 2012-06-11 09:30 | Manchester | From 970 to 1390 GBP Check! | ||
| 2012-06-11 09:30 | London, Westbourne Grove | From 970 to 1390 GBP Check! | ||
| 2012-06-28 09:30 | London, Westbourne Grove | From 970 to 1390 GBP Check! | ||
| 2012-07-02 09:30 | Bristol, Temple Gate | From 970 to 1390 GBP Check! | ||
| 2012-07-19 09:30 | Manchester | From 970 to 1390 GBP Check! | ||
| 2012-08-16 09:30 | London, Westbourne Grove | From 873 to 1251 GBP Check! | ||
| 2012-08-22 09:30 | Manchester | From 873 to 1251 GBP Check! | ||
| 2012-08-23 09:30 | Bristol, Temple Gate | From 873 to 1251 GBP Check! | ||
| 2012-09-06 09:30 | Bristol, Temple Gate | From 873 to 1251 GBP Check! | ||
| 2012-09-10 09:30 | Manchester | From 873 to 1251 GBP Check! |
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.
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
