Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle Database 12c New Features for Administrators

This course covers the training content for the 1Z0-060 Oracle Database 12c: New Features for Administrators exam.

GK# 7617

Course Overview

TOP

The release of Oracle Database 12c Oracle offers many new and enhanced features including support for Cloud computing and multitenant architecture to allow for the consolidation of data from multiple standalone systems. Oracle Database 12c also offers performance and manageability benefits, backup and recovery, as well as security and partitioning enhancements. This course will discuss and demonstrate how to use the new and enhanced features, which includes topics such as Real-Time ADDM, Schema Change Plans, CDBs and PDBs, online operations, ILM, Data Redaction, Recovery Manager, Oracle Data Pump, Adaptive Execution Plans, SQL Directives, and partitioning to name a few.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Enterprise Manager Cloud Control
  • Managing CDB and PDB, and Data Optimization
  • Using Automatic Data Optimization
  • Managing Security
  • High Availability and Database Management
  • Tuning SQL and Using ADDM
  • Resource Manager and ADR
  • Transporting Databases and Managing Data

Outline

TOP
Viewing outline for:

On-Demand Outline

Oracle Database 12c: Enterprise Manager Cloud Control

  • Describe the flow of communication between core Enterprise Manager Cloud Control components
  • Recognize how to manage credentials for Enterprise Manager Cloud Control
  • Identify the different type of tools Oracle provides for database management
  • Describe the multitenant architecture and its components
  • Identify how to create a CDB
  • Identify how to create a PDB
  • Identify the Enterprise Manager Cloud Control and CDB architectures and create CDB and PDBs in a given scenario

Oracle Database 12c: Managing CDB and PDB, and Data Optimization

  • Identify how to connect to, start up, and shut down a CDB
  • Identify how to create and manage permanent and temporary tablespaces in a CDB instance and PDBs
  • Identify how to create and manage common and local users in a CDB instance and PDBs
  • Identify how to manage privileges and roles in CDB and PDB
  • Identify how to perform CDB and PDB backups
  • Perform recovery of CDB in a given scenario
  • Recover PDBs in a given scenario
  • Identify how to manage CDBs and PDBs in a given scenario

Oracle Database 12c: Using Automatic Data Optimization

  • Sequence the steps taken to configure Heat Map and ADO in a given scenario
  • Identify how to create ADO compression policies
  • Identify how to manage ADO policies
  • Identify how to monitor ADO using views and procedures
  • Identify statements that describe how to move a data file and partitions online
  • Identify how In-Database Archiving is used within the Oracle 12c environment
  • Identify how Temporal Validity is used within the Oracle 12c environment
  • Identify how to use ILM features, In-Database Archiving, and Temporal Validity in a given scenario

Oracle Database 12c: Managing Security

  • Describe the features of Unified Audit Trail
  • Describe how to configure audit policies
  • Recognize the functions of the new administrative privileges
  • Describe the implementation of new administrative privileges
  • Sequence the steps to perform privilege analysis
  • Describe the characteristics of redaction policies
  • Use the new Oracle Database 12c security features

Oracle Database 12c: High Availability and Database Management

  • Identify the new RMAN enhancements in Oracle Database 12c
  • Sequence the steps to perform cross-platform data transport
  • Describe how to perform table recovery using RMAN
  • Describe how to implement Real-Time Database Operation Monitoring
  • Describe the characteristics of the new Schema Change Plans feature
  • Describe how the Data Comparison feature can be used
  • Use RMAN, Real-Time Database Operation Monitoring, and Schema and Change management in a given scenarios

Oracle Database 12c: Tuning SQL and Using ADDM

  • Describe the features of Adaptive SQL Plan management
  • Match the adaptive execution plans to descriptions of how they can be used
  • Identify how to use the statistics gathering performance enhancements
  • Distinguish between monitoring techniques in Oracle Database 12c
  • Identify how to use Compare Period ADDM
  • Tune and monitor an Oracle 12c environment in a given scenario

Oracle Database 12c: Resource Manager and ADR

  • Describe how to use Resource Manager in a CDB environment
  • Identify the characteristics of the multiprocess multithreaded architecture
  • Describe how the temporary undo feature can be used
  • Recognize how the new and enhanced features for tables, indexes, and online operations are used
  • Describe the new ADR and network enhancements in Oracle Database 12c
  • Use the new and enhanced performance and network features of Oracle Database 12c

Oracle Database 12c: Transporting Databases and Managing Data

  • Sequence the steps to complete a full transport of a database using Oracle Data Pump Full Transportable
  • Describe how the new Data Pump features in Oracle Database 12c is used
  • Identify how to use the new SQL*Loader features in Oracle Database 12c
  • Manage partitions in a given scenario in Oracle Database 12c
  • Recognize how to create and maintain partial local and global indexes for partitioned tables
  • Recognize how to configure extended datatypes in Oracle Database 12c
  • Use the row-limiting clause in a given scenario
  • Use the new and enhanced features of Data Pump, Partitioning, and SQL in a given scenario

Who Should Attend

TOP

This course is designed for Oracle Database Certified Professionals looking to upgrade their certification to Oracle Database 12c and Administrators, Database Administrators, and System Administrators who interested in the technical aspects of Oracle Database 12c and who may be considering upgrading their systems to this version.

Course Delivery

This course is available in the following formats:

On-Demand

Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.



Request this course in a different delivery format.
Enroll