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

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

Date
Time
Price
08-Apr-2019
10:00 AM BST - 06:00 AM BST
£ 2375
13-May-2019
03:00 PM BST - 11:00 AM BST
£ 2375
03-Jun-2019
03:00 PM BST - 11:00 AM BST
£ 2495
25-Jun-2019
08:00 AM BST - 05:00 AM BST
£ 2495
30-Sep-2019
02:00 PM BST - 10:00 AM BST
£ 2495
30-Mar-2020
03:00 PM BST - 11:00 AM BST
£ 2495
11-May-2020
08:00 AM BST - 04:00 AM BST
£ 2495
Date
Time
Price
Location
29-Apr-2019
02:00 PM BST - 10:00 AM BST
£ 0
Edison
24-Jun-2019
08:00 AM BST - 04:00 AM BST
£ 0
Stockholm
29-Jul-2019
02:00 PM BST - 10:00 AM BST
£ 0
Toronto
26-Aug-2019
03:00 AM BST - 11:00 PM BST
£ 0
Jakarta
09-Sep-2019
10:00 PM BST - 06:30 PM BST
£ 0
Auckland
21-Oct-2019
02:00 PM BST - 10:00 AM BST
£ 0
Toronto
21-Oct-2019
04:30 AM BST - 12:30 AM BST
£ 0
Bangalore
11-Nov-2019
08:00 PM GMT - 04:30 PM GMT
£ 0
Wellington
02-Dec-2019
02:00 PM GMT - 10:00 AM GMT
£ 0
King of Prussia
03-Feb-2020
01:00 PM GMT - 09:00 AM GMT
£ 0
Toronto
20-Apr-2020
08:00 AM BST - 04:00 AM BST
£ 0
Stockholm
Date
Start time
Price
Location
Version title
Price
Oracle Database 12c R2: New Features for 12c R1 Administrators
£ 2205

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.

Suggested Prerequisite

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

Required Prerequisite

  • CDT Oracle Database 12c: New Features for Administrators
  • Knowledge of Oracle Database 12c and particularly 12.1.0.2
  • Administrator
  • Database Administrator
  • Implementer
  • Systems Administrator
  • 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
  • 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
Need help finding the right course

Having problem finding the course you’re looking for? Get in touch.

£ 2375
5 Days
OU
7 Events available
5 Days
Edison
11 Events available
£ 2205
Train online via an Internet connection, 24/7
1 Event available
Share this Course
Get in touch
If you would like to find out how we can help you, please get in touch
Book a meeting
We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Print
Use the links below to print the details.
Convince your boss

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

Course 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.

Virtual Class
5 Days
Date
Start time
Price
Location
08-Apr-2019
10:00 AM BST
£ 2375
OU
13-May-2019
03:00 PM BST
£ 2375
OU
03-Jun-2019
03:00 PM BST
£ 2495
OU
25-Jun-2019
08:00 AM BST
£ 2495
OU
30-Sep-2019
02:00 PM BST
£ 2495
Live Virtual Class
30-Mar-2020
03:00 PM BST
£ 2495
Live Virtual Class
11-May-2020
08:00 AM BST
£ 2495
Live Virtual Class
Classroom
5 Days
Date
Start time
Price
Location
29-Apr-2019
02:00 PM BST
£ 0
Edison
24-Jun-2019
08:00 AM BST
£ 0
Stockholm
29-Jul-2019
02:00 PM BST
£ 0
Toronto
26-Aug-2019
03:00 AM BST
£ 0
Jakarta
09-Sep-2019
10:00 PM BST
£ 0
Auckland
21-Oct-2019
02:00 PM BST
£ 0
Toronto
21-Oct-2019
04:30 AM BST
£ 0
Bangalore
11-Nov-2019
08:00 PM GMT
£ 0
Wellington
02-Dec-2019
02:00 PM GMT
£ 0
King of Prussia
03-Feb-2020
01:00 PM GMT
£ 0
Toronto
20-Apr-2020
08:00 AM BST
£ 0
Stockholm
Training on Demand
Date
Start time
Price
Location
06-Mar-2019
03:17 AM GMT
£ 2205
Prerequisites

Suggested Prerequisite

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

Required Prerequisite

  • CDT Oracle Database 12c: New Features for Administrators
  • Knowledge of Oracle Database 12c and particularly 12.1.0.2
Audience
  • Administrator
  • Database Administrator
  • Implementer
  • Systems Administrator
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
Topics
  • 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