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