|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-oracle-database-backup-and-security/
课程评论：没有评论
**课程名称：** Oracle数据库备份与安全入门 **课程概述：** 本课程是Oracle数据库管理中至关重要的备份和安全主题的实践入门。Oracle数据库作为广泛使用的关系数据库管理系统（RDBMS），其数据的完整性和安全性至关重要。数据库管理员（DBA）的主要职责之一就是设计、实施和管理数据库的备份与恢复策略，以防止数据丢失并能在出现损失后重建数据库。 此外，本课程还将深入探讨Oracle数据库提供的安全特性，包括**身份验证**（确保合法用户访问）、**授权**（确保用户仅访问其被允许的资源）以及**审计**（跟踪数据库活动）。 **您将学到：** * 如何执行完整的数据库备份。 * 如何执行数据库还原和恢复操作。 * 使用Flashback技术查看和检索历史数据。 * 如何恢复和检索已删除的表。 * 如何建立数据库的安全措施，防止未经授权的访问。 * 如何管理数据库用户角色和权限。 * 如何启用归档日志模式。 * 如何审计Oracle数据库用户活动。 * 了解并管理预定义的Oracle用户账户。 **课程结束时，您将能够：** * 熟练地备份和恢复Oracle数据库。 * 有效地管理数据库用户访问和安全性。 * 成功地恢复已删除的表。 * 熟练运用Oracle Flashback技术。
Oracle Database is a relational database management system -RDBMS that is widely used by a lot of organisations to store and manage their data.Database backup and recovery as well as securing the database from unauthorized access are key tasks performed by Database administrators or anyone that closely works with or looks after databases.As a backup administrator, your principal duty is to devise, implement, and manage a backup and recovery strategy. In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss.The Oracle database provides security in the form of authentication, authorization, and auditing. Authentication ensures that only legitimate users gain access to the system. Authorization ensures that those users only have access to resources they are permitted to access.This course is a practical hands-on that will teach you how to: • Perform a full database backup • Perform a database restore and recovery • View and retrieve historical data using Flashback technology • Recover and retrieve dropped tables • Establish security measures to protect the database • Manage user roles and privileges to the database • Enabling Archive log mode • Auditing Oracle Database users • Predefined Oracle user accountsAfter the end of this course , you will know how to: • Backup and restore a database • Manage database user access and security • Recover dropped tables • Use Oracle flashback technology.
