Course information

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Outline

Module 1: Application Containers and Applications

  • What is Application Root and Application PDBs?
  • Application Container
    • Create
    • Manage
    • Install Application
    • Patch Application
    • Upgrade Application
  • Impacts in
    • Data Guard
    • Oracle Goldengate
    • Oracle Streams
    • Xstream
    • ADO
    • Heat Maps

Module 2: Security in PDBs

  • Create Users in Application Containers
    • Commonly
    • Locally
  • Grant Privileges in Application Containers
    • Commonly
    • Locally
  • Grant Roles in Application Container
    • Commonly
    • Locally
  • Differentiate
    • Common and Local Roles in Application Containers
    • Common and Local Objects in Application Containers
    • Common and Local Profiles in Application Containers
  • How to Manage PDB Lockdown Profiles?
  • How to Create Unified Auditing Policies Operations in Application Containers?

Module 3: PDBs Creation Using New Methods

  • How to Create a PDB from CDB Seed Enhancements?
  • Unplug into a PDB Archive File
  • Plug Using the Archive File
  • How to Create Local UNDO Tablespace at PDB Level?
  • What is Hot Cloning?
  • Near-Zero Downtime PDB Relocation and Create a Remote Proxy PDB

Module 4: PDBs Recovery and Flashback

  • Shut Down a PDB When PDB Datafile is Missing
  • Flashback at PDB Level and Flashback a PDB To a Clean PDB Restore Point

Module 5: Performance in PDBs

  • View
    • CDB / PDB ADDM Analysis
  • Manage
    • SGA and PGA at the PDB Level
  • Share
    • Resources Between PDBs

Module 6: Upgrade and Other Operations in PDBs

  • Upgrade
    • 12.1.0.2 CDB to 12.2
    • 12.1.0.2 PDB to 12.2 By Using Unplug, Plug, and Upgrade
  • Use Cross-Platform Non-CDB or PDB Backup sets to Import Into a CDB

Module 7: Privileges and User Profiles

  • What is New 12.2 SYSRAC Administrative Privilege?
  • Enhancements of Password File
  • External Users Grant Administrative Privileges
  • How to Migrate the Password File from Pre-12 or 12.1 to 12.2?
  • New System Privilege
    • Inherit any Remote Privileges
    • Object Privilege Inherit Remote Privileges
  • Security of Administrative Users Enhancement
  • How to Pre-Configure a Maximum Number of Days in the User Profile for Which a User Can Remain Inactive?

Module 8: Unified Auditing

  • Audit Policies for All Users to Whom the Role is Granted Directly
    • Create Audit Policies
    • Enable Audit Policies
  • How to Capture VPD (Virtual Private Database) Generated Predicates?

Module 9: Data Redaction

  • EM GUI New Redaction Format Library
  • Redaction Policy Expression and New Redaction Functions

Module 10: Data Encryption

  • Encrypt, Decrypt, and Rekey Tablespaces Online
  • Specific Tablespaces
    • SYSAUX
    • SYSTEM
    • UNDO
    • Temporary
  • How to Complete the Operations with Alter Tablespace Encryption Finish Encrypt, Rekey, and Decrypt?

Module 11: Transparent Sensitive Data Protection

  • Use TSDP with
    • Unified Auditing
    • Fine-Grained Auditing (FGA)
    • Transparent Data Encryption (TDE)

Module 12: Availability Enhancements

  • Non-Auto-Login Support for Duplicate
    • Use Encrypted Backups Whose Decryption Keys are in a Non-Auto-Login Wallet
  • Update and Drop the Catalog Without using DROP CATALOG and UPGRADE CATALOG Commands
  • Automate the Two Step Manual Process into One Recovery Operation After Missing Logs Found During RECOVER DATABASE
    • Recrepair FAILURE Command
  • Transport Data Across Platforms and Steps to Recover a Table
  • What is Online Redefinition Supports?

Module 13: Oracle Data Pump, SQL Loader, and External Tables

  • Enhancements of
    • Oracle Data Pump
    • SQL Loader
    • External Table

Module 14: In-Memory Column Store

  • Dynamic Parameter in 12.2
    • INMEMORY_SIZE
  • Caches Results of Virtual Columns and Frequently Evaluated Expressions For Subsequent Reuse
  • How to Optimising Joined Columns by Creating Join Groups?
  • Interact with Other Products and Features

Module 15: SQL Tuning

  • Enhancement of SQL Performance Analyser
  • Enhancement of SQL Plan Management
  • Statistics Gathering Performance Improvements
    • Optimiser Statistics Advisor
  • How to do SQL Performance Analyser (SPA) Enhancements to Make it Resilient to Certain Workloads Which Can Cause Divergence?
  • What are the New Ways of SQL Processing?
  • What are the Continuous Adaptive Query Plans?

Module 16: Resource Manager and Other Performance Enhancements

  • Manage Session PGA Limit and Reduce Cursor Invalidations for DDLs
  • Advanced Index Compression (HIGH)
  • What are Real-Time Materialised Views with On Query Computation?
  • Describe how to Use ON STATEMENT Refresh When a DML Operation Takes Place on Materialised Views Without the Need to Commit the Transaction?
  • What is HCC Data Compression with ADO Row-Level Policy

Module 17: Partitioning

  • Auto-List Partitioning and Composite Partitioning
  • Multicolumn List Partitioning and Read-Only Partition
  • Creation of Defer Subpartition Segment
  • How to Filter Data During Partition Maintenance Operations?

Module 18: Manageability

  • How to Start and Stop a DBOP by Specifying the Session ID and Serial#?

Module 19: Diagnosability

  • Ho to Set a Retention Target to ADR for an Automatic Delete of ADR Files?
  • How to Use the Retention Advisor?
  • Installation of TFA Collector by Default for RDBMS (With RDBMS Root Scripts)
  • Start TFA Collector
  • Allow Data Pump Tracing Changes Without Stopping and then Restarting the Job
  • MV Refresh Statistics

Module 20: Oracle Database Cloud Services

  • What is Oracle Database Cloud Services Console?
  • How to Create a Database Deployment Under 12.2?
  • Procedure of Database Deployment Backup and Recovery Automatic
  • Database Deployments Vs On-Premises Databases
  • How to Migrate On-Premises Database to Oracle Database Public Cloud Services?

Module 21: SQL Enhancements

  • What is New SQLcl Utility?
  • Usage of New 128 Bytes Length for Database Objects
  • How to Recall SQL*Plus Commands in the Same Session from Memory?
  • How to Use the New VALIDATE_CONVERSION Function

Show moredowndown

Who should attend this Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course?

The Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course is intended for individuals who have experience and familiarity with Oracle Database 12c Release 1 (12c R1) and wish to upgrade their knowledge to Oracle Database 12c Release 2 (12c R2). This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Administrators
  • Database Professionals
  • IT Personnel
  • System Administrators
  • Technical Managers
  • Database Developers
  • Data Architects

Prerequisites of the Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course

There are no formal prerequisites for attending the Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course. However, a prior understanding of Oracle Database 12c would be helpful for delegates.

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Overview

Oracle Database 12c R2: New Features for 12c R1 Administrators is a 1-day training course that introduces Oracle Database 12c Release 2 (12cR2) features to Oracle Database Administrators already familiar with Oracle Database 12c Release 1 (12cR1). This training covers many new features, including pluggable databases, application containers, unified auditing, and In-Memory Column-Store enhancements.

Proficiency in Oracle Database 12c R2 is essential for Oracle Database Administrators who want to manage and maintain Oracle Database 12c R2 databases. This training is ideal for Oracle Database Administrators who are already familiar with Oracle Database 12c R1 and want to learn about the new features in Oracle Database 12c R2.

In this intensive 2-day Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 training, delegates will thoroughly understand how to create unified auditing policies for operations in application containers and easily create users in application containers. During this training, delegates will learn how to create a local UNDO tablespace at the PDB level. Our highly experienced trainers will deliver this training course, who will put in their best efforts to make delegates understand things easily.

Course Objectives

  • To understand the new features and enhancements of Oracle Database 12c R2
  • To learn how to use the new features to improve the performance, scalability, and security of Oracle databases
  • To gain hands-on experience with the latest features through a series of practical exercises
  • To be able to apply the new features to their own Oracle databases
  • To prepare for the Oracle Database 12c R2 Certified Associate certification exam
  • To manage the procedure of database deployment, backup, and recovery automatic
  • To get in touch with how to manage the PDB lockdown profiles

After completing this Oracle Certification Training, delegates will be updated about every aspect of the Oracle Database 12c R2 and receive a certificate, which demonstrates to employers that delegates have the skills and knowledge to manage Oracle Database 12cR2 effectively.

Show moredowndown

What’s included in this Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Certificate
  • Digital Delegate Pack

Why choose us

Our High Wycombe venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

High Wycombe is a town located in the county of Buckinghamshire, England. It is the second largest in the county with a population of around 133,000 people. High Wycombe is most famous for its furniture production. The educational system is High Wycombe is slightly older than the majority of the rest of England and is based on the tripartite system. This means students must take an exam in the last year of primary school, and this score determines whether they attend a grammar school or a modern secondary school. These secondary schools include Cressex Community School, Royal Grammar School and Sir William Ramsay School. There are also independent schools in Godstowe Preparatory School and Wycombe Abbey. For further education, the main campus of Buckinghamshire New University is located in the town. This university has a few unique degrees such as Policing, Commercial Pilot Training and Music Management. It enrols around 9000 students a year. The rate of unemployment in High Wycombe is at 2%. This is lower than the national average of England which is 7.6%. 

Nearby Locations:

  • Bookers
  • Penn
  • Stokenchurch
  • Hughenden
  • Wooburn Green
  • Hazlemere
  • Flackwell Heath
  • West Wycombe
  • Loudwater
  • Holmer Green
  • Lanes End
  • Saunderton
  • Piddingtons
  • Radnage
  • Four Ashes
  • Bledlow Ridge
  • Naphill
  • Bradenham
  • Downley
  • Cressex Business Park

Show moredown

Address

High Wycombe

T: 01344203999

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Oracle Training | Oracle Database 12c R2 Training in High Wycombe. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Unlock your potential with The Knowledge Academy's Oracle Training | Oracle Database 12c R2 Training in High Wycombe, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Experience the most sought-after learning style with The Knowledge Academy's Oracle Training | Oracle Database 12c R2 Training in High Wycombe. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Oracle Training | Oracle Database 12c R2 Training in High Wycombe sessions.

best_trainers

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

value_for_money

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Streamline large-scale training requirements with The Knowledge Academy's In-house/Onsite at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

tailored_learning_experience

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

Our offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

monitor_progress

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

What our customers are saying

Oracle Training | Oracle Database 12c R2 Training in High Wycombe FAQs

Oracle Database 12c R2 is a multi-tenant database management system designed for cloud computing. It provides enhanced performance, security, and management capabilities.
Oracle 12c R2 is used to manage large-scale databases, support cloud environments, optimise performance, and ensure high availability and data security.
Benefits of this Oracle Database 12c R2 Training include validating your expertise, enhancing job prospects, increasing earning potential, and demonstrating proficiency in managing and optimising Oracle databases.
Database Administrators, IT Professionals, System Architects, and anyone seeking to manage and optimise Oracle databases should attend this Oracle Database 12c R2 Training.
This Oracle Database 12c R2 Training comes with a 2-day training session from experienced trainers, a digital delegate pack, and a certificate upon completion of the course.
There are no formal prerequisites for attending the Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course. However, a prior understanding of Oracle Database 12c would be helpful for delegates.
The Knowledge Academy provides flexible self-paced training for this Oracle Database 12c R2 Training. Self-paced training is beneficial for individuals who have an independent learning style and wish to study at their own pace and convenience.
The training is intermediate to advanced, requiring prior knowledge of database concepts and basic Oracle experience.
Yes, corporate training options are available to meet the needs of organisations seeking to upskill their teams.
Jobs include Database Administrator, Oracle Developer, IT Consultant, System Architect, and Data Analyst.
Yes. The Knowledge Academy offers 24/7 support for delegates before, during, and after this course.
The duration of this course spans across 2 days.
The training fees for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 certification in High Wycombe starts from £2495
The Knowledge Academy is the Leading global training provider for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1.
Please see our Oracle Training courses available in High Wycombe
Show more down

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Oracle Training?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.

cross

OUR BIGGEST SUMMER SALE!

Special Discounts

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.