Download PDF
of this course

Certification Exam Prep Seminar: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP (EPUCADB12C)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 1 Day

Price: SGD 322.00

This exam prep seminar helps you prepare to take the Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP certification exam.

  • Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP (1Z0-067)

*Prices are subject to change based on location.

Exam Prep Seminars:

  • Provide a thorough review of exam objectives.
  • Illustrate the breadth of topics and skills necessary to pass the exam.
  • Give exclusive tips and strategies to prepare for the certification exam.
  • Increase confidence.

This seminar is for exam review purposes only and does not meet the Hands-on Course training requirement (if applicable to your certification track). We recommend that candidates who have no experience or have not completed any relevant training, opt for the associated training package instead.

 

Who Should Attend

  • Database Administrators
  • Project Manager
  • Sales Consultants
  • Technical Consultant

Course Certifications

This course is part of the following Certifications:

Prerequisites

Course Objectives

  • Receive tips and information that will help you on the test.
  • Learn from one of Oracle University's top instructors.
  • Review key technologies and certification concepts related to Oracle Database 12c: Advanced Administration.
  • Understand the depth and breadth of the Oracle Database Administrator.
  • Get information that will help you complete your preparation and study.

Course Content

Part I: Database Administration

  • Installing Oracle Database 12c
  • Upgrading to Oracle Database 12c
  • EM Express and Migration Assistant for Unicode
  • Monitoring and Managing Memory
  • Storage Management
  • Resumable Space Allocation and Segment Shrinking
  • Managing Space
  • Managing Undo Data

Part I: Database Administration – Section 2

  • Security
  • Oracle Data Redaction
  • Auditing
  • Administrative Privileges and Privilege Analysis
  • Using Globalization Support
  • Automating Tasks with the Scheduler
  • Loading and Unloading Data
  • Migrating Data by Using Oracle Data Pump

Part I: Database Administration – Section 3

  • Managing Resources
  • Proactive Performance Management
  • Using the SQL Tuning and Access Advisors
  • Managing Database Performance
  • Information Lifecycle Management and Storage Enhancements
  • In-Database Archiving and Valid-Time Temporal

Part II: Backup and Recovery

  • Backup and Recovery Concepts
  • Performing User Managed Backups
  • Performing User Managed Recovery
  • Configuring Recovery Manager
  • Using the RMAN Recovery Catalog
  • Basics of Using RMAN to Create Backups
  • Additional RMAN Backup Types
  • Using the RMAN Recovery Catalog

Part II: Backup and Recovery – Section 2

  • Basics of Using RMAN to Create Backups
  • Additional RMAN Backup Types
  • Additional Recovery Tasks
  • Performing Tablespace Point-in-Time Recovery
  • Automatic Storage Management
  • Using RMAN to Duplicate a Database
  • Using Flashback Technologies
  • Detecting Database Corruption

Part II: Backup and Recovery – Section 3

  • Dealing with Database Corruption
  • Using Data Recovery Advisor
  • Diagnosing the Database
  • Transporting Data

Part III: Managing Multitenant

  • Multitenant Container and Pluggable Database Architecture
  • Configuring and Creating CDBs and PDBs
  • Managing CDBs and PDBs
  • Managing Tablespaces, Common and Local Users, Privileges, and Roles (in CDB/PDBs)
  • Performing Back up, Recovery, and Flashback for a CDB/PDB
  • Managing Performance in a Multitenant Architecture
  • Moving Data, Performing Security Operations, and Interacting with Other Oracle Products (for CDB/PDBs)

 

Course ID: EPUCADB12C


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register