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

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Prerequisites:

This Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Training course assumes that students have experience with Oracle Database 12c Release 1 features and functions. Specifically, included in this pre-requisite understanding should include topics such as:
• Installing and configuring an Oracle Grid Infrastructure
• Implementing and managing Oracle Database 12c
• Managing database solutions by using performance, tuning, and Program Global Area (PGA) optimization
• Creating fast-recovery solutions
• Configuring and managing Oracle Net Services
• Managing resources by using Resource Manager and Database Resource Manager
• Implementing security features
• Creating and managing database objects
• Using Recovery Manager for backup and recovery
• Implementing Data Pump for secure and efficient data movement
• Creating Oracle Flashback Database, SQL Tuning Advisor and Automatic Database Diagnostic Monitor
• Implementing Oracle Database Application Performance Tuning
• Database Performance Tuning using ASH & AWR
• Configuring and using Oracle Audit Vault
• Using Flashback Log /Flashback Table/ Flashback Transaction
• Implementing Oracle Database 12c security features
• Setting up and Managing Oracle Multitenant
• Managing Resources Using Multitenant
• Installing and Configuring Oracle Database Resource Manager
• Backup and Recovery for Multitenant
• And more.