Oracle Training | Oracle Database 12c R2 Training in Calgary

Home

Courses

Oracle Training

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

Calgary

Oracle Database 12c R2: New Features For 12c R1 Administrators Ed 1 in Calgary introduces learners to the latest Oracle database enhancements. Discover key performance features, security upgrades, and more to optimise databases to improve scalability and support enterprise requirements.

Understand database administration and management
Master data recovery techniques and backup procedures
Gain career advancement with this Oracle Database 12c R2 Training

Dates & Prices

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

Course syllabus

Who it’s for

What’s included

FAQs

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

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.

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

Hands-On Labs: Included as part of our online instructor-led delivery, these labs provide real-world exercises in a simulated environment guided by expert instructors to enhance your practical skills.

Train Your Workforce

Looking for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in-house or onsite training in Calgary? We specialise in corporate group training and bulk bookings for organisations of all sizes in Calgary. Our trainers deliver tailored sessions at your premises, online, or hybrid, with best price guarantee, group discounts and flexible scheduling to train your team.

Our Calgary 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.

Calgary is located in the south of Alberta, Canada and has a population of around 1 million people, making it the largest city in Alberta and the third largest in Canada. It also became the first Canadian city to host the Olympic Winter Games. There is a strong economy in Calgary, as it boasts the second most corporate head offices in Canada and has activity based in the health, retail, tourism, transportation, film, technology and energy sectors. There are a large amount of educational facilities in Calgary, including a large number of public and private schools ran by different school boards including English and French language boards. There is also a high school dedicated to training athletes ready for the Olympics. Each high school in Calgary is large, consisting of around 2000 students each. Private schools include Rundle Academy, Calgary French and International School, Chinook Winds Adventist Academy and Delta West Academy. The biggest university in Calgary is the ‘University of Calgary’ which enrols around 30,000 students. It offers a wide variety of degrees, diplomas and certificates. Also in Calgary are Mount Royal University, SAI Polytechnic and Athabasca University, which provides distance education programs for students. There are a number of private universities as well, including Reeves College and Columbia College.

Ways to take Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary

Online Instructor-Led Learning

Online Self-Paced Learning

Onsite Learning

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1. 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.

Live classes

Join a scheduled class with a live instructor and other delegates.

Interactive

Engage in activities, and communicate with your trainer and peers.

Global Pool of the Best Trainers

We handpick from a global pool of expert trainers for our Online Instructor-led courses.

Expertise

With 10+ years of quality, instructor-led training, we equip professionals with lasting skills for success.

Scalable Training Delivery

Access Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary delivered by one of the largest training providers, with scalable instructor-led classes, accessible worldwide.

Master Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 with a flexible yet structured approach that combines live, expert-led sessions and self-paced study. With Weekly one-to-one tutor support and consistently high pass rates, you’ll receive tailored guidance and achieve real results.

Structured Yet Flexible Learning

Take part in scheduled, instructor-led sessions with real-time feedback, while enjoying the freedom to study independently. Interactive resources and progress tracking tools help you stay motivated and on target.

Engaging & Interactive Training

Join dynamic live sessions featuring discussions, practical activities, and peer collaboration. Learn from Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 industry experts and reinforce your knowledge with self-paced modules—plus, connect with professionals in your field.

Expert-Led Course

Gain valuable insight from experienced trainers during live sessions, and revisit course materials anytime to deepen your understanding. This method offers the ideal balance between expert guidance and independent learning.

Global Training Accessibility

Access top-quality training across time zones—anytime, anywhere. Whether at home or on the go, our expert-led sessions and flexible study materials support your goals, and help you on the journey towards the certification.

Learn Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 through The Knowledge Academy’s Online Self-Paced Learning. This flexible and structured format supports your training goals and enables every professional to build skills with confidence.

Flexible Learning

Access Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 resources 24/7 to maintain steady progress, complete regular assessments or tasks, and upskill effectively alongside work commitments.

Expert-Developed Content

Our Online Course content is designed by experienced trainers to ensure accuracy, relevance, and practical value.

Global Training Provider

Access Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary from a trusted global training provider delivering consistent learning to professionals worldwide.

Cost-Effective Training

Benefit from the cost-effective Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 that delivers high-quality course content without compromising learning outcomes.

Interactive LMS

Track performance, download resources, and receive AI-enabled support through The Knowledge Academy’s dedicated Learning Management System.

Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Schedule in Calgary

Online Instructor-Led

Online Self-Paced

Classroom

Onsite

Package deals for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary

Our training experts have compiled a range of course packages on a variety of categories in Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1, to boost your career. The packages consist of the best possible qualifications with Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1, and allows you to purchase multiple courses at a discounted rate.

Oracle Training | Oracle Database 12c R2 Training in Calgary FAQs

What is an Oracle Database 12c R2?

Oracle Database 12c R2 is a multi-tenant database management system designed for cloud computing. It provides enhanced performance, security, and management capabilities.

What is Oracle 12C R2 used for?

Oracle 12c R2 is used to manage large-scale databases, support cloud environments, optimise performance, and ensure high availability and data security.

What are the benefits of Oracle Database 12c R2 Certification?

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.

Who should attend these Oracle Database 12c R2 Courses?

Database Administrators, IT Professionals, System Architects, and anyone seeking to manage and optimise Oracle databases should attend this Oracle Database 12c R2 Training.

What is included in this Oracle Database 12c R2 Course?

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.

Are there any prerequisites needed for the Oracle Database 12c R2 Training?

Do you provide a self-paced Oracle Database 12C R2 RAC Administration Online Course?

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.

What is the level of difficulty for this Oracle Database 12c R2 Training?

The training is intermediate to advanced, requiring prior knowledge of database concepts and basic Oracle experience.

Do you provide corporate training for this Oracle Database: Oracle 12C R2?

Yes, corporate training options are available to meet the needs of organisations seeking to upskill their teams.

What kind of jobs can I expect based on Oracle Database 12c R2 Certification?

Jobs include Database Administrator, Oracle Developer, IT Consultant, System Architect, and Data Analyst.

Do you offer 24/7 support for the Oracle 12C R2 Training Course?

Yes. The Knowledge Academy offers 24/7 support for delegates before, during, and after this course.

What is the duration of the Oracle Database 12c R2 Course?

The duration of this course spans across 2 days.

What is the cost/training fees for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary?

The training fees for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary starts from CAD5595

Which is the best training institute/provider of Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 in Calgary?

The Knowledge Academy is one of the Leading global training provider for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1.

What are the best Oracle Training courses in Calgary?

Please see our Oracle Training courses available in Calgary

Customers Reviews

Request For Pricing

WHO WILL FUNDING THE COURSE?

My employer

I will

Not sure

+44

Courses Related to Oracle Training

CCNA Certification CompTIA A+ Course SAP HANA Implementation & Modeling CCNP Wireless Training Oracle Database 11g Release 2 DBA - Part I

Why choose The Knowledge Academy

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.

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

Our Clients

"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