Oracle Database 12c R2: New Features for Administrators Part 2 (D97103)

Oracle Database 12c R2: New Features for Administrators Part 2 (D97103)

Overview

Duration: 4 days

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Manage security by using Unified Auditing
  • Manage security by using privileges and profiles
  • Manage security by using Privilege Analysis
  • Manage security by using Data Redaction
  • Manage security by using Transparent Data Encryption
  • Manage security by using Transparent Sensitive Data Encryption
  • Describe the new RMAN enhancements
  • Manage data availability by using new features of Oracle Data Pump, SQL*Loader and external tables
  • Manage data availability by performing online operations
  • Manage data partitioning
  • Manage Information Lifecycle by using ADO
  • Manage Information Lifecycle by using In-Database Archiving and Temporal features
  • Describe database operations
  • Configure and use In-Memory Column Store
  • Use In-Memory Caching
  • Use Real Application Testing enhancements
Module 1: Introduction

Module 2: Auditing Using Unified Audit

Module 3: Controlling Data Access Using Privileges and Profiles

Module 4: Controlling Data Access Using Privilege Analysis

Module 5: Redacting Data

Module 6: Encrypting Data

Module 7: Controlling Data Access Using Transparent Sensitive Data Protection

Module 8: Making Data Available by Using RMAN Features

Module 9: Making Data Available by Using Oracle Data Pump, SQL*Loader and External Tables

Module 10: Making Data Available by Performing Online Operations

Module 11: Partitioning Data

Module 12: Managing Information Lifecycle Using ADO

Module 13: Managing Information Lifecycle Using In-Database Archiving and Temporal

Module 14: Monitoring DB Operations and Performance

Module 15: Configuring In-Memory Column Store

Module 16: Using In-Memory Column Store

Module 17: Improving Performance Using In-Memory Caching

Module 18: Improving SQL Performance

Module 19: Using Real Application Testing Enhancements

Module 20: Improving Performance Using Other Features
N/A
  • Knowledge of Oracle Database 11g R2
  • Knowledge of Oracle Multitenant Container Database architecture

Suggested Prerequisites:

  • Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 NEW
  • Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade Ed 2
Course ID:
D97103


Show Schedule for: