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

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

Audience

End Users
Database Administrators
System Administrator

Content

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

Prerequisites

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

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for:

Enquiry Form