> > D77758GC10

Oracle Database 12c: New Features for Administrators (D77758GC10)

Course Description Schedule Course Outline
 

Who Should Attend

  • Administrator
  • Database Administrators
  • System Administrator

Prerequisites

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 Content

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.

Multi-tenant 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.

Classroom Training
Modality: G

Duration 5 days

Price (VAT excl.)
  • Belgium: 3,350.- €
Dates and Booking
 
Click on the location to go directly to the booking page Schedule
Belgium

Currently no local training dates available.  For enquiries please write to info@flane.nl.

The Netherlands
11-02-2019 - 15-02-2019 Utrecht Enroll