|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-1z0-083/
课程评论：没有评论
Coursera 课程“1Z0-083 Oracle Database Administration”是一门全面的数据库管理培训课程，旨在帮助学员获得 Oracle Database Administration 2019 认证专业人士的资格。 **课程亮点：** * **核心技能培养：** 课程涵盖 Oracle 数据库（最高至 19c）的安装、升级、补丁管理、SQL 编程、数据库及网络管理、备份与恢复等关键技能。 * **高级主题深入：** 学员还将深入学习多租户架构（CDBs, PDBs, Application PDBs）、SQL 性能监控以及故障诊断等多项高级数据库管理技术。 * **实践操作导向：** 通过 Recovery Manager (RMAN) 进行数据库备份、恢复、复制和迁移，以及多租户容器数据库的创建与管理，强调实践操作能力。 * **故障排除与性能优化：** 课程教授如何诊断数据库故障，利用 Flashback 技术进行恢复，并通过 AWR、ADDM 等工具和 SQL Tuning Advisor 等方法进行性能监控与调优。 * **Grid Infrastructure 与高可用性：** 重点讲解 Oracle Grid Infrastructure 的安装、配置与管理，以及 Oracle Restart 的使用，保障数据库的高可用性。 * **最新特性介绍：** 课程还包含 Oracle Database 19c 的新特性介绍，如可用性增强、诊断增强等，确保学员掌握最前沿的技术。 **课程大纲（部分）：** * **多租户架构管理：** 创建 CDBs 和 PDBs，管理 PDB 服务名和连接，控制资源使用，执行 PDB 备份、恢复与复制。 * **备份与恢复：** RMAN 备份与恢复策略，全量及增量备份，压缩与加密，备份归档，恢复文件备份，ASM 元数据备份。 * **Flashback 技术：** 配置数据库支持 Flashback，执行 Flashback 操作，以及 Flashback 数据库。 * **数据库复制与迁移：** 使用 RMAN 进行数据库复制和数据传输。 * **安装与补丁：** Grid Infrastructure 和 Oracle Database 的安装，以及补丁的打法。 * **升级：** Oracle Grid Infrastructure 和 Oracle Database 的升级流程与实践。 * **应用 PDBs 管理：** 应用根和应用种子，创建应用 PDBs，应用管理。 * **安全性管理：** 多租户数据库的安全性管理，审计用户。 * **故障诊断：** 数据库和数据块损坏的检测与修复，RMAN 故障诊断。 * **性能监控与调优：** 内存管理，AWR，ADDM，SQL 优化，SQL 调优顾问。 通过完成此课程，学员将具备全面管理 Oracle 数据库的能力，并为通过 1Z0-083 考试奠定坚实基础。
An Oracle Database Administration Certified Professional has proven theoretical understanding of and the practical skills required to configure and manage Oracle Databases up to and including Oracle 19c. Passing this 2nd exam in a 2 exam path proves your skills in: installation, upgrades, patching, SQL programming skills, database and network administration and backup and recovery. This person also demonstrates fluency with some advanced skills such as multi-tenant, SQL performance monitoring and problem determination.What is Oracle 1Z0-083 Exam?Oracle Database Administration II (1Z0-083) exam will help candidates to become Oracle Database Administration 2019 Certified Professional. They are professionals with theoretical understanding and skills required for configuring and managing Oracle Databases up to and including Oracle 19c.What skills candidates will gain in the Oracle 1Z0-083 Exam?In this candidates will gain the skills and knowledge for:Installing, patching and upgrading Oracle DatabaseOracle Grid Infrastructure for a standalone serverCreating and managing a backup and recovery strategy using Recovery Manager (RMAN)Using RMAN for Database duplication and transportationDiagnosing failures using RMANManaging all aspects of Multitenant container databases, pluggable databases and application containers including the creationWhat is the course outline for Oracle 1Z0-083 Exam?Some of the main areas in the Oracle 1Z0-083 exam are:Creating CDBs and Regular PDBsBackup and DuplicateManage Application PDBsRecovery and FlashbackBackup Strategies and TerminologyRestore and Recovery ConceptsUsing Flashback TechnologiesDuplicating a DatabaseDiagnosing FailuresTransporting DataInstall Grid Infrastructure and Oracle DatabaseCreating CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Configure and create a CDBCreate a new PDB from the CDB seedExplore the structure of PDBsManage CDBs and PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Manage PDB service names and connectionsManage startup, shutdown and availability of CDBs and PDBsChange the different modes and settings of PDBsEvaluate the impact of parameter value changesPerformance management in CDBs and PDBsControl CDB and PDB resource usage with the Oracle Resource ManagerBackup and Duplicate - Oracle Database: Managing Multitenant Architecture Ed 1Perform Backup and Recover CDBs and PDBsDuplicate an active PDBDuplicate a DatabaseUpgrading and Transporting CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Upgrade an Oracle DatabaseTransport DataManage Application PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Explain the purpose of application root and application seedDefine and create application PDBsInstall, upgrade and Patch applicationsCreate and administer Application PDBSClone PDBs and Application containersPlug and unplug operations with PDBs and application containersComparing Local Undo Mode and Shared Undo ModeManage Security in Multitenant databases - Oracle Database: Managing Multitenant Architecture Ed 1Manage Security in Multitenant databasesManage PDB lockdown profilesAudit Users in CDBs and PDBsManage other types of policies in application containersRecovery and Flashback - Oracle Database: Managing Multitenant Architecture Ed 1Restore and Recovering Databases with RMANPerform CDB and PDB flashbackBackup Strategies and Terminology - Oracle Database: Backup and Recovery WorkshopPerform Full and Incremental Backups and RecoveriesCompress and Encrypt RMAN BackupsUse a media managerCreate multi-section backups of very large filesCreate duplexed backup setsCreate archival backupsBackup of recovery filesBackup non database filesBack up ASM meta dataRestore and Recovery Concepts - Oracle Database: Backup and Recovery WorkshopEmploy the best Oracle Database recovery technology for your failure situationDescribe and use Recovery technology for Crash, Complete, and Point-in-time recovryUsing Flashback Technologies - Oracle Database: Backup and Recovery WorkshopConfigure your Database to support FlashbackPerform flashback operationsDuplicating a Database - Oracle Database: Backup and Recovery WorkshopDuplicate DatabasesConfiguring and Using RMAN - Oracle Database: Backup and Recovery WorkshopConfigure RMAN and the Database for RecoverabilityConfigureand Using an RMAN recovery catalogDiagnosing Failures - Oracle Database: Backup and Recovery WorkshopDetect and repair database and database block corruptionDiagnosing Database IssuesPerforming Recovery - Oracle Database: Backup and Recovery WorkshopRestore and Recovering Databases with RMANPerform Non RMAN database recoveryTransporting Data - Oracle Database: Backup and Recovery WorkshopTransport DataRMAN Troubleshooting and Tuning - Oracle Database: Backup and Recovery WorkshopInterpret the RMAN message outputDiagnose RMAN performance issuesInstall Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopInstall Grid Infrastructure for a Standalone serverInstall Oracle Database softwarePatching Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopPatch Grid Infrastructure and Oracle DatabaseUpgrading to Oracle Grid Infrastructure - Oracle Database: Deploy, Patch and Upgrade WorkshopUpgrade Oracle Grid InfrastructureOracle Database 18c: New Features - Oracle Database: Deploy, Patch and Upgrade WorkshopImage and RPM based Database InstallationCreating an Oracle Database by using DBCA - Oracle Database: Deploy, Patch and Upgrade WorkshopCreate, Delete and Configure Databases using DBCAOracle Restart - Oracle Database: Deploy, Patch and Upgrade WorkshopConfigure and use Oracle Restart to manage componentsUpgrade the Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopPlan for Upgrading an Oracle DatabaseUpgrade an Oracle DatabasePerform Post-Upgrade tasksInstall Grid Infrastructure for a Standalone server - Oracle Database: Deploy, Patch and Upgrade WorkshopRapid Home ProvisioningUsing General Overall Database Enhancements - Oracle Database 19c: New Features for AdministratorsInstall Oracle Database softwareCreate, Delete and Configure Databases using DBCACreating CDBs and Regular PDBsUse Miscellaneaous 19c New FeaturesUsing Availability Enhancements - Oracle Database 19c: New Features for AdministratorsUse an RMAN recovery catalogUse Flashback DatabaseUsing Diagnosibility Enhancements - Oracle Database 19c: New Features for AdministratorsUse new Diagnoseability FeaturesMonitoring and Tuning Database Performance - Oracle Database: Administration WorkshopManaging Memory ComponentsUnderstanding The Automatic Workload Repository (AWR)Understanding The Advisory FrameworkMonitoring Wait Events, Sessions, and ServicesManaging Metric Thresholds and AlertsUnderstanding and Using The Performance Tuning MethodologyPerforming Performance PlanningUnderstanding The Automatic Database Diagnostic Monitor (ADDM)Tuning SQL Statements - Oracle Database: Administration WorkshopUnderstanding The Oracle OptimizerUsing The SQL Tuning AdvisorManaging Optimizer StatisticsUsing The SQL Access AdvisorUnderstanding The SQL Tuning Process
