Oracle认证专家(OCP)12C
Oracle认证专家(OCP)12C
  • 观看数
    11次
  • 课时
    0课时
  • 难度
    初级
Oracle认证专家(OCP)12C
价格: 6000.00元
购买课程 咨询客服
讲师:刘庚  | 开课时间:12月03日 09:00
上课地点: 杭州市文三路252号伟星大厦19楼A座
课程评价: (0人)
收藏 扫一扫 扫码用手机学习
课程介绍

课程一:Oracle Database: Introduction to SQL Ed 2

 

课程长度:2天/12小时

 

课程描述:

This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

 

Learn To: 

Understand the basic concepts of relational databases ensure refined code by developers.
Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects.
Manage schema objects.

Manage objects with data dictionary views. Retrieve row and column data from tables. Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.

 

培训对象:

Application Developers
Business Analysts
Data Warehouse Administrator
Developer
Forms Developer
PL/SQL Developer

System Analysts

 

课程目标:

Identify the major structural components of the Oracle Database 12c
Manage objects with data dictionary views
Manage schema objects
Retrieve row and column data from tables
Run data manipulation statements (DML) in Oracle Database 12c
Use scalar and correlated sub-queries
Utilize views to display data
Write SELECT statements that include queries
Write multiple-column sub-queries
Control database access to specific objects
Create reports of aggregated data
Create reports of sorted and restricted data
Create tables to store data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Employ SQL functions to retrieve customized data

 

 

培训内容:

Introduction
Working with Oracle Cloud Exadata Express Cloud Service
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones

 

 

 

课程二:Oracle Database 12c R2: Administration Workshop Ed 3

 

课程描述:

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

 

课程长度:4天/24小时

 

Learn To: 

Manage an Oracle Database instance.
Configure the Oracle Network environment.
Create and manage storage structures.
Manage and move data.
Create and manage users.
Monitor the database and manage performance.
Create and manage Database as a Cloud Service database deployments.

 

 

培训对象:

Data Warehouse Administrator
Database Administrators
Database Designers
Support Engineer
Technical Administrator

 

课程目标:

Back up, restore, and patch DBCS database deployments
Describe the DBaaS and on-premises Oracle Database architectures
Manage database instances
Manage UNDO data
Move data between databases
Implement basic backup and recovery procedures
Monitor and tune database performance
Tune SQL to improve performance
Manage resources with Oracle Database Resource Manager
Create pluggable databases (PDBs)
Configure the Oracle network environment
Administer user security and implement auditing
Create and manage tablespaces
Manage storage space
Create and manage Database as a Cloud Service (DBCS) database deployments
Register databases and manage performance with Enterprise Manager Cloud Control

 

 

培训内容:

Getting Started
Exploring Oracle Database Architecture
Managing Database Instances
Creating PDBs
Configuring the Oracle Network Environment
Administering User Security
Creating and Managing Tablespaces
Managing Storage Space
Managing UNDO Data
Moving Data
Backup and Recovery Concepts
Monitoring and Tuning Database Performance
SQL Tuning
Oracle Database Resource Manager
Enterprise Manager Cloud Control
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Managing DBCS Database Deployments
Backing Up and Restoring DBCS Database Deployments
Patching DBCS Database Deployments
Creating Master Encryption Keys for PDBs
Tablespace Encryption by Default

 

 

课程三:Oracle Database 12c R2:备份和恢复课堂练习第3 版

 

课程长度:4天/12小时

 

课程描述:

在“Oracle Database 12c R2:备份和恢复课堂练习”这一课程中,学生将学习如何基于相关的Oracle DB 体系结构组件执行备份和恢复。本课程介绍了各种备份、故障、还原和恢复方案,以便学生学会评估自己的恢复需求并针对备份和恢复过程制定合适的策略。本课程包括交互式课堂练习,学生可以利用其中的方案来诊断几种故障情况并进行恢复。对学生的益处学生有机会更深入地了解备份和恢复。对于DBA 而言,这可能是最重要的工作。本课程详细介绍备份和恢复所基于的概念和体系结构,以及在各种情况下以不同方式执行备份和恢复的步骤。学生将学习有关Recovery Manager (RMAN) 命令行界面的知识,该工具可用于各种备份、故障、还原和恢复方案,包括磁带备份和数据复制。上机练习课通过大量的上机练习和课堂练习方案,学生可以获得在真实技术环境中进行操作的经验。本课程包括交互式课堂练习,学生可以通过备份和恢复案例研究来学习诊断几种故障情况并进行恢复。完成本课程后,学生应能评估自身的恢复需求并针对备份和恢复过程制定合适的策略。

 

Learn To: 

Data Warehouse Administrator
Database Administrators
Support Engineer
Technical Administrator
Technical Consultant

 

 

课程目标:

配置数据库以实现可恢复性
描述用于备份和恢复的云工具
描述可用于解决数据库故障的 Oracle DB 备份方法和恢复操作
描述与备份和恢复操作相关的 Oracle DB 体系结构组件
执行加密数据库的备份和还原
执行表空间时间点恢复
计划有效的备份和恢复过程
使用 Oracle 闪回技术在发生人为错误后进行恢复
使用 Recovery Manager (RMAN) 创建备份并执行恢复操作
使用数据恢复指导对故障进行诊断和修复

 

培训内容:

简介
备份和恢复入门
针对可恢复性进行配置
使用 RMAN 恢复目录
备份策略和术语
执行备份
改进备份
使用由 RMAN 加密的备份
诊断故障
还原和恢复概念
执行恢复
RMAN 和 Oracle Secure Backup
使用闪回技术
使用闪回数据库
传输数据
执行时间点恢复
复制数据库
RMAN 故障排除和优化
用于备份和恢复的云工具
备份和恢复课堂练习

 

 

 

授课教师

Oracle资深讲师
Oracle认证讲师
国内著名Oracle数据库专家

现为博学国际教育培训中心高级讲师,主要负责Oracle数据库、MySQL数据库、大数据的企业内训和高级认证培训授课,开源新技术课程研发,老师培养等相关工作。

拥有认证:Oracle 10g 认证专家(OCM),Oracle 11g 认证专家(OCM),MySQL认证专家,Cloudera认证大数据专家CCA。

最新学员

暂无学员

学员动态

还没有动态
在线
咨询

服务时间: 8:00 - 22:00

客服热线: 40000-93353