EncartaLabs

MariaDB for Administrators

( Duration: 5 Days )

MariaDB for Administrators training course, will give you basic knowledge and skills to become a successful MariaDB Administrator. In this course, you will get a walk through on how the Database works, availability of tools, how to use these tools, how to configure MariaDB Database server and configuration. The course also covers database maintenance, backup and recovery. MariaDB is one of the most popular database servers and it has been developed by the original developers of MySQL. MariaDB is open source and as a relational database it provides SQL interface for data access.

Features of MariaDB:

  • MariaDB is open source.
  • Security releases are more transparent and quick.
  • Migration is easy and highly compatible.
  • Improved performance and is radically faster than MySQL

By attending MariaDB for Administrators workshop, attendees will learn:

  • Basics of MariaDB servers with detailed environment explanation.
  • Configuring and using MariaDB.
  • Maintenance and Security in the database.
  • Configuring and Testing Query Cache in MariaDB.
  • Optimizing different aspect of queries.

  • Basic SQL knowledge
  • Working knowledge of MariaDB is recommended,but not needed
  • Database administrators who have experience in alternate relational database management systems and those who want to learn to administer, monitor and support MariaDB databases and servers will find this course useful.

COURSE AGENDA

1

Getting Started with MariaDB Server

  • Installation in Windows
  • Installation in Other Linux Distributions
  • Installation in Ubuntu
2

MariaDB Server Files And Scripts

  • MariaDB Server and Client
  • MariaDB Programs
  • GUI tools usage
3

Configuring MariaDB

  • MariaDB file system layout
  • Configuring files in Linux
  • Understanding groups and Options
4

Using MariaDB

  • MySQL client
  • Creating, Listing and Dropping Databases
  • Creating, Listing and Dropping Tables
  • Inserting, Reading, Updating and Deleting Data
5

Security in MariaDB

  • User accounts and passwords
  • Creating and Deleting user accounts
  • Setting up permission using roles
  • SSL connection
  • Monitoring connections
  • Authentication plugins
6

Maintenance of MariaDB

  • Log files in MariaDB
  • Types of Backup
  • Backup and Recovery
  • Crash Recovery and Maintenance
  • Getting Table Information
  • Checking and Repairing Tables
7

Query Cache in MariaDB

  • Importance of Query Cache
  • Configuring and Testing Query Cache
  • Maintenance of Query Cache
8

Optimization of MariaDB

  • Controlling of optimizer strategies for MariaDB
  • Configuring the MyISAM segmented key cache
  • Configuring threadpool and Aria pagecache
  • Optimizing queries and semi join subqueries

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top