Oracle Database 12c: New Features for Administrators

Course details

In the Oracle Database 12c: New Features for Administrators course, you’ll learn about the new and enhanced features of Oracle Database 12c. Expert instructors will teach you how these features increase security, manageability and performance.

Explore the Following New Features:

• Online Data-file Move
• Heat Map
• Automatic Data Optimization
• Temporal history
• Temporal validity
• Row-archival
• Unified Auditing
• Administrative privileges
• Privilege Analysis
• Data Redaction
• Adaptive Execution Plans
• SQL Plan Directives
• Real-Time ADDM
• Compare Period ADDM
• Data Pump
• Partitioning
• SQL

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Multitenant Architecture

After a brief review of the Oracle Enterprise Manager Cloud Control 12c and Enterprise Manager Database Express, you'll learn the new concept of multitenant architecture, its benefits and usage. This includes tasks like creating, managing, monitoring, backing up and recovering multitenant container database and pluggable databases.

Hands-on Practices and Demonstrations

Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 12c. You'll explore using Oracle Enterprise Manager Cloud Control and other tools like Oracle Enterprise Manager Database Express SQL Developer to manage, monitor and administer your data center.

Audience

• Administrator
• Database Administrators
• System Administrator

Related Training

• Required Prerequisites
• Good knowledge of Oracle Database 11g

Suggested Prerequisites

• Good knowledge of Oracle Database 11g
• Oracle Enterprise Manager Cloud Control 12c: Install & Upgrade
• Using Oracle Enterprise Manager Cloud Control 12c NEW

Course Objectives

• Create, manage and monitor multitenant container database and pluggable databases
• Manage datafile online operations, data lifecycle management with heat map and automatic data optimization, archive data using Row-archival or Temporal Validity and Temporal Histor
• Set up the unified audit trail
• Understand and use the new privileges, such as SYSBACKUP, SYSDG, SYSKM and manage privilege analysis
• Create and manage Data Redaction masking policies
• Use the Recovery Manager enhancements
• Manage the database performance with monitoring DB operations, Real-Time ADDM and Compare Period ADDM Compare two databases using Schema Change Plans to propagate changes from one environment to another Use Data Comparisons to compare data across environments
• Tune the SQL performance using Adaptive Execution Plans, SQL Plan Directives and statistics enhancements
• Manage resources in a multitenant container database and pluggable databases with enhanced Resource Manager
• Explore new Oracle Data Pump features and SQL*Loader Express Mode
• Use online operations during partition movement and compression, and other DDL operations
• Use partial global partitioned indexes
• Explain new SQL enhancements such as extended data type column and SQL row limiting clause

Course Topics

• 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 and Migration
• 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
• Schema and Data Changes 
• SQL Tuning
• Real-Time ADDM and Compare Period Advisor
• Resource Manager and Other Performance Enhancements
• Index and Table Enhancements
• ADR and Network Enhancements
• Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
• Partitioning Enhancements
• SQL Enhancements