Linux System Engineer: Database Servers Using MariaDB
48mIntermediate2019-04-26
Authors
Grant McWilliams
Consultant, Speaker, Writer, Professor, Developer
Course details
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.
Learning objectives
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
Learning objectives
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
Skills covered
RHELRed Hat Enterprise LinuxRed HatLinuxDatabase DevelopmentDatabase ManagementNetwork AdministrationNetwork and System AdministrationOpen SourceSoftware DevelopmentDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Database server administration with MariaDB
- 02 - What you will need
1. Understanding Databases
- 03 - How databases work
- 04 - What is MariaDB
2. Introduction to MariaDB
- 05 - Install MariaDB
- 06 - MariaDB commands
- 07 - MariaDB configuration files
- 08 - MariaDB logs
- 09 - MariaDB and SELinux
3. The MySQL Shell
- 10 - Using the MySQL shell
- 11 - Subcommands to manage databases
- 12 - Subcommands to manage tables
4. Using Databases
- 13 - Create a database with tables
- 14 - Query a database
- 15 - Renaming tables and updating records
5. Administering Databases
- 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
Conclusion
- 21 - Next steps