MariaDB Database Administration Training Course

Primary tabs

Course Language

This course is delivered in Polish or English.

Course Code

mariadbadmin

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Fundamental knowledge of any database and SQL language.

Overview 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 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

The CONNECT Storage Engine

  • Installing the CONNECT storage engine
  • Creating and dropping CONNECT tables
  • Reading and writing CSV data using CONNECT
  • Reading and writing XML data using CONNECT
  • Accessing MariaDB tables using CONNECT
  • Using the XCOL table type
  • Using the PIVOT table type
  • Using the OCCUR table type

Exploring Dynamic and Virtual Columns in MariaDB

  • Creating tables with dynamic columns
  • Inserting, updating, and deleting dynamic column data
  • Reading data from a dynamic column
  • Using virtual columns

Performance and Usage Statistics

  • Installing the Audit Plugin
  • Using the Audit Plugin
  • Using engine-independent table statistics
  • Using extended statistics
  • Enabling the performance schema
  • Using the performance schema

Optimizing and Tuning MariaDB

  • Using SHOW STATUS
  • Controlling MariaDB optimizer strategies
  • Using extended Keys with InnoDB and XtraDB
  • Configuring the MyISAM segmented key cache
  • Configuring threadpool
  • Configuring the Aria pagecache
  • Optimizing queries with the subquery cache
  • Optimizing semijoin subqueries
  • Using microseconds in DATETIME columns
  • Updating the DATETIME and TIMESTAMP columns automatically

 


Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1883PLN
(83)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From 1883PLN
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 4450PLN
Request quote
SelfStudy SelfStudy
Self-study courses allow you to learn at your own pace on your own time. There is no live instructor involved. The participants use recorded video, quizzes and reading at their own convenience.
Price not set yet
Register Interest

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 1883PLN 1883PLN 4450PLN
2 1592PLN 1492PLN 2775PLN
3 1494PLN 1361PLN 2217PLN
4 1446PLN 1296PLN 1938PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
Creating and managing Web sites Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2016-06-27 09:00 3410PLN / 2555PLN
Programming in C Gdynia Mon, 2016-06-27 09:00 1590PLN / 1143PLN
Distributed Messaging with Apache Kafka Katowice Mon, 2016-06-27 09:30 4998PLN / 3288PLN
Social Media - facebook, twitter, blog, youtube, google+ Poznan, Garbary Tue, 2016-06-28 09:00 1070PLN / 873PLN
Design Patterns in C# Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2016-06-29 09:00 1865PLN / 1392PLN
Visual Basic for Applications (VBA) for Analysts Poznan, Garbary Mon, 2016-07-04 09:00 1912PLN / 1278PLN
Debian Administration Poznan, Garbary Mon, 2016-07-04 09:00 3157PLN / 2083PLN
Agile Project Management with Scrum Szczecin Wed, 2016-07-06 09:00 1746PLN / 1361PLN
A Practical Guide to Successful Pricing Strategies Poznan, Garbary Wed, 2016-07-06 09:00 1427PLN / 1093PLN
SQL language in MSSQL Poznan, Garbary Thu, 2016-07-07 09:00 1568PLN / 1142PLN
Excel and VBA Programming for Audit and Finance Professionals Warszawa, ul. Złota 3/11 Mon, 2016-07-11 09:00 1913PLN / 1441PLN
Forecasting with R Poznan, Garbary Thu, 2016-07-14 09:00 2188PLN / 1527PLN
Introduction to Selenium Wrocław, ul.Ludwika Rydygiera 2a/22 Thu, 2016-07-14 09:00 768PLN / 539PLN
Machine Learning Fundamentals with R Warszawa, ul. Złota 3/11 Mon, 2016-07-18 09:00 2523PLN / 1828PLN
Building Web Apps using the MEAN stack Szczecin Mon, 2016-07-18 09:00 5538PLN / 3351PLN
Administracja bazą danych Microsoft SQL Server 2012 Toruń, ul. Żeglarska 10/14 Mon, 2016-07-18 09:00 2509PLN / 1653PLN
ITIL®: Intermediate Lifecycle Stream: Service Strategy (SS) Kraków Tue, 2016-07-19 09:00 4338PLN / 3116PLN
Microsoft Access - download the data Poznan, Garbary Wed, 2016-07-20 09:00 1117PLN / 856PLN
Debian Administration Olsztyn, ul. Kajki 3/1 Mon, 2016-07-25 09:00 3157PLN / 2167PLN
Python Programming Warszawa, ul. Złota 3/11 Mon, 2016-08-01 09:00 5790PLN / 3753PLN
Data Analysis with Oracle 11g - workshop Warszawa, ul. Złota 3/11 Mon, 2016-08-01 09:00 4350PLN / 3012PLN
Web Application Development in PHP Warszawa, ul. Złota 3/11 Wed, 2016-08-03 09:00 2688PLN / 2022PLN
Zapewnienie jakości oprogramowania – przegląd metodyk Warszawa, ul. Złota 3/11 Tue, 2016-08-09 09:00 2735PLN / 1863PLN
Oracle 11g - Programming with PL / SQL II Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2016-08-10 09:00 2363PLN / 1785PLN
Stress management Warszawa, ul. Złota 3/11 Thu, 2016-08-18 09:00 2112PLN / 1212PLN
Programming in WPF 4.5 Warszawa, ul. Złota 3/11 Mon, 2016-09-05 09:00 2359PLN / 1355PLN
BPMN 2.0 for Business Analysts Wrocław, ul.Ludwika Rydygiera 2a/22 Tue, 2016-09-27 09:00 3110PLN / 2337PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 1689PLN / 1413PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
GdyniaMon, 2016-07-11 09:001938PLN / 1410PLN
Toruń, ul. Żeglarska 10/14Mon, 2016-07-11 09:001938PLN / 1388PLN
Wrocław, ul.Ludwika Rydygiera 2a/22Thu, 2016-07-14 09:001938PLN / 1329PLN
Łódź, ul. Tatrzańska 11Mon, 2016-07-18 09:001938PLN / 1388PLN
LublinTue, 2016-07-19 09:001938PLN / 1433PLN

Some of our clients