Oracle Database 12c : OCP DBA Training & Certification Courses
 800 Ratings

Oracle Authorized Training Partner Expert Chat

Official Curriculum

#1 Offshore IT Training Company

Guarantee to Run the Classes

Overview

Oracle Database 12c OCP DBA certification provides advanced level expertise in administering Oracle databases while gaining deep understanding of underlying architecture and internal workings of this latest version of Oracle database 12c deployment. The OCP DBA credential in this latest version of Oracle Database 12c will help professionals confirm their advanced skills in complete database management and maintenance.

 

Course Content / Exam(s)

Schedule for Oracle Database 12c : OCP DBA

Course # Course Name Exam # Duration (days)
1Z0-061 Oracle Database: Introduction to SQL

Course Content

Course 1Z0-061: Oracle Database: Introduction to SQL

  • Retrieving Data using the SQL SELECT Statement
  • Introduction to Data Dictionary Views
  • Manipulating Data by Using Subqueries
  • Managing Data in Different Time Zones
  • Introduction
  • 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
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
1Z0-0615
Oracle Database 12c: Admin, Install and Upgrade Accelerated

Course Content

Course : Oracle Database 12c: Admin, Install and Upgrade Accelerated

  • Introduction
  • Exploring the Oracle Database Architecture
  • Oracle Software Installation Basics
  • Installing Oracle Database Software
  • Creating an Oracle Database by Using DBCA
  • Oracle Database Management Tools
  • Managing the Database Instance
  • Configuring the Oracle Network Environment
  • Administering Usersecurity
  • Managing Database Storage Structures
  • Managing Space
  • Managing Undo Data
  • Managing Data Concurrency
  • Implementing Oracle Database Auditing
  • Backup and Recovery Concepts
  • Backup and Recovery Configuration
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Performing Database Maintenance
  • Managing Performance
  • Managing Performance: SQL Tuning
1Z0-0625
Oracle Database 12c: Backup and Recovery Workshop

Course Content

Course : Oracle Database 12c: Backup and Recovery Workshop

  • Introduction
  • Getting Started
  • Configuring for Recoverablility
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups
  • Diagnosing Database Failures
  • Restore and Recovery Concepts
  • Performing Recovery, Part 1
  • Performing Recovery, Part 2
  • RMAN and Oracle Secure Backup
  • Performing Tape Backups and Restores
  • RMAN and Oracle Secure Backup Jobs
  • Using Flashback Technologies
  • Using Flashback Database
  • Managing Backup Space or Transporting Data
  • Duplicating a Database
  • RMAN Performance and Tuning
  • Backup and Recovery Workshop
1Z0-0635
Oracle Database 12c: Managing Multitenant Architecture

Course Content

Course : Oracle Database 12c: Managing Multitenant Architecture

  • Introduction
  • Container and Pluggable Database Architecture
  • CDB and PDB Creation
  • Managing a CDB and PDBs
  • Managing Storage in a CDB and PDBs
  • Managing Security in a CDB and PDBs
  • Managing Availability
  • Managing Performance
  • Miscellaneous
1Z0-0632
Total 17

Course Prerequisites

  • Familiarity with data processing concepts and techniques
  • Basic knowledge of Linux Operating System

Oracle Database 12c : OCP DBA Benefits

Upon Completion of this Course, you will accomplish following:-

  • Managing the performance of pluggable databases and multitenant container databases
  • Configuring resource manager for sharing resources between and within a multitenant container database and a pluggable database
  • Implementing unified auditing
  • Making use of SQL*Loader and Oracle Data Pump in pluggable databases
  • Monitoring the operations and performance of multitenant container database and pluggable database
  • Completely understand the multitenant architecture
  • Creating multitenant container databases from scratch
  • Creating pluggable databases using various prescribed techniques
  • Plugging a non-CDB into a multitenant container database
  • Administering the storage structures of multitenant container databases and pluggable databases
  • Creating and administering user accounts
  • Performing specific operations such as Oracle Data Pump loading, transportation, auditing, and encryption
  • Managing local and common user privileges and roles
  • Configuring backup and recovery operations for pluggable databases and multitenant container databases
  • Managing storage and security for pluggable databases and multitenant container databases

Recommended Courses and Certification:


Enquire Now

 


 
Loading...

Processing data, please wait...