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

Q: Is GST/ VAT applicable on the published fee?

No, the published fee includes all applicable taxes.

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

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 (12.2.0.1) 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 Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Customers who bought this course also bought

Developing Applications for the Java EE 7 Platform Ed 1

Oracle Database 12c: Advanced PL/SQL Certification Training Course - 1Z0-148

Oracle Database 19C:Administration Workshop Certification Training Course

R12.x Oracle General Ledger Management Fundamentals

10% discount on 2nd course:

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 12.1.0.2 CDB to 12.2
Upgrade a 12.1.0.2 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
Complete the operations with ALTER TABLESPACE ENCRYPTION FINISH ENCRYPT|REKEY|DECRYPT

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

Request a call back?

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.