· Database Warehouse Administrator

· Database Administrators

· Database Designers

· Support Engineer

· Technical Administrator

· Working knowledge of SQL and use of PL/SQL packages

· Oracle Database 12c R2: Administration Workshop Ed 3

Suggested Prerequisites:

· Basic knowledge of Linux operating system

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

· Perform backup, recover and flashback operations on a multitenant container database and regular and application pluggable databases

· Perform particular operations like Oracle Data Pump transportation, loading, encryption, auditing

· Upgrade an Oracle Database 12.1 CDB or PDB to an Oracle Database 12.2 CDB or PDB

· Monitor pluggable databases in the Cloud

· Understand the multitenant architecture

· Understand regular and application pluggable databases

· Create and manage a multitenant container database and pluggable databases

· Manage storage within a multitenant container database and pluggable databases

· Manage security within a multitenant container database and regular and application pluggable databases

· Monitor performance and manage resources within a multitenant container database and pluggable databases

· Configure and create a CDB

· Create a new PDB from the CDB seed

· Explore the instance

· Explore the structure of PDBs

· Explore the Automatic Diagnostic Repository (ADR)

· Describe application containers in CDBs

· Explain the purpose of application root and application seed

· Define application PDBs

· Create application PDBs

· Explain application installation on top of application containers

· Install an application

· Upgrade and patch applications

· Describe the commonality concept in application contexts

· Clone a regular PDB

· Clone an application PDB

· Unplug and plug a non-CDB

· Unplug and plug a regular PDB

· Unplug and plug an application container

· Convert regular PDBs to application PDBs

· Configure and use the local UNDO mode

· Perform hot cloning and relocation

· Establish connections to CDB and PDB

· Start up and shut down a CDB

· Open and close PDBs

· Avoid service name conflicts

· Start PDB service

· Change the different modes and settings of PDBs

· Evaluate the impact of parameter value changes

· Configure host name and port number per PDB

· Manage permanent tablespaces in CDB and PDBs

· Manage temporary tablespaces in CDB and PDBs

· Manage the UNDO tablespaces in CDB root and PDB

· Manage common and local users, roles, privileges and profiles in PDBs

· Manage common and local objects in application containers

· Enable common users to access data in PDBs

· Manage PDB lockdown profiles

· Audit users in CDB and PDBs

· Manage other types of policies in application containers

· Protect data with Database Vault policies in CDB and PDBs

· Encrypt data in PDBs

· Backup CDB and PDBs

· Recover a PDB from essential file damage

· Recover a PDB from non-essential file damage

· Use RMAN backups to plug unplugged PDBs

· Duplicate PDBs

· Validate CDBs and PDBs

· Perform CDB flashback

· Perform PDB flashback

· Monitor operations in a CDB and PDBs

· Monitor performance in a CDB and PDBs

· Manage SGA and PGA limits at the PDB level

· Manage AWR snapshots at the CDB and PDB levels

· Run ADDM tasks for CDB and PDB recommendations

· Manage application shared object statistics

· Control query DOP involving the containers() construct

· Control PDB IO rate limits

· Manage resource allocation between PDBs and within a PDB

· Manage PDB performance profiles

· Avoid excessive session PGA

· Export from a non-CDB and import into a PDB

· Export from a PDB and import into a PDB

· Export from a PDB and import into a non-CDB

· Use SQL*Loader to load data into a PDB

· Upgrade 12.1 CDB to 12.2

· Upgrade 12.1 PDBs to PDBs in 12.2

· Plug in a remote PDB through XTTS into a target CDB

· Describe the limits of data replication

· Describe XStreams usage with PDB and CDB

· Describe Data Guard with CDB and PDB

· Schedule operations in a PDB using Oracle Scheduler

· Mine PDB statements using LogMiner

· Create a database deployment in the Cloud

· Create PDBs in the Cloud database using DBaaS Monitor

· Understand encryption in a Cloud CDB and PDBs

· Manage PDBs in the Cloud database using DBaaS Monitor

· Migrate on-premises PDBs in a database deployment in the Cloud