The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.
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.
Benefits To You
In the lessons, you learn the new and enhanced features of Oracle Database 12c Release 2 (126.96.36.199) amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability, partitioning and SQL.
You also learn how to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools.
This Oracle database course is aimed at:
Application designers and developers
Web server administrators
Data centre support engineers
Chief Information Officers (CIO) and other information technology (IT) management professionals
This Oracle 12c New Features for Administrators course is designed to give existing Oracle 11g Database Administrators the knowledge and skills needed to implement the new features of 12c database. The Oracle Database 12c administrator will gain prac
This course considers new and advanced capabilities for the Oracle database and therefore has a number of prerequisites in order for one to fully benefit from the material.
It is recommended that delegates first complete the following courses, or have equivalent experience:
Oracle SQL Part 1 and Part 2
Oracle PL/SQL Programming Part 1 and Part 2
Oracle 12c Database Administration
Global objectives of the course
Lessons grouped by area
Schedule of the week
Application Containers and Applications
Application root and application PDBs
Create and manage an application container
Install application in an application container
Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map
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
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
Near-zero downtime PDB relocation
Create a remote proxy PDB
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
Performance in PDBs
View CDB / PDB ADDM analysis
Manage SGA and PGA at the PDB level
Share resources between PDBs
Upgrade and Other Operations in PDBs
Upgrade a 188.8.131.52 CDB to 12.2
Upgrade a 184.108.40.206 PDB to 12.2 by using unplug / plug / upgrade
Use cross-platform non-CDB or PDB backupsets to import into a CDB
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
Create and enable audit policies for all users to whom the role is granted directly
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.