D77758 | Oracle Database 12c R2: New Features for Administrators | Training Course | Oracle. Skip to main Content

Oracle Database 12c R2: New Features for Administrators

  • Course Code D77758
  • Duration 5 days

Course Delivery

Additional Payment Options

  • GTC 49 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

eur3.395,00

excl. VAT

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Download Course Details

Course Overview

Top

In the Oracle Database 12c: New Features for Administrators Ed 2 course, you’ll learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance. In this course, you will be introduced to Oracle Database Cloud Service.

 

Course Schedule

Top

Contact us for dates

Request Group Training Dates in Other Countries

Target Audience

Top
  • Database Administrators
  • Administrator
  • System Administrator

 

Show me more

Course Objectives

Top
  • Manage the Oracle multitenant container databases and pluggable databases.
  • Configure Heat Map and use Automatic Data Optimization.
  • Benefit from Online Datafile Move.
  • Understand the new Temporal capabilities as well as In-Database Archiving with Row-archival.
  • Enforce security with the Unified Auditing, the new administrative privileges, Privilege Analysis, and Data Redaction.
  • Increase SQL performance with the Database In-Memory option, and Full Database In-Memory Caching and the Automatic Big Table Caching features.
  • Benefit from optimizer enhancements such as Adaptive Execution Plans and SQL Plan Directives, Real-Time ADDM and Compare Period ADDM.
  • Use enhanced features of Resource Manager in multitenant container databases and pluggable databases.
  • Understand how and when to use enhancements in Data Pump, partitioning, and SQL.
  • Gain an understanding of the Oracle Database Cloud Service.

 

Show me more

Course Content

Top
  • Enterprise Manager and Other Tools
  • Basics of Multitenant Container Database (CDB)
  • Configuring and Creating CDB and PDBs
  • Managing CDB and PDBs
  • Managing Tablespaces, Common and Local Users, Privileges and Roles
  • Managing Backup / Recovery / Flashback
  • Online Datafile Move and Automatic Data Optimization
  • In-Database Archiving
  • Auditing Enhancements
  • Privileges Enhancements
  • Oracle Data Redaction
  • General RMAN New Features and FDA Enhancements
  • Monitoring DB Operations
  • Real-Time ADDM and Compare Period Advisor
  • ADR and Network Enhancements
  • In-Memory Column Store
  • In-Memory Caching
  • SQL Tuning
  • Resource Manager and Other Performance Enhancements
  • Index and Table Enhancements
  • Oracle Database Cloud Service: Overview

 

Show me more

Course Prerequisites

Top
Good knowledge of Oracle Database 11g is required.
Show me more

We Care About Your Privacy

We are using cookies to give you the best experience on our site. Cookies are files stored in your browser and are used by most websites to help personalise your web experience. By continuing to use our website without changing the settings, you are agreeing to our use of cookies.

Please only use paragraphs and links in this rich text field. A link to page with cookie info

About your Privacy

We process your data for purposes such as delivering content or advertisements and measuring the delivery of such content or advertisements to extract insights about our website. We may share this information with our partners. Cookies set by Global Knowledge are labelled “first party”; you may exercise your preferences in relation to first party cookies by toggling the switch for each first party cookie category below. The remaining cookies are third party cookies; you may exercise your preferences in relation to each purpose by toggling the relevant switch below or by vendor by clicking “List of IAB Vendors.” These choices will be signaled globally to other websites participating in the Transparency and Consent Framework.
Privacy Statement

Necessary Cookies

These are cookies that are required for the Global Knowledge website to function and cannot be switched off in our systems. They include, for example, cookies that enable you to use a shopping cart or log into the booking area of our website.

Analytics Cookies

Analytics cookies are an optional but important part of our website's functionality. They help us to understand how you interact with our site by collecting and reporting information anonymously. The data collected by analytics cookies is used to improve the website's performance and enhance the user experience. It is important to note that these cookies do not collect any personal information that can be used to identify you.

Preferences Cookies

These are optional and you can turn them off and on. Please only use 2 to 3 lines of text here and if needed link to a page with more cookie info in Intro.

Performance Cookies

These cookies allow us to recognise and count the number of visitors to our website, traffic sources and to see how website visitors move around the website when they are using it. This helps us to improve the way the website works and improve your website experience. All information these cookies collect is aggregated and therefore anonymous.

Cookie Control toggle icon