Oracle 12c New Features Course


Course Details

Length: 3 day(s)      Public Class Price: $1,680/person      Group Onsite Price: Request Quote      Course Category: Oracle | 202202 oracle-12c-new-features

Course Description:

This 3-day course shows the myriad new and enhanced capabilities available in the latest Oracle Database release. You'll learn everything you need to know to get up and running quickly on Oracle Database 12c. Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12c; Architectural changes, such as Oracle Multitenant; The most current information on upgrading and migrating to Oracle Database 12c; The pre-upgrade information tool and parallel processing for database upgrades; Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System; Oracle RMAN enhancements, including cross-platform backup and recovery; Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync; SQL, PL/SQL, DML, and DDL new features; Improvements to partitioning manageability, performance, and availability; Advanced business intelligence and data warehousing capabilities; Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges; Manageability, performance, and optimization improvements


Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider.. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.

Group Classes for Businesses - Onsite at Your Office

Have a group of employees needing the same training? We can come onsite to your office and hold a course. Request Free Quote

Corporate Classes - Classes are $1,680 per employee.

Upcoming Class Dates: Click dates below to register & view location/attendance options. Must register at least 14 days before class.


Course Lessons:


1: Getting Started with Oracle Database 12c
Downloading and Staging Oracle Database 12c
Preparing to Install Oracle Database 12c
Installing and Deinstalling Oracle Database 12c
The Death of Database Control and Birth of Database Express
Accessing Database Express

2: Upgrading and Migrating to Oracle Database 12c
Introductory Comments
New Features Related to Upgrading to Oracle Database 12c
Preparing for an Upgrade to Oracle Database 12c
Upgrading to Oracle Database 12c with the Database Upgrade Assistant
Upgrading to Oracle Database 12c Manually
Migrating to Oracle Database 12c with Oracle Data Pump
Rolling Back the Upgrade
Miscellaneous Changes to Be Aware of After Upgrading

3: Oracle Multitenant
Introducing Oracle Multitenant
CDBs and PDBs and the Data Dictionary
Creating, Deleting, and Modifying PDBs
Using Oracle Multitenant as a Consolidation Tool
Oracle Multitenant and Resource Management
Administration of CDBs and PDBs
Backup and Recovery of CDBs and PDBs

4: Oracle Grid Infrastructure
Flex Clusters
Flex ASM
ASM Enhancements
ACFS Enhancements

5: Backup, Recovery, and Data Guard New Features
RMAN-Related New Features
Oracle Data Guard New Features

6: Oracle Database 12c SQL and PL/SQL New Features
Oracle Database 12c DML New Features
Oracle Database 12c DDL New Features
Oracle Database 12c PL/SQL New Features

7: Partitioning Enhancements
Moving Partitions Online
Interval-Reference Partitioning
Cascade Functionality
Partition Maintenance Operations on Multiple Partitions
Partial Indexes
Global Index Maintenance
Automatic Global Statistics

8: Business Intelligence and Data Warehousing
Advanced Analytics
OLAP
Information Lifecycle Management
Temporal History
Performance Enhancements

9: Security New Features
Auditing
Privilege Analysis
Data Redaction
Miscellaneous Security Improvements
Mixing and Matching Security Features

10: Oracle Database 12c Manageability New Features
Online Operations
Database Monitoring and Administration
Miscellaneous Manageability Features

11: Oracle Database 12c Performance New Features
Statistics-Related New Features
Optimizer-Related New Features

12: Other Oracle Database 12c New Features
Data Pump Export and Import New Features
Oracle SQL*Loader Enhancements
Oracle External Table Enhancements
Oracle Log Miner Enhancements
ADR DDL and Debug Logs
Oracle SecureFiles Enhancements
Oracle R Enterprise, Hadoop, and MapReduce
CloneDB
SQL Translation Framework

Oracle Classes by Location

Albany Oracle classes       Louisville Oracle classes      
Allentown Oracle classes       Lubbock Oracle classes      
Amarillo Oracle classes       Malvern Oracle classes      
Atlanta Oracle classes       Melville Oracle classes      
Austin Oracle classes       Memphis Oracle classes      
Baton Rouge Oracle classes       Miami Oracle classes      
Beaver Creek Oracle classes       Midland Oracle classes      
Bedford Oracle classes       Milwaukee Oracle classes      
Bentonville Oracle classes       Minnetonka Oracle classes      
Billings Oracle classes       Mobile Oracle classes      
Birmingham Oracle classes       Naples Oracle classes      
Boston Oracle classes       New Orleans Oracle classes      
Bridgewater Oracle classes       New York City Oracle classes      
Burlington Oracle classes       North Charleston Oracle classes      
Burlington Oracle classes       Oklahoma City Oracle classes      
Charlotte Oracle classes       Omaha Oracle classes      
Chattanooga Oracle classes       Peachtree Corners Oracle classes      
Cheshire Oracle classes       Pensacola Oracle classes      
Chicago Oracle classes       Philadelphia Oracle classes      
Cincinnati Oracle classes       Pittsburgh Oracle classes      
Cleveland Oracle classes       Portland Oracle classes      
Columbus Oracle classes       Raleigh Oracle classes      
Dallas Oracle classes       Roanoke Oracle classes      
Des Moines Oracle classes       Rochester Oracle classes      
Erie Oracle classes       Saginaw Oracle classes      
Fairfax Oracle classes       San Antonio Oracle classes      
Fort Lauderdale Oracle classes       Sioux Falls Oracle classes      
Frederick Oracle classes       South Bend Oracle classes      
Grand Rapids Oracle classes       St. Louis Oracle classes      
Henderson Oracle classes       Stamford Oracle classes      
Houston Oracle classes       Tallahassee Oracle classes      
Huntsville Oracle classes       Tampa Oracle classes      
Indianapolis Oracle classes       Tulsa Oracle classes      
Jackson Oracle classes       Virginia Beach Oracle classes      
Jacksonville Oracle classes       Waco Oracle classes      
Knoxville Oracle classes       West Palm Beach Oracle classes      
Largo Oracle classes       White Plains Oracle classes      
Laurel Oracle classes       Wilmington Oracle classes      
Lexington Oracle classes       Winter Park Oracle classes      
Livonia Oracle classes      

Course Benefits

Quality Instructors

Live online instruction allows complete interaction between students & instructor.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.