Study to pass the Red Hat Certified Engineer (RHCE) exam—the benchmark certification for Red Hat Enterprise Linux. This installment of the RHCE Cert Prep series covers database configuration and management with MariaDB. Instructor Grant McWilliams begins by reviewing database basics, walking through a MariaDB server install, and noting differences between MySQL and MariaDB. Then he demonstrates some SQL commands for creating databases and tables, and how to query the data held within them. Next, he explains how to set and recover the database root user's password and secure your database server installation. Finally, he shows how to create and restore logical MariaDB backups of databases and tables.

Topics include:

Installing MariaDB server

MariaDB commands, configuration files, and logs

Addressing SELinux concerns

Using the MySQL shell

Managing databases and tables with subcommands

Creating a database with tables

Querying a database

Renaming tables and updating records

Setting and recovering the root database password

Securing your MariaDB server installation

Performing and restoring logical database backups

HOMEPAGE

https://www.lynda.com/Linux-tutorials/RHCE-Cert-Prep-Database-Servers-using-MariaDB/774915-2.html