RHCE Cert Prep: Database Servers using MariaDB
.MP4, AVC, 200 kbps, 1280x720 | English, AAC, 160 kbps, 2 Ch | 48 mins | 108 MB
Instructor: Grant McWilliams

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

More Info

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