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.

Course information

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

The following subjects will be taught during this course:

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Changes to Database Management Tools

  • Enterprise Manager Cloud Control Home Page and Express home page
  • SQL Developer new functionality
  • Changes to the OUI and the DBCA

Oracle Database 12c Architecture

  • Overview of the Oracle database architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The root container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views

Create a Database with the Database Configuration Assistant

  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA

Preparation for Upgrade To Oracle Database 12c

  • Methods used to perform upgrade and migrate data
  • Direct upgrade supported releases
  • Upgrade process overview
  • Rolling upgrade
  • Upgrade a CDB
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information Tool
  • Backup and Install the Oracle Database 12c software
  • Create the new Oracle home

Perform an Upgrade to Oracle Database 12c

  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Migrate a non-CDB to a CDB

Migrate Data with Data Pump

  • Migrate data with Data Pump
  • Import data using a Data Pump network link

Configure and Create a Container Database and Pluggable Databases

  • Create and configure a CDB using Enterprise Manager
  • Examine the structure of a CDB using Enterprise Manager and the CDB_xxx Views
  • Administer the database using Enterprise Manager and SQL*Plus
  • Create a new PDB from PDB$SEED
  • Create a PDB from a Non-CDB
  • Clone a PDB into the same CDB using DB links
  • Plug in an Unplugged PDB

Manage a Container Database and Pluggable Databases

  • Connect to a CDB as an Administrator
  • Connect to a PDB using a service name
  • Startup and shutdown a CDB
  • Open and close a PDB Using SQL*Plus and EM
  • Open and close all PDBs
  • Change the state of a PDB

New Tablespaces and Management Features

  • Create permanent tablespaces in the root and PDBs
  • Online rename and relocation of an active datafile
  • Restrict PGA size
  • Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes
  • Temporary UNDO
  • DDL Logging

Manage Common and Local Users, Roles And Privileges

  • Manage common and local schemas and users in the Root and PDBs
  • Manage system and object privileges to common and local grantees
  • Manage common and local roles

Manage Backup, Recovery and Flashback of a CDB and PDB

  • Backup a CDB and a PDB
  • Recover a CDB from the loss of redo log files, control files and undo datafile loss
  • Use Flashback at CDB Level

Online Datafile Move and Automatic Data Optimization

  • Data classification in 12c
  • Configure a heat map
  • Automatic movement and compression
  • Compression levels and types

In Database Archiving

  • New In-database archiving solutions
  • Use the ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set the ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause
  • SQL temporal data type

Enhancements to Database Auditing

  • Overview of database auditing in R12
  • Security compliance
  • Standard auditing
  • Unified audit trail overview
  • Create a tablespace for the Unified Audit Trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Unified Audit Trail
  • Specify audit options
  • Configure the Unified Audit Trail to set a tolerance level for lost of audit records
  • Create audit policies

Enhancements to Privileges

  • Implement the separation of duties for Database Administration tasks
  • Grant the CAPTURE_ADMIN role to enable management of privilege captures
  • Create, start and stop privilege captures
  • Query the DBA_PRIV_CAPTURES view
  • Use the mandatory INHERIT PRIVILEGES privilege to execute the invoker's rights procedure

Data Redaction

  • Types of data masking policies
  • Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Manage masking policies
  • Understanding the masking of statements containing subqueries
  • Query the data dictionary to obtain information on masking policies

New RMAN Features

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • Table or partition recovery
  • Restore and recover datafiles across the network
  • Run the duplicate operation with the NOOPEN option
  • Backup and restore very large files
  • Cross-platform backup and restore

Monitoring Database Operations

  • Overview of DB monitoring operations
  • Bracketing an operation
  • Monitoring the progress of operations
  • DB Operation tuning and active report

Schema and Data Changes

  • Create identity columns
  • Create a table with invisible columns
  • Truncate table cascade
  • Session level sequences
  • Create multiple indexes on the same set of columns
  • Advanced Row Compression
  • The Schema Change Plan flow
  • Schema synchronization
  • The Data Comparison flow
  • The DBMS COMPARISON package

SQL and PL/SQL Enhancements

  • SQL*Plus Enhancements
  • Row limiting for Top-N result Queries
  • The Schema Change Plan flow
  • PL/SQL Enhancements
  • Implicit results on SQL*Plus
  • WITH clause enhancements

Performance Tuning New Features

  • Partitioning Enhancements
  • Data Pump Single-Partition Imports
  • Materialized Views and Query Rewrite Enhancements
  • The PIVOT and UNPIVOT Clauses
  • Data Compression
  • Enhancements to the Degree of Parallelism
  • System Managed Indexes for List Partitioning
  • Overview of new ADDM Analysis features
  • Real-time ADDM analysis
  • Defining Workload dimensions
  • Reported items and Root Causes
  • Report requirements

Resource Manager and Other Performance Enhancements

  • Manage resources within a PDBs and CBPs
  • Manage runaway queries
  • Automated maintenance tasks

ADR and Network Support

  • ADR file types
  • New File types and locations
  • New commands for ADRCI
  • Improve performance by Compression

Data Pump and SQL*Loader Enhancements

  • Data Pump enhancements
  • Turn off redo log generation
  • Transport view as table
  • Use FULL Transportable export and import
  • SQL*Loader enhancements

Partitioning Enhancements

  • Move a partition online
  • The split partition operation enhancement
  • The merge partition operation
  • The Add and drop partition operations

Show moredowndown

Prerequisites

There are no prerequisites, but we recommend having a good knowledge of Oracle Database 12c.

Who should attend this Oracle Training Course?

This Oracle 12C New Features for Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new features and functionality introduced in Oracle Database 12c, including database administrators and system administrators.

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

This Oracle 12C New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new features available in Oracle Database 12c.

Delegates will gain an appreciation of how these features can be used to increase security, manageability and performance.

After successfully completing this course, delegates will be able to gain skills in creating an Oracle Database 12c, upgrading a database to Oracle Database 12c, managing Container and Pluggable databases and many other vital techniques.

Show moredowndown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.

best_trainers

Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning 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

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience

value_for_money

Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.

tailored_learning_experience

Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.

budget

Maximise your training budget

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

team_building

Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.

monitor_progress

Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Frequently asked questions

FAQ's

Please arrive at the venue for 08:45am
We recommend knowledge of Oracle Database 11g.
There is no exam.
The Knowledge Academy provides you with materials, an experienced instructor and refreshments.
All of our instructors have over ten years of experience.
No, there are no hidden costs.
The price for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 certification in Canada starts from CAD3295
The Knowledge Academy is the Leading global training provider in the world for Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1.
Please see our Oracle Training courses available in Canada

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
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

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 + 1-613 800 4703 and speak to our training experts, we should be able to help you with your requirements.