This course provides a complete, hands-on introduction to the newest release of Oracle Enterprise Edition. Key features of the product are discussed and demonstrated with a reduced emphasis on multitenant architecture.

Audience: This course is appropriate for anyone needing to learn key new features of Oracle12c. That would include end users, business analysts, application developers, database administrators and IT management.
Course Duration: 3 days
Prerequisites:

A thorough knowledge of Oracle11g database administration is required. It is also highly desirable participants be well versed in Oracle11g PL/SQL.

Course Outline:
  • SQL Enhancements
    • Major Enhancements
      • Top N and Bottom N Queries
      • Using Extended Datatypes
      • Concurrent UNION / UNION ALL Execution
      • Sequences with DEFAULT Values
      • Sequences with Global Temporary Tables
      • IDENTITY Columns
      • New Sequence Functionality for Oracle Replay
      • Invisible Columns
      • Temporal Validity
      • Pattern Matching
    • Miscellaneous New SQL Features
    • Data Model Review
    • Lab One – SQL Enhancements
    • Lab One Solutions – SQL Enhancements
  • PL/SQL Enhancements
    • White Lists
    • The WITH Clause for Functions
    • Pragma UDF
    • New Inquiry Directives
    • New DBMS_SQL Functionality
    • Enhanced Language Interface Features
    • Miscellaneous New PL/SQL Features for Oracle12c
    • Lab Two – PL/SQL Enhancements
    • Lab Two Solutions – PL/SQL Enhancements
  • Installation / Upgrading
    • Overview of Database Creation
    • The Oracle Universal Installer
    • Prerequisite Tasks
      • Memory Requirements
      • Hardware Requirements
      • Software Requirements
      • Package Requirements
      • What About Windows?
    • Running the Installer
    • Post Installation
    • Using the Database Configuration Assistant
    • Using the Database Configuration Assistant – Short Form
    • Database Templates
    • Upgrading the Database
    • Removing Oracle Software
    • Lab Three – Installation / Upgrading
    • Lab Three Solutions – Installation / Upgrading
  • Enterprise Manager Enhancements
    • Database Management Using EMDE
    • Environmental Variables
    • Accessing Enterprise Manager Database Express
      • Modified Functionality with EMDE Changing Parameters
      • Modification of Physical Structures
    • Deleted Functionality In EMDE
    • Database Administration with Other Tools
    • EMDE Access for Non-DBA Users
    • EMDE Access to Pluggable Databases
    • Lab Four – Enterprise Manager Enhancements
    • Lab Four Solutions – Enterprise Manager Enhancements
  • SQL Developer / SQL*PLUS
    • SQL Developer
    • Multitenant Connection Considerations
    • Using SQL Developer
    • SQL*PLUS for Oracle12c
      • Invisible Columns
      • New SHOW Commands
      • Last Login Time
      • Support for The New Administrative Privileges
      • Support for Pluggable Databases
    • Lab Five – SQL Developer / SQL*PLUS
    • Lab Five SOLUTIONS – SQL Developer / SQL*PLUS
  • Multitenant Databases
    • The Impact of Multitenant Architecture
    • Major Benefits of Multitenant Architecture
    • The Bird’s Eye View
    • Walking the Directories Of A Container Database
    • Who? What? When? Where? How?
    • Impacts of Multitenant Architecture
    • Tools for Use With Multitenant Architecture
      • SQL*Plus
      • DBCA
      • Oracle Enterprise Manager Cloud Control
      • SQL Developer
      • Server Control (SRVCTL)
    • Lab Six – Multitenant Databases
    • Lab Six Solutions – Multitenant Databases
  • Multitenant Basics
    • Creating CDBS
    • Features Unsupported for Multitenant Architecture
    • The Create Database Command
    • Seed Data Files
    • Configuring Enterprise Manager Database Express for CDBS
    • Using SQL Developer with CDBS as a Dba
    • Lab Seven – Multitenant Basics
    • Lab Seven Solutions – Multitenant Basics
  • Intermediate Multitenant
    • Options Available
    • The Create Pluggable Database Statement
      • The STORAGE Clause
      • File Locations Clause
      • TEMPFILE Clause
    • Preparing to Create PDBS
    • Creating PDBS Using the CDB Seed
      • Specifics Using SQL*Plus
    • Cloning an Existing Local PDB
      • Specific Cloning Steps
    • Cloning an Existing Remote PDB
      • Specific Cloning Steps
      • Effects of Cloning a Remote PDB
    • Unplugging a PDB
    • Creating a PDB By Plugging-In an Unplugged PDB
    • Creating a PDB From A NON-CDB Database
      • Using DBMS_PDB
    • New Trigger Types For PDBS
      • The BEFORE UNPLUG Trigger
      • The AFTER CLONE Trigger
    • Lab Eight – Intermediate Multitenant
    • Lab Eight Solutions – Intermediate Multitenant
  • Automatic Data Optimization
    • Storage and Compression Tiering
    • The Heat Map
    • Automatic Data Optimization
    • Compression Levels
  • In-Database Archiving
    • To Keep or Not To Keep
    • The Row Archival Clause
    • ORA_ARCHIVE_STATE
    • Row Archival Visibility
    • Lab Nine – In-Database Archiving
    • Lab Nine Solutions – In-Database Archiving

 

  • Auditing Enhancements
    • Unified Auditing
    • Enabling Unified Auditing
    • Disabling Unified Auditing
    • Handling Earlier Audit Records
    • Creating A SEC_ADMIN Account
    • Creating A Unified Audit Policy
    • Automatic Audits with Unified Auditing
    • Disabling / Dropping Audit Policies
    • Immediate-Write vs. Queued-Write Mode
    • Audit Data Cleanup
    • Lab 10 – Auditing Enhancements
    • Lab 10 Solutions – Auditing Enhancements
  • Privilege Enhancements
    • Considerations Regarding Password Case Sensitivity
    • Profiles and Password Policies
    • Roles in Oracle12c
    • Separation of Duty
    • Inherit [ ANY ] Privileges
    • Permission Control Within Views
    • Database Privilege Analysis
      • Restrictions on Privilege Analysis
      • Potential Benefits of Privilege Analysis
      • Privilege Analysis in Container Databases
      • Privilege Analysis Policies
      • Disabling A Privilege Analysis Policy
      • Generating A Privilege Analysis Report
      • Dropping A Privilege Analysis Policy
    • Significant Changes to Roles and Privileges
    • Lab 11 – Privilege Enhancements
    • Lab 11 Solutions – Privilege Enhancements
  • Data Redaction
    • Overview of Data Redaction
    • Exemption from Redaction Policies
    • How and When Redaction Occurs
    • Redaction Examples
    • FUNCTION_PARAMETERS for Partial Redaction
    • Using Regular Expressions
    • Using Random Values in Redaction
    • The Expression Parameter
    • ENABLE / DISABLE / DROP Redaction Policies
    • Using RES for Partial VARCHAR2 Redactions
    • REDACTION_POLICIES / REDACTION_COLUMNS
    • Lab 12 – Data Redaction
    • Lab 12 Solutions – Data Redaction
  • RMAN / FDA Enhancements
    • New Backup Super User
    • RMAN Connections
    • Select and Describe from within RMAN
    • Simpler SQL Commands
    • Duplicate with NOOPEN
    • Cross-Platform Backup and Restore
    • Recovery Over a Network
    • Storage Snapshot Technology
    • Table and Partition Recovery
    • Multi-Section Backups on Very Large Files
    • Active Database Duplication Enhancements
    • Tablespace Transports Across Platforms and Endianness
      • Convert at Source
      • Restore from Converted at Source
      • Convert at Target
      • Restore from Converted at Target
    • Standby Database Updating
    • Data Guard Enhancements
    • Oracle Scheduler Script Jobs
    • Lab 13 – RMAN / FDA Enhancements
    • Lab 13 Solutions – RMAN / FDA Enhancements
  • DB Operations
    • Database Operations
    • Do Monitoring Use Cases
    • Enabling Database Operations Monitoring
    • Db Operations Monitoring Architecture Overview
    • Do Attributes
    • Using DBMS_SQL_MONITOR
      • BEGIN_OPERATION Function
      • END_OPERATION Procedure
      • REPORT_SQL_MONITOR Function
    • Simple Database Operations Monitoring Example
    • The Active Report Type
    • New Optimizer Hints
    • Lab 14 – DB Operations
    • Lab 14 Solutions – DB Operations
  • Schema and Data Changes
    • Database Changes
    • Change Management Capabilities
    • The DBMS_COMPARISON Package
    • The Create Comparison Procedure
    • The Compare Function
    • Discovering Differences
    • The Converge Procedure
    • The Recheck Function
    • The DBA_COMPARISON_COLUMNS View
    • Lab 15 – Schema and Data Changes
    • Lab 15 Solutions – Schema and Data Changes
  • SQL Tuning
    • Adaptive Execution Plans
    • DBMS_XPLAN And Adaptive Execution Plans
    • SQL Plan Directives / Extended Statistics
    • Enhanced Statistics Gathering
    • Histogram Enhancements
    • Lab 16 – SQL Tuning
    • Lab 16 Solutions – SQL Tuning
  • Real-Time ADDM / Performance
    • The Automatic Database Diagnostic Monitor
    • Real-Time ADDM
    • Emergency Monitoring / Current ADDM Findings
    • Monitoring the Database with EMDE
    • Using the Performance Hub
      • The Summary Tab
      • The RAC Tab
      • The Activity Tab
      • The Workload Tab
      • The Monitored SQL Tab
      • The ADDM Tab
      • The Current ADDM Findings Tab
      • The Database Time Tab
      • The Resources Tab
      • The System Statistics Tab
      • Workload Repository Reports
      • Modifying Automatic Snapshot Settings
    • Using Other Advisors
      • SQL Tuning Advisor Details
      • The Automatic SQL Tuning Advisor
      • SQL Access Advisor
    • Database Replay
    • Workload Intelligence Overview
    • Workload Dimensions
    • Reports
    • SECUREFILES
    • PGA_AGGREGATE_LIMIT
    • Real Application Testing
    • Patch Inventory Package
    • Statistics Enhancements
      • Automatic Column Group Detection
      • Concurrent Statistics Gathering
      • Incremental Statistics Enhancements
      • Global Temporary Tables Session-Private Statistics
      • Reporting Mode
      • Past Statistics Collection Reports
    • Lab 17 – Real-Time ADDM / Performance
    • Lab 17 Solutions – Real-Time ADDM / Performance
  • Table / Index Enhancements
    • Creating Multiple Indexes on Columns
    • Advanced Row Compression
    • Online Redefinition Enhancements
    • DML_LOCK_TIMEOUT
    • Editioning Enhancements
  • ADR / Network Enhancements
    • ADR Directory Structure
    • ADR Command Interpreter Enhancements
    • Advanced Network Compression
    • Multiprocess / Multithreaded Architecture
    • Very Large Network Buffers
  • Data Loading Enhancements
    • Data Pump Enhancements
      • Data Pump VIEWS_AS_TABLES
      • Transform Clause Enhancements
      • New Parameters
    • Log Miner Enhancements
    • Full Transportable Export / Import
    • SQL*LOADER Enhancements
      • SQL*Loader Express Mode
      • SQL*Loader Enhancements
      • SQL*Loader / External Table Common Enhancements
  • Partitioning Enhancements
    • Moving Partitions Online
    • Interval-Reference Partitioning
    • Enhanced Cascade Functionality
    • Operating on Multiple Partitions
    • Partial Indexes
    • Global Index Maintenance
    • Controlling Statistics Gathering for Partitions
  • New Features In 12.1.0.2 – Time Permitting
    • About 12.1.0.2
    • Advanced Index Compression
    • APPROX_COUNT_DISTINCT
    • Attribute Clustering
    • Big Table Caching
    • Flashback Data Archive Support for CDBS
    • Full Database Caching
    • In-Memory Aggregation
    • In-Memory Column Store
      • Working with Tables
      • Working with Columns
      • Working with Tablespaces
      • Working with Materialized Views
      • Data Pump and INMEMORY
    • Support for JSON
    • Fips 140 Encryption Parameter
    • PDB Containers Clause in Queries
    • OMF File Replacement for PDBS
    • The PDB Logging Clause
    • PDB Metadata Clones
    • PDB Remote Clones
    • Platform Support for PDB Snapshot Cloning
    • The PDB Standbys Clause
    • State Management for PDBS Across PDB Restart
    • PDB Subset Cloning
    • Rapid Home Provisioning
    • Zone Maps
  • Deprecations and Desupports – Time Permitting
    • Deprecated Features
    • Desupported Features
    • Deprecated Parameters
      • Networking
      • Database
    • Deprecated Views