Oracle Database 12c: New Features For Administrators Training in O' Fallon

Enroll in or hire us to teach our Oracle Database 12c: New Features For Administrators class in O' Fallon, Missouri by calling us @303.377.6176. Like all HSG classes, Oracle Database 12c: New Features For Administrators may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Oracle Database 12c: New Features For Administrators may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
The single most important new capability introduced with the Oracle 12c release of the database is the multitenant database feature. With this technology, the Oracle database can be a full participant in a cloud computing-based application architecture. Even a traditional on-premise systems architecture can be dynamically and dramatically transformed as a result of this feature. Many traditional and new database features are enhanced or introduced when a multitenant database configuration is used. Introduced with the Oracle 12c release of the database are many advanced storage administration features. Some of these new features support various forms of in-memory storage, advanced compression and other capabilities targeted for high-performance environments and massive scalability. --- This course covers the training content for the 1Z0-060 Oracle Database 12c: New Features for Administrators exam.
Course Length: 5 Days
Course Tuition: $2400 (US)

Prerequisites

In order to fully benefit from this textbook one must have extensive experience working with the Oracle 11g release as a database or other administration specialist.

Course Outline

 
Oracle 12c & The Database Utilities
 
• About Oracle 12c
 
• Oracle 12c Universal Installer
 
• EM Cloud Control
 
• EM Database Express
 
• EM Database Express Framework & XML DB
 
• Access EM Database Express
 
• SQL Developer
 
• Instance Threaded Mode
 
• Invisible Columns
 
 
 
Database Security Enhancements
 
• Database Security Principles
 
• Database Privilege Changes
 
• Database Role Changes
 
• User Password Complexity
 
• Privilege Analysis
 
• Auditing Modes & Unified Auditing
 
• Configuring Unified Auditing & Enabling Policies
 
• Viewing & Maintaining The Audit Trail
 
 
 
ADR & Network Enhancements
 
• Fault Diagnosability Infrastructure
 
• Advanced Network Compression
 
 
 
Performance Improvements
 
• SQL Statement Execution
 
• Real-Time Operation Monitoring
 
• Real-Time ADDM Analysis
 
• Emergency Monitoring
 
• Real-Time ADDM
 
 
 
Fundamentals: The Multitenant Database Architecture
 
• Cloud Computing Principles
 
• Peering Into The Architecture
 
• Multitenant Database Instance
 
• Multitenant Storage Architecture
 
• Multitenant Data Dictionary
 
• Benefits Of The Architecture
 
• Challenges Of The Architecture
 
 
 
Fundamentals: Creating & Connecting To Multitenant Databases
 
• About cDB Capacity Planning
 
• cDB & pDB Creation
 
• Using Oracle Installer
 
• Using DBCA
 
• cDB & pDB Connections
 
• Using SQL*Plus
 
• EM Cloud Control
 
 
 
Fundamentals: Multitenant Database Security Management
 
• Multitenant Security Model
 
• Multitenant Privileges & Roles
 
• Common Users
 
• Local Users
 
• Common & Local Roles & Privileges
 
• Commonly & Locally Defined
 
• Commonly & Locally Granted
 
• Common & Local Profiles
 
• Common & Local Dictionary Access
 
• Multitenant Unified Auditing
 
• Local Audit Policies
 
• Querying The Unified Audit Trail
 
• Common Audit Policies
 
• Auditing Management With EM CC
 
 
 
Provisioning: Provisioning pDBs From pdb$seed
 
• Provision & Decommission pDBs
 
• EM CC Provisioning Prerequisites
 
• pDB File Location Prerequisites
 
• Provision A pDB From pdb$seed
 
• Provision Using SQL
 
• Provision Using EM CC
 
• Post Provisioning Checklist
 
• Drop A pDB
 
• Querying cDB & pDB Metadata
 
 
 
Provisioning: Additional pDB Provisioning
 
• Clone A pDB
 
• Unplug & Plug-In A pDB
 
• Migrate A Non-cDB To A pDB
 
• pDB Provisioning Using EM CC
 
• pDB Provisioning Using DBCA
 
 
 
Administration: Administering Multitenant Databases
 
• About Multitenant Administration
 
• cDB Administration
 
• cdb$root Administration
 
• pDB Administration
 
 
 
Administration: Multitenant Storage Management
 
• Manage Permanent Tablespaces
 
• Manage Temporary Tablespaces
 
 
 
Administration: Multitenant Backup & Recovery
 
• Devising Multitenant Recovery Plan
 
• RMAN Multitenant Usage
 
• RMAN Multitenant Backup
 
• EM CC Multitenant Backup
 
• RMAN Multitenant Recovery
 
• Complete Recovery
 
• Incomplete cDB / pDB Point-in-time Recovery (PITR)
 
• Incomplete Table Point-in-time Recovery (PITR)
 
• Multitenant Flashback Database
 
• EM CC Multitenant Recovery
 
• Multitenant Database Duplication
 
• cDB Duplication
 
• pDB Duplication
 
 
 
Administration: Multitenant Resource Management
 
• About Resource Management
 
• cDB Resource Plans & Directives
 
• pDB Resource Plans & Directives
 
 
 
Advanced Compression
 
• About Compression
 
• Table Compression
 
• Basic Table Compression
 
• Advanced Row Compression
 
• Additional Table Compression Considerations
 
• Index Compression
 
• Key Compression
 
• Advanced Index Compression
 
• Hybrid Columnar Compression
 
• Compression Analysis
 
• Using SQL Metadata Queries
 
• Using DBMS_COMPRESSION()
 
• Using EM CC
 
 
 
Heat Map Tracking & Automatic Data Optimization (ADO)
 
• About ILM
 
• The Oracle Database & ILM Support
 
• Heat Map Tracking
 
• Automatic Data Optimization (ADO)
 
• Adding ADO Policies Using SQL
 
• Managing ADO Policies Using SQL
 
• Managing ADO Policy Evaluation
 
• Managing ADO Policies Using EM CC
 
 
 
In-Memory Storage
 
• About Traditional Table Caching
 
• Big Table Caching
 
• Full Database Caching
 
• In-Memory Column Store
 
• IMCS Internals
 
• Configuring The IMCS
 
• Assigning Objects To The IMCS
 
• Assigning Columns To The IMCS
 
• Monitoring IMCS Using EM CC
 
 
 
In-Database Archiving
 
• About In-Database Archiving
 
• In-Database Archival Tables
 
• In-Database Archiving Of Rows
 
• Temporal Validity
 
 
 
Data Redaction
 
• About Data Redaction
 
• The Redaction Functions
 
• Using Function Type dbms_redact.random
 
• Using Function Type dbms_redact.partial
 
• Function Type dbms_redact.partial Shortcuts
 
• Using Function Type dbms_redact.regexp
 
• Function Type dbms_redact.regexp Shortcuts
 
• Defining Redaction Policies
 
• Managing Redaction Policies
 
• Customizing Full Redaction
 
• Viewing Redaction Metadata
 
• Using EM Cloud Control
 
• Inference Attacks

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.