|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/relational-database-administration
课程评论：没有评论
课程名称：关系数据库管理（DBA） 课程概述： 在数据库管理系统的安全性和性能中，持续和主动的管理至关重要。数据库管理员负责管理数据库系统的操作方面，确保应用程序高效利用数据库，并合理有效地使用物理资源。在本课程中，您将了解管理数据库的一些活动、技巧和最佳实践，包括配置和升级数据库服务器软件及相关产品、数据库安全性、用户身份验证的实施、角色分配及对象级权限管理。同时，您也将学习如何在系统故障的情况下执行备份和恢复程序。 课程内容包括优化数据库性能、监控数据库、收集诊断数据及访问错误信息以帮助解决问题。由于许多任务是重复性的，您将学习如何调度维护活动和定期诊断测试，并发送任务成功或失败的自动消息。 课程大纲： 1. **数据库管理导论**：介绍数据库管理的多种信息，包括相关任务和典型工作日的概貌，涵盖从数据库设计到错误规划与排除的活动。通过实验，获得关于服务器对象、配置及数据库对象（如模式、表、触发器和事件）的实践经验。 2. **数据库管理**：学习如何备份和恢复数据库，这些过程是组织健康和快速响应系统变化的关键。通过实践实验，了解创建备份的重要性以及定义相关政策和程序。同时学习数据库安全和用户管理，包括创建和重置用户密码、创建用户组等。 3. **监控与优化**：学习如何创建和维护基准、性能指标和标准，监控内存和磁盘使用、连接及缓存统计。同时认识数据库优化的概念，包括更新统计、优化慢查询、索引类型及索引创建和使用。 4. **故障排除与自动化**：学习基本的故障排除过程，以帮助数据工程师发现常见问题，如连接、登录、配置及实例状态。了解如何自动化许多数据库功能，从管理警报到使用标准Linux和Unix shell命令或cron任务生成和发送报告。 5. **期末作业和期末考试**：完成最终课程项目，将前四个模块中学习的概念和实践整合。此三部分作业将涵盖MySQL、PostgreSQL、DB2和SQLite等不同数据库的管理任务，包括安装和配置数据库、用户管理及备份，再到数据恢复、索引、优化及日常任务的自动化。最后，您将还原数据库、创建索引、创建视图并从命令行连接数据库。
Name:Introduction to Database Management
Description: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.
Name:Managing Databases
Description: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!
Name:Monitoring and Optimization
Description: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.
Name:Troubleshooting & Automation
Description: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.
Name:Final Assignment and Final Exam
Description: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 different databases such as MySQL, PostgreSQL, DB2 and SQLITE. 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.
Ongoing and proactive management is critical to the security and performance of database management systems. Database administration is the function of managing the operational aspects of database systems and maintaining them. Database administrators work to ensure that applications make the most efficient use of databases and that physical resources are used adequately and efficiently. In this course, you will discover some of the activities, techniques, and best practices for managing a database. You will learn about configuring and upgrading database server software and related products. You will also learn about database security; how to implement user authentication, assign roles, and assign object-level permissions. You will also gain an understanding of how to perform backup and restore procedures in case of system failures. You will learn about how to optimize databases for performance, monitor databases, collect diagnostic data, and access error information to help you resolve issues that may occur. Many of these tasks are repetitive, so you will learn how to schedule maintenance activities and regular diagnostic tests and send automated messages of the success or failure of a task.
