fbpx

Oracle Database 12c R2: New Features for 12c R1 Administrators

//////Oracle Database 12c R2: New Features for 12c R1 Administrators

Oracle Database 12c R2: New Features for 12c R1 Administrators

Course ID: D93517 5 Days Singapore
   

Oracle Database 12c R2: New Features for 12c R1 Administrators

No Schedule

Overview

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.

Learn To:

  • 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 (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.

This product is currently out of stock and unavailable.

Description

WHO SHOULD ATTEND

  • Database Administrators
  • System Administrator
  • Support Engineer
  • Technical Consultant

Course Certifications

Required Exam

PREREQUISITES

  • Knowledge of Oracle Database 12c and particularly 12.1.0.2
  • Oracle Database 12c R1: New Features for Administrators Ed 2

Suggested Prerequisites:

  • Oracle Database 12c: Install and Upgrade Workshop
  • Using Oracle Enterprise Manager Cloud Control 12c Ed 2

OBJECTIVES

  • 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

Module 1: Introduction

Module 2: Application Containers and Applications

Module 3: Security in PDBs

Module 4: PDBs Creation Using New Methods

Module 5: PDBs Recovery and Flashback

Module 6: Performance in PDBs

Module 7: Upgrade and Other Operations in PDBs

Module 8: Privileges and User Profiles

Module 9: Unified Auditing

Module 10: Data Redaction

Module 11: Data Encryption

Module 12: Transparent Sensitive Data Protection

Module 13: Availability Enhancements

Module 14: Oracle Data Pump, SQL*Loader and External Tables

Module 15: In-Memory Column Store

Module 16: SQL Tuning

Module 17: Resource Manager and Other Performance Enhancements

Module 18: Partitioning

Module 19: Manageability

Module 20: Diagnosability

Module 21: Oracle Database Cloud Services

Module 22: SQL Enhancements

What’s Next

  • Oracle Database 12c: RAC Administration Ed 1
  • Oracle Database 12c R1: High Availability New Features Ed 1
  • Oracle Database 12c: Data Guard Administration

Subscribe to our mailing list for special offers and promotions.

Processing...
Thank you! Your subscription has been confirmed. You'll hear from us soon.
ErrorHere