Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

banner-img

Course Skill Level:

Intermediate to Advanced

Course Duration:

5 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    Big Data & Data Science

  • Course Code:

    AMARDBN21J09

Who should attend & recommended skills:

Those with Basic SQL & MariaDB

Who should attend & recommended skills

  • Those seeking to explore and learn how to use features that make MariaDB different from other databases in its class, in a practical, hands-on way.
  • SQL: Basic (1-2 years’ experience)
  • MariaDB: Basic (1-2 years’ experience) helpful, not required.

About this course

MariaDB is a mature, stable, open-source relational database. From its beginning in 2009 as a branch or fork of the MySQL database, to its status today as the default version of that database in most Linux distributions, and the database of choice for many companies large and small, MariaDB has proven that communities of users and developers, working and collaborating together, can do more than a single company could ever do.
MariaDB shares many features and capabilities of its parent database, but like most children it has also surpassed its parent in many ways. The recipes in this course tread some common ground, but they are mostly about the features that are unique to or were introduced first in MariaDB.
The why of certain features is there, to a small degree, but the main emphasis in each recipe is on the what and the how. The information you need to know to actually do something always trumps the theory behind it.
This 5-day class takes you far beyond the basics, and gives you a practical, hands-on experience with this powerful, feature-rich database.

Skills acquired & topics covered

  • Install MariaDB on Windows, Mac OS X, and Linux
  • Configure MariaDB for better performance using the features of version 10
  • Get familiar with the usage of operators for retrieving rows more selectively
  • Use MariaDB 10’s powerful tools to store, retrieve, and analyze data
  • Secure MariaDB from unauthorized access
  • Maintain the databases associated with MariaDB to ensure efficient and optimum functioning
  • Retrieve data and learn how to sort, summarize, group, and manipulate it

Course breakdown / modules

  • Installing MariaDB on Windows
  • Installing MariaDB on Linux
  • Installing MariaDB on Mac OS X
  • Enabling the Feedback plugin
  • Switching between InnoDB and XtraDB
  • Creating a backup user
  • Making backups with XtraBackup
  • Making backups with mysqldump
  • Checking and optimizing tables automatically with mysqlcheck and cron
  • Using progress reporting in the mysql client

  • Importing the data exported by mysqldump
  • Using SHOW EXPLAIN with running queries
  • Using LIMIT ROWS EXAMINED
  • Using INSTALL SONAME
  • Producing HTML output
  • Producing XML output
  • Migrating a table from MyISAM to Aria
  • Migrating a table from MyISAM or Aria to InnoDB or XtraDB

  • Using SHOW STATUS to check if a feature is being used
  • Controlling MariaDB optimizer strategies
  • Using extended keys with InnoDB and XtraDB
  • Configuring the Aria two-step deadlock detection
  • Configuring the MyISAM segmented key cache
  • Configuring threadpool
  • Configuring the Aria pagecache
  • Optimizing queries with the subquery cache
  • Optimizing semijoin subqueries
  • Creating an index
  • Creating a full-text index
  • Removing an index
  • Using JOINs
  • Using microseconds in the DATETIME columns
  • Updating DATETIME and TIMESTAMP columns automatically

  • Installing TokuDB
  • Configuring TokuDB
  • Creating TokuDB tables
  • Migrating to TokuDB
  • Adding indexes to TokuDB tables
  • Modifying the compression of a TokuDB table

  • 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
  • Using the WMI table type
  • Using the MAC address table type

  • Setting up replication
  • Using global transaction IDs
  • Using multisource replication
  • Enhancing the binlog with row event annotations
  • Configuring binlog event checksums
  • Selectively skipping the replication of binlog events

  • Installing MariaDB Galera Cluster
  • Dropping a node from MariaDB Galera Cluster
  • Shutting down MariaDB Galera Cluster

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

  • Installing SphinxSE in MariaDB
  • Installing the Sphinx daemon on Linux
  • Installing the Sphinx daemon on Windows
  • Configuring the Sphinx daemon
  • Searching with the Sphinx daemon and SphinxSE

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

  • Installing and configuring HandlerSocket
  • Installing the libhsclient library
  • Installing the HandlerSocket PERL client libraries
  • Reading data using HandlerSocket and PERL
  • Inserting data using HandlerSocket and PERL
  • Updating and deleting data using HandlerSocket and PERL
  • Installing the HandlerSocket Python client libraries
  • Reading data using HandlerSocket and Python
  • Inserting data using HandlerSocket and Python
  • Updating and deleting data using HandlerSocket and Python
  • Installing the HandlerSocket Ruby client libraries
  • Reading data using HandlerSocket and Ruby
  • Inserting data using HandlerSocket and Ruby
  • Updating and deleting data using HandlerSocket and Ruby
  • Using HandlerSocket directly with Telnet

  • Installing the Cassandra storage engine
  • Mapping data between MariaDB and Cassandra
  • Using INSERT, UPDATE, and DELETE with the Cassandra storage engine
  • Using SELECT with the Cassandra storage engine

  • Securing MariaDB with mysql_secure_ installation
  • Securing MariaDB files on Linux
  • Securing MariaDB files on Windows
  • Checking for users with insecure passwords
  • Encrypting connections with SSL
  • Using roles to control user permissions
  • Authenticating using the PAM authentication plugin