Relational Database Administration (DBA)

Por: Coursera . en: , ,

  • Introduction to Database Management
    • 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.
  • Managing Databases
    • 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!
  • Monitoring and Optimization
    • 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.
  • Troubleshooting & Automation
    • 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.
  • Final Assignment and Final Exam
    • In this module, you’ll complete your final course project, which brings together concepts and practices you previously learned in the first four modules. In this three part assignment, you will perform database administration tasks across 3 different databases. You will start by installing and configuring a database, managing users and performing a backup. You will move on to recovery, indexing, optimization and automation of routine tasks. Finally you will restore a database, create an index, create a view and connect to a database from the command line.