Oracle認證專家(OCP)12C
Oracle認證專家(OCP)12C
  • 觀看數
    391次
  • 課時
    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

真人棋牌娱乐