Skip Navigation LinksHome > Vendors > Oracle > D97103

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

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

Audience

  • End Users
  • Database Administrators
  • System Administrator

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: