Oracle Database 12c: New Features For Administrators (ORNFDB12C) – Outline

Detailed 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