Oracle 19c OCP专家认证培训

课程介绍

1.Oracle Database Administration Workshop
After completing this course, you should be able to:
Describe Oracle Database architecture
Explain Oracle Database Cloud Service (DBCS) architecture and features
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance

2.Oracle Database Backup and Recovery Workshop
After completing this lesson, you should be able to:
Describe the curriculum context and course setup
Assess your recovery requirements
Describe types of database failures
Describe Oracle backup and recovery solutions
Describe the benefits of using Oracle Secure Backup and Oracle Data Guard
Describe the Oracle Maximum Availability Architecture

3.Oracle Database Managing Multitenant Architecture
After completing this lesson, you should be able to:
Describe the multitenant architecture
Describe the CDB root and pluggable database containers
Differentiate the CDB root from a pluggable database
Explain the terminology of commonality
List impacts in various areas

课程目标

Oracle Certified Professional (OCP) is an Oracle Certified Professional (OCP), an authoritative technical standard issued and enforced by Oracle Corporation for Certified professionals who are qualified to provide services and support for Oracle's core products, as well as have proven operational skills and extensive theoretical knowledge.With OCP International certification, you have the technical ability to manage a large Oracle database.Qualified to be the core database system engineer of a large enterprise, master the backup, advanced configuration, optimization and other advanced maintenance technologies of a large Oracle database on Linux/Unix platform, and be qualified to be the core engineering technician of a large database system，Become a true OCP expert.

课程大纲

DAY 1

一、Oracle Database Administration Workshop

1、Introduction

2、Oracle Database Architecture

3、Introduction to Oracle Database Cloud Service

4、Creating DBCS Database Deployments

5、Accessing an Oracle Database

DAY 2

6、Managing DBCS Database Deployments

7、Managing Database Instances

8、Understanding Oracle Net Services

9、Administering User Security

DAY 3

10、Creating PDBs

11、Creating Master Encryption Keys for PDBs

12、Creating and Managing Tablespaces

13、Managing Storage Space

DAY 4

14、Managing Undo Data

15、Moving Data

16、Backup and Recovery Concepts

17、Backup and Recovery Configuration

DAY 5

18、Creating Database Backups

19、Performing Database Recovery

20、Monitoring and Tuning Database Performance

21、SQL Tuning

DAY 6

二、Oracle Database Backup and Recovery Workshop

1. Introduction

2. Getting Started

3. Configuring for Recoverability

4. Using the RMAN Recovery Catalog

DAY 7

5. Backup Strategies and Terminology

6. Performing Backups

7. Improving Your Backups

8. Using RMAN-Encrypted Backups

Unit III: Recovery

9. Diagnosing Failures

10. Restore and Recovery Concepts

DAY 8

11. Performing Complete Recovery

12. Performing Point-in-Time Recovery

13. Additional Recovery Operations

14. Using Flashback Technologies

DAY 9

15. Using Flashback Database

16. Transporting Data

17. Duplicating a Database

18. RMAN Troubleshooting and Tuning

DAY 10

19. Backup and Recovery Workshop

DAY 11

三、Oracle Database Managing Multitenant Architecture

1. Basics

2. CDB and Regular PDB Creation

3. Application PDBs

4. Applications

DAY 12

5. Local Undo

6. PDB Hot Cloning

7. PDB Relocation

8. Proxy PDB

9. CDB and PDB Mgt

10. Storage

讲师信息

郭一军

云贝学院院长数据库知名讲师

腾讯云TVP，PostgreSQL ACE，腾讯云高级认证讲师，Oracle MySQL高级认证讲师，中国PostgreSQL分会高级认证讲师。ITPUB管理版资深版主，精通Oracle DSI（Data Server Internals），拥有Oracle OCM，阿里云ACE，AWS SAP等高级IT认证。从业20年，拥有十几年数据库的工作经验，历任过连连支付首席DBA、唯品会高级数据库专家、吉利汽车研究院云计算平台技术负责人。负责连连支付核心交易库的开发与运维、经历唯品会大规模（5000+个实例）MySQL数据库的架构设计和运维，主导吉利汽车上亿级的私有云项目及自能驾驶200Pb数据存储架构设计。有10+年的数据库授课经验，曾给腾讯技术区域中心、平安银行、昆山农商行、中国金融期货交易中心，浙江电力，安徽电力，浙江大学，武汉达梦，杭州邮储银行、安徽电信，浙江电信，嘉兴烟草等企业开展内训。针对个人的培训所培训学员遍布全球各个企业（有索尼、西门子、花旗、腾讯、阿里、百度、中兴、美团等公司），并在企业内负责重要的数据相关工作，已培训学员超10000+（OCM 500+,OCP 3000+，TDSQL TCP 100+,技术赋能7000+），深受学员好评。

推荐课程