Oracle Training
Oracle 12c New Features

by Certstaffix® Training

Length: 3 day(s)      Public Class Price: $1740/person (USD)      Group Onsite Price: Request Quote      Course Category: Oracle


Oracle Training
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.
Course Description: Print It | Download PDF | Email It

  Group Classes for Organizations - Onsite at Your Office How It Works

Have a group of employees needing the same training? Onsite training at your office is a great solution.  Request Free Quote

  • An expert Instructor will come to your office
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Public Corporate Classes - Live Online: Our Location or Yours How It Works

Certstaffix® Training public classes are instructor-led, live online training you attend in a local computer lab or from your home/office. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software you are being taught
  • Interaction with all students in the class at other locations
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options. You must register at least 15 days before class.



This course is available for private onsite training only.  Request a Quote


  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Related Certifications

Upgrade to Oracle Database 12c Certification


Course Topics

PRE-REQUISITE KNOWLEDGE REQUIRED:

Students attending this course should be experience Oracle users and DBA's with all knowledge covered in these two, 5-day courses: Oracle 12c/11g SQL & PL/SQL and Oracle 12c Database Administration
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
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

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.


Group Training

Have a group of several students needing the same training? Then onsite training is a perfect option for you. We'll come onsite to your office so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.

How Onsite Training Works

  • An expert Instructor will come to your office and personally train the students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Onsite Quote


Oracle 12c New Features Class Reviews

Here are a sample of Oracle class reviews from past students that have attended our Oracle training courses.



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.


Certstaffix® Class Reviews

Student Average:
4.85 out of 5 from 11 students

4.56 out of 5

The course was very useful and Mr. Jerry Richard presented the information clearly and effectively. I gained useful knowledge in SQL and PL/SQL.


- attended our Oracle 12c SQL & PL/SQL class

5.00 out of 5

Mr. Richard has an excellent teaching style. Normally I do not like virtual but he made it easy for me to learn and keep up. and was willing to take the time to make sure we all understood. The examples were a great help.


- attended our Oracle 12c SQL & PL/SQL class

4.62 out of 5

If you have prior experience with the subject, this is for you. But if you are really new on this, it can be challenging because the pace of this class is a little to fast for novices. the content, the book and professor Tom were great in general. maybe if the company change the length in time of this course would be perfect


- attended our Oracle 12c SQL & PL/SQL class

4.94 out of 5

I really enjoyed the class and learned a lot. Dr. Richard is a great instructor and very knowledge.


- attended our Oracle 12c SQL & PL/SQL class

5.00 out of 5

I hope to get Dave again for my upcoming DBA course with Certstaffix in Nov 2017. He was clear, patient (because I was slower than the other students), and kept us interested.


- attended our Oracle 12c SQL & PL/SQL class

4.94 out of 5


- attended our Oracle 12c SQL & PL/SQL class

5.00 out of 5


- attended our Oracle 12c SQL & PL/SQL class

4.76 out of 5


- attended our Oracle 12c Database Administration class

4.88 out of 5


- attended our Oracle 12c Database Administration class

4.86 out of 5


- attended our Oracle 12c Database Administration class

4.82 out of 5


- attended our Oracle 12c SQL & PL/SQL class

Please contact us if we do not yet have any reviews or you would like more.

Oracle Courses By City:

AB - Calgary       FL - Tampa       NB - Saint John       PA - Scranton-Wilkes Barre      
AB - Edmonton       FL - Winter Park       NC - Asheville       PA - York      
AK - Anchorage       GA - Augusta       NC - Charlotte       PR - Puerto Rico      
AL - Birmingham       GA - Columbus       NC - Greensboro       QC - Montreal      
AL - Huntsville       GA - Peachtree Corners       NC - Raleigh       RI - Providence      
AL - Mobile       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AL - Montgomery       HI - Honolulu       ND - Bismarck       SC - Myrtle Beach      
AR - Bentonville       IA - Des Moines       ND - Fargo       SD - Sioux Falls      
AR - Little Rock       IA - Iowa City       NE - Lincoln       SK - Regina      
AZ - Phoenix       ID - Boise       NE - Omaha       SK - Saskatoon      
AZ - Tucson       IL - Chicago       NH - Bedford       TN - Chattanooga      
BC - Vancouver       IL - Rockford       NJ - Bridgewater       TN - Knoxville      
CA - Bakersfield       IN - Bloomington       NM - Albuquerque       TN - Memphis      
CA - Fresno       IN - Evansville       NM - Las Cruces       TN - Nashville      
CA - Los Angeles       IN - Fort Wayne       NM - Santa Fe       TX - Amarillo      
CA - Merced       IN - Indianapolis       NS - Halifax       TX - Austin      
CA - Modesto       IN - South Bend       NV - Henderson       TX - Beaumont      
CA - Napa       KS - Topeka       NV - Reno       TX - Corpus Christi      
CA - Oakland       KY - Lexington       NY - Albany       TX - Dallas      
CA - Oxnard       KY - Louisville       NY - Buffalo       TX - El Paso      
CA - Rancho Cucamonga       LA - Baton Rouge       NY - New York City       TX - Fort Worth      
CA - Sacramento       LA - Lafayette       NY - Rochester       TX - Houston      
CA - Salinas       LA - New Orleans       NY - Syracuse       TX - Killeen      
CA - San Diego       LA - Shreveport       OH - Beaver Creek       TX - Laredo      
CA - San Jose       MA - Burlington       OH - Cincinnati       TX - Longview      
CA - Santa Maria       MA - Springfield       OH - Cleveland       TX - Lubbock      
CA - Santa Rosa       MA - Westborough       OH - Columbus       TX - McAllen      
CA - Stockton       MB - Winnipeg       OH - Toledo       TX - Midland      
CO - Boulder       MD - Largo       OH - Youngstown       TX - San Antonio      
CO - Colorado Springs       MD - Laurel       OK - Oklahoma City       TX - Tyler      
CO - Denver       ME - Portland       OK - Tulsa       TX - Waco      
CT - Cheshire       MI - Ann Arbor       ON - Ottawa       UT - Ogden      
CT - New Haven       MI - Flint       ON - Toronto       UT - Salt Lake City      
CT - Stamford       MI - Grand Rapids       OR - Beaverton       VA - Charlottesville      
DE - Wilmington       MI - Lansing       OR - Bend       VA - Glen Allen      
FL - Daytona Beach       MI - Livonia       OR - Eugene       VA - Harrisonburg      
FL - Fort Lauderdale       MN - Minnetonka       OR - Medford       VA - Roanoke      
FL - Fort Myers       MO - Columbia       OR - Salem       VA - Virginia Beach      
FL - Gainesville       MO - Kansas City       PA - Allentown       VT - Burlington      
FL - Jacksonville       MO - St. Louis       PA - Erie       WA - Seattle      
FL - Lakeland       MS - Biloxi       PA - Harrisburg       WA - Spokane      
FL - Miami       MS - Jackson       PA - Malvern       WI - Eau Claire      
FL - Naples       MT - Billings       PA - Philadelphia       WI - Green Bay      
FL - Pensacola       MT - Montana       PA - Pittsburgh       WI - Madison      
FL - Sarasota       NB - Moncton       PA - Reading       WI - Milwaukee      
FL - Tallahassee