Linux System Engineer: Database Servers Using MariaDB

Study to pass the Red Hat Certified Engineer exam in this course on database configuration and management with MariaDB.

Introduction

• Database server administration with MariaDB
• What you will need

1. Understanding Databases

• How databases work
• What is MariaDB?

2. Introduction to MariaDB

• Install MariaDB
• MariaDB commands
• MariaDB configuration files
• MariaDB logs
• MariaDB and SELinux

3. The MySQL Shell

• Using the MySQL shell
• Subcommands to manage databases
• Subcommands to manage tables

4. Using Databases

• Create a database with tables
• Query a database
• Renaming tables and updating records

5. Administering Databases

• Set the root database password
• Recover the MariaDB root password
• Secure a MariaDB server
• Perform logical database backups
• Restore logical database backups

Conclusion

• Next steps