SkillBuilders Welcome  |  Log in
All Oracle Classes

Oracle 12c New Features Training

New Features for Administrators

4 Day Onsite or 28 Hour Online Hands-On Class w/ Oracle Certified Master John Watson

Release 12c of the Oracle database includes many features that will make the DBA's life easier and improve service for his or her users. There are also facilities that will reduce the need for hardware, licenses, and administration resources. And of course the potential for spectacular performance improvements.

In this class Oracle Certified Master John Watson will teach you the new features of Oracle 12c with many demonstrations and hands-on exercises, concentrating on those relevant to the DBA and also including some of interest to developers. There is minimal use of graphical tools (though Enterprise Manager Database Express is of course included). Students should be familiar with 10g or 11g database and instance architecture.

Particular emphasis is placed on techniques for configuring a 12c database for self-tuning and management. Most exercises and demonstrations use command line utilities, but EM Express is also available.

"Just wanted to say thank-you for the training.  Been at Acxiom 18 years come October.  And that was the best Oracle training I've received."

"The course provided WAY more information and training than I expected, and was well worth the time and expense."


Oracle Certified Master
John Watson
Average Student Rating:

Enterprise Manager Database Express

The Multitenant Option
    Multitenant architecture (including  Multitenant-single tenancy)
    Creating container databases and pluggable databases
    Common and local users and roles
    Service names
    Backup, restore, and flashback

Information Lifecycle Management
    Automatic Data Optimization
    In-Database Archiving
    Change control

Security
    Privilege analysis
    PL/SQL roles and privileges
    Data Redaction
    Transparent Sensitive Data Protection
    Bequeath views
    Unified Audit

SQL Performance
    SQL baselining
    Cardinality feedback and SQL directives
    Adaptive execution plans
    Extended statistics
    Histograms
    Dynamic sampling
    In-memory options

SQL enhancements   
    Identity columns
    Extended data types
    Row limit clause
    Sequences

Performance enhancements
    Real-time database monitoring
    ADDM, AWR, and ASH monitoring
    Resource Manager
    Multi-threaded architecture
    Temporary undo
    Flash cache

Table and index enhancements
    Partial indexes
    Multi-partition operations
    Global index maintenance
    Online move and redefinition
    Index and column visibility
    Online DDLs
    Compression

Utilities
    Recovery Manager
    Data Pump
    SQL*Loader

The Multitenant Option
  Multitenant architecture
              Creating container databases and pluggable databases
              Multitenant administration
Information Lifecycle Management
              Automatic Data Optimization
              In­Database Archiving
              Change control
Security
              Unified Audit
              Privileges
              Data Redaction
SQL enhancements
              Performance
              Data types
              Row limit clause
              Sequences
Performance enhancements
              Real­time database monitoring
              ADDM, AWR, and ASH monitoring
              Resource Manager
              Multi­threaded architecture
              Temporary undo
              Flash cache
Table and index enhancements
              Partitioning
              Redefinition
              Index and column visibility
              Online DDLs
              Compression
Utilities
              Recovery Manager
  Data Pump
  SQL*Loader
 
SkillBuilders Sample Video