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 (220.127.116.11) 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 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 .
Perform recovery and flashback operation on pluggable databases
Monitor multitenant container database and pluggable databases by using ADDM / AWR enhancements at PDB level
Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles
Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing
Benefit from enhancements in partitioning methods
Use the ADR automatic file space management
Use the SQLcl new utility as the new SQL command line interface
Create pluggable databases with new methods and local UNDO mode
Create and manage application containers and applications in multitenant container databases
Manage security in application containers
Manage data optimization in pluggable databases with heat map statistics and ADO policy eviction
Upgrade pluggable databases and multitenant container databases
Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Data Encryption
Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements and by performing online operations
Monitor your databases by using DB operations
Increase the SQL performance by using In-Memory Column-Store enhancements for deployment and SQL performance
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.