Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1/1Z0-060

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Certification Training Course Overview

The Oracle Database 12c R2: New Features for 12c R1 Administrators course is intended for existing 12c Release 1 DBAs. In addition to the New Features of R2, this course also familiarizes students to the Oracle Database Cloud Service. In the course one learns about new and improved features of Oracle Database 12c Release 2 ( amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability, partitioning and SQL. Participants also learn to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools

Audience: The course targets:

Database Administrators, Support Engineers, System Administrators and Technical Consultants

This course prepares you for Exam 1Z0-060.

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 3100
18 - 22 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 05 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3550
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Global objectives of the course
  • Lessons grouped by area
  • Schedule of the wee
Module 2: Application Containers and Applications
  • Application root and application PDBs
  • Create and manage an application container
  • Install application in an application container
  • Patch application
  • Upgrade application
  • Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map
Module 3: Security in PDBs
  • Create users commonly, locally in application containers
  • Grant privileges commonly, locally in application containers
  • Difference between common and local roles in application containers
  • Grant roles commonly, locally in application containers
  • Difference between common and local objects in application containers
  • Difference between common and local profiles in application containers
  • Manage PDB lockdown profiles
  • Create unified auditing policies operations in application containers
Module 4: PDBs Creation Using New Methods
  • Create a PDB from CDB seed enhancements
  • Unplug into a PDB archive file and plug using the archive file
  • Create a local UNDO tablespace at PDB level
  • Hot cloning
  • Near-zero downtime PDB relocation
  • Create a remote proxy PDB
Module 5: PDBs Recovery and Flashback
  • Shut down a PDB when an essential PDB datafile is missing
  • Flashback at PDB level
  • Flashback a PDB to a clean PDB restore point
Module 6: Performance in PDBs
  • View CDB / PDB ADDM analysis
  • Manage SGA and PGA at the PDB level
  • Share resources between PDBs
Module 7: Upgrade and Other Operations in PDBs
  • Upgrade a CDB to 12.2
  • Upgrade a PDB to 12.2 by using unplug / plug / upgrade
  • Use cross-platform non-CDB or PDB backupsets to import into a CDB
Module 8: Privileges and User Profiles
  • New 12.2 SYSRAC administrative privilege
  • Password file enhancements
  • Grant administrative privileges to external users
  • Migrate the password file from pre-12 or 12.1 to 12.2
  • New system privilege INHERIT ANY REMOTE PRIVILEGES and object privilege INHERIT REMOTE PRIVILEGES
  • Enhance the security of administrative users
  • Pre-configure a maximum number of days in the user profile for which a user can remain inactive
Module 9: Unified Auditing
  • Create and enable audit policies for all users to whom the role is granted directly
  • Capture VPD (Virtual Private Database) generated predicates
Module 10: Data Redaction
  • New redaction format library in EM GUI
  • Redaction policy expression
  • New redaction functions
Module 11: Data Encryption
  • Encrypt / decrypt / rekey tablespaces online
  • Specific tablespaces: SYSAUX, SYSTEM, UNDO and temporary
Module 12: Transparent Sensitive Data Protection
  • Use TSDP with Unified Auditing
  • Use TSDP with Fine-Grained Auditing (FGA)
  • Use TSDP with Transparent Data Encryption (TDE)
Module 13: Availability Enhancements
  • Non auto-login support for duplicate: Use encrypted backups whose decryption keys are in a non auto-login wallet
  • Update and drop the catalog without entering the UPGRADE CATALOG and DROP CATALOG commands twice: UPGRADE / D
  • Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Re
  • REPAIR FAILURE command
  • Transport Data Across Platforms
  • Steps to recover a table
  • Describe online redefinition supports
Module 14: Oracle Data Pump, SQL*Loader and External Tables
  • Oracle Data Pump enhancements
  • SQL*Loader enhancements
  • External table enhancements
Module 15: In-Memory Column Store
  • Dynamic parameter in 12.2 : INMEMORY_SIZE
  • Caches results of frequently evaluated expressions and virtual columns for subsequent reuse
  • Optimizing joined columns by creating join groups
  • Interaction with other products, features
Module 16: SQL Tuning
  • SQL Performance Analyzer enhancements
  • SQL Plan Management enhancements
  • Statistics Gathering Performance Improvements: Optimizer Statistics Advisor
  • SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
  • New ways of SQL processing
  • Continuous Adaptive Query Plans
Module 17: Resource Manager and Other Performance Enhancements
  • Manage session PGA limit
  • Reduce Cursor Invalidations for DDLs
  • Describe the Advanced Index Compression (HIGH)
  • Define real-time materialized views with on query computation
  • Use ON STATEMENT refresh when a DML operation takes place on materialized views without the need to committhe transacti
  • Describe HCC data compression with ADO row-level policy
Module 18: Partitioning
  • Explain auto-list partitioning
  • Composite partitioning
  • Explain multicolumn list partitioning
  • Read-only partition
  • Defer subpartition segment creation
  • Filter data during partition maintenance operations
Module 19: Manageability
  • Start / stop a DBOP by specifying the Session ID and Serial#
Module 20: Diagnosability
  • Set a retention target to ADR for an automatic delete of ADR files
  • Use the retention advisor
  • Install TFA Collector by default for RDBMS (with RDBMS root scripts)
  • Start TFA Collector
  • Allow Data Pump tracing to be changed without stopping and then restarting the job
  • MV refresh statistics
Module 21: Oracle Database Cloud Services
  • Describe the Oracle Database Cloud Services console
  • Create a database deployment under 12.2
  • Database deployment backup and recovery automatic procedures
  • Differences between database deployments and on-premises databases
  • Migrate on-premises database to Oracle Database Public Cloud Services
Module 22: SQL Enhancements
  • Describe the new SQLcl utility
  • Use new 128 bytes length for database objects
  • Recall SQL*Plus commands in the same session from memory
  • Use the new VALIDATE_CONVERSION function
Download Course Contents

Request More Information

Course Prerequisites
  • Oracle Database 12C R1

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

  • Create and manage application containers and applications in multitenant container databases.
  • Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives. Perform pluggable database flashback.
  • Upgrade the multitenant container databases and pluggable databases.
  • Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption.
  • Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
  • Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
  • Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
  • Monitor your databases by using DB operations enhancements.
  • Benefit from enhancements in partitioning methods.
  • Benefit from ADR automatic space file management.
  • Use the Trace File Analyzer collector to diagnose issues.
  • Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
  • Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
  • Describe the Oracle Public Cloud services related to databases management.

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c R2 New Features 12c R1 Administrators Ed 1 Training Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.