Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1
- Course Code D93517
- Duration 5 days
Course Delivery
Additional Payment Options
-
GTC 49 inc. VAT
GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details
Jump to:
Course Delivery
This course is available in the following formats:
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopThe 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.
In the lessons, you learn the new and enhanced 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.
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.
Course Schedule
TopTarget Audience
Top- Technical Consultant
- Support Engineer
- System Administrator
- Database Administrators
Course Objectives
Top- 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 & 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
Course Content
Top- Introduction
- Application Containers and Applications
- Security in PDBs
- PDBs Creation Using New Methods
- PDBs Recovery and Flashback
- Performance in PDBs
- Upgrade and Other Operations in PDBs
- Privileges and User Profiles
- Unified Auditing
- Data Redaction
- Data Encryption
- Transparent Sensitive Data Protection
- Availability Enhancements
- Oracle Data Pump, SQL*Loader and External Tables
- In-Memory Column Store
- SQL Tuning
- Resource Manager and Other Performance Enhancements
- Partitioning
- Manageability
- Diagnosability
- Oracle Database Cloud Services
- SQL Enhancements
Course Prerequisites
Top- Knowledge of Oracle Database 12c and particularly 12.1.0.2
- Oracle Database 12c R1: New Features for Administrators Ed 2
- D93517
- Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1
- Database Management & Development
- D93517 | Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 | Training Course | Oracle.
- Oracle