Linux System Engineer: Database Servers Using MariaDB

Linux System Engineer: Database Servers Using MariaDB
Linux System Engineer: Database Servers Using MariaDB
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 47m | 106 MB

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
Table of Contents

1 Database server administration with MariaDB
2 What you will need
3 How databases work
4 What is MariaDB
5 Install MariaDB
6 MariaDB commands
7 MariaDB configuration files
8 MariaDB logs
9 MariaDB and SELinux
10 Using the MySQL shell
11 Subcommands to manage databases
12 Subcommands to manage tables
13 Create a database with tables
14 Query a database
15 Renaming tables and updating records
16 Set the root database password
17 Recover the MariaDB root password
18 Secure a MariaDB server
19 Perform logical database backups
20 Restore logical database backups
21 Next steps