Oracle Database 12c R2: New Features for Administrators Part 1

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates5$5,000 USDPurchase


O12C: DBA NF2P1

Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1

The Oracle Database 12c R2: New Features for Administrators Part 1 course is constituted by three modules: the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems. You will receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases.

Duration: 5 Days

Prerequisites

  • Knowledge of Oracle Database 11g R2

Audience

  • Database Administrators
  • End Users
  • System Administrators

Learning Objectives

  • Create and manage pluggable databases
  • Describe the challenges and benefits of a sharded database
  • Understand the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as the new Multitenant architecture and the Sharded database architecture
  • Handle the Automatic Diagnostic Repository automatic file space
  • Diagnose database issues by using the Trace File Analyzer collector
  • Use the new SQL*Plus history commands and SQL enhancements such as long identifiers
  • Use the SQLcl new utility as the new SQL Command Line interface
  • Create and manage a multitenant container database

Topics

  • Using SQL New Features and SQLcl
  • Understanding CDB Basics
  • Creating CDB and Regular PDBs
  • Creating Application PDBs and Installing Applications
  • Managing CDB and PDBs
  • Managing Storage
  • Managing Security
  • Backing up, Recovering and Flashing Back
  • Managing Performance
  • Managing Resources Allocation
  • Moving and Migrating Data
  • Performing Miscellaneous Operations
  • Understanding Database Sharding
  • Diagnosing Database Problems
Right Menu IconMENU