During this module, you will learn how to back up and restore databases. These processes are essential aspects of any organization's health and its ability to respond quickly to changes in the system. Through hands-on labs, you will learn why it is vital to create backups and define policies and procedures. In this module, you’ll also learn about database security and user management, including creating and resetting user passwords, creating groups, and more!

In this module, you will learn how to create and keep baselines, performance metrics, standards, and finally, monitor RAM and disk usage, connections, and cache stats. You will also learn about database optimization, including updating statistics, slow queries, types of indexes, and index creation and usage.

In this module you will learn about some basic troubleshooting processes that help data engineers find frequently occurring issues such as connectivity, login, configuration, and whether the instance is running. You'll also learn how to automate many database functions, from managing alerts to generating and sending reports using standard Linux and Unix shell commands or cron jobs.

In this module, you will complete and submit a final project to demonstrate the skills you gained in the previous modules. Your work will be evaluated through either the AI-graded option or the peer-graded option, depending on the submission method you choose. In this multi-part assignment, you will perform database administration tasks across relational database systems including MySQL, PostgreSQL, DB2, and SQLite. You will install and configure databases, manage users, perform backups and recovery, optimize performance, and automate routine administrative tasks.