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

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

Required Prerequisite

• Knowledge of Oracle Database 11g R2

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course constituted by three modules; the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems, students 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.

• Create and manage pluggable databases
• Describe the challenges and benefits of a sharded database
• Handle the ADR 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

• Amministratore di database
• Amministratori di Sistema
• Utente finale

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