Relational Database Administration (DBA)

Welcome to your first module on database administration. During this module, you’ll be introduced to a wide variety of information, including an overview of the types of tasks involved in database management and what a typical workday may look like. You will see that many tasks revolve around activities ranging from designing databases to planning and troubleshooting errors. At the end of the module, there will be several labs where you will gain hands-on experience learning about server objects, configurations, and database objects, including schemas, tables, triggers, and events.

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.