Study to pass the Red Hat Certified Engineer exam in this course on database configuration and management with MariaDB.
- [Grant] Many different services rely on consistent database server operation. Knowing how to manage databases and database servers is paramount for a Linux system engineer even if you're not a web developer or database administrator. In this course, we install and configure a MariaDB database server and install the client tools. We build new databases, create tables, populate them with data and then query the database using structured query language or SQL. We also backup and restore databases and recover the database rule user's password. I'm Grant McWilliams, computer science instructor and Linux enthusiast. Join me now in my course, Linux System Engineer: Database Servers using MariaDB. Let's get started.
- 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