Course information

Oracle Database 12cR2, 18c and 19c New Features for Administrators​ Course Outline

Module 1: Oracle Database Multitenant Architecture Overview

  • Oracle Database 12cR2 Architecture Overview
  • An Overview of a Container Database (CDB)
  • Benefits of Multitenant Architecture
  • Root Container
  • Pluggable Database Containers
  • Structure of the Root Container
  • Structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views

Module 2: Install the Oracle 12c or 18c Database Software

  • Oracle 12 c Installation
  • System Requirements and OS Prerequisites
  • Set Environment Variables
  • Set Permissions to Run Root Configuration Scripts Automatically
  • 19c Automated Installation, Configuration
  • Install the Oracle Database Software with the Oracle Universal Installer
  • Silent Mode Installation
  • 19c Image Based Client Installation
  • Database Software Deinstallation

Module 3: Create a Database with the Database Configuration Assistant (DBCA)

  • Select a CDB or Non-CDB Database
  • Create a Database with the DBCA
  • Read Only Oracle Homes in Oracle Database 18c/19c

Module 4: Preparation for Upgrade to Oracle Database 18c/19c

  • Methods Used to Perform an Upgrade
  • Direct Upgrade Supported Releases
  • Upgrade Process Overview
  • Rolling Upgrade
  • Methods of Data Migration
  • 19c Simplified Upgrade with Auto Upgrade
  • Backup the Database
  • Create an Upgrade Test Plan
  • Carry out Performance Testing
  • Run the Pre-Upgrade Information Tool

Module 5: Perform Upgrades to Oracle Database 18c/19c

  • Upgrading to Oracle Database 18c/19c
  • Manual Upgrade of an Oracle 12cR1 Database
  • Execute Preupgrade.jar
  • Upgrade a Database with the Database Upgrade Assistant (DBUA)
  • Post Upgrade Checks
  • Deprecated Database Features and Parameters
  • Common Installation Errors
  • Check the /etc/Oratab File
  • Check the Database Version
  • Enterprise Manager Express Configuration
  • Post Upgrade Tasks After a Manual Upgrade
  • Migrate to Unified Auditing

Module 6: Migrate Data with Data Pump

  • Introduction to Migrate Data with Data Pump
  • Transport a Database
  • Import Data Using a Data Pump Network Link

Module 7: Enhancements to Database Auditing

  • Use Mixed Mode Auditing or Migrate to Pure Unified Auditing
  • Audit Top Level User Activities in 19c
  • Use Oracle Data Pump to Export and Import the Unified Audit Trail

Module 8: Enhancements to Privileges and Profiles

  • Automatically Lock Inactive Accounts
  • Schema Only Accounts from 18c
  • 19c Privilege Analysis with an Enterprise Edition License
  • Create, Start, and Stop Privilege Captures
  • Query the DBA_PRIV_CAPTURES View
  • Execute the Invokers Rights Privilege with the Inherit Privilege
  • Control Definer's Rights Privileges for Database Links

Module 9: New RMAN Features

  • 12.2 RMAN Syntax Enhancements
  • Enhanced Table Point in Time Recovery from 12.2
  • Enhanced REPAIR FAILURE Command
  • Table or Partition Recovery Enhancements from 12.2
  • Recover a Database after Missing Redo Logs Found
  • Simplified Duplicate a Database using TDE

Module 10: Miscellaneous New Features

  • Cancel a SQL Statement in a Session from 18c
  • Use Private Temporary Tables from 18c
  • Miscellaneous Data Redaction Enhancements
  • 12.2 INMEMORY_SIZE Parameter
  • 12.2 INMEMORY Enhancements

Module 11: SQL and PL/SQL Enhancements

  • SQL*Plus Enhancements
  • login.sql File
  • SQL*Plus Command Line History
  • SQL*Plus Performance Settings Options
  • SQLcl Command Line Interface
  • Longer Object Names
  • Globalisation Support at Table and Column Level
  • Markup CSV
  • New Approximate Functions
  • LISTAGG DISTINCT from Oracle 19c
  • Remove Duplicates from LISTAGG Results Using DISTINCT
  • DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP from 18c
  • Real Time Materialised View Enhancements
  • PL/SQL Enhancements
  • PL/SQL Scope Enhancements
  • Deprecate Pragma for PL/SQL
  • Code Coverage Using DBMS_PLSQL_CODE_COVERAGE
  • Package White Lists Enhancements

Module 12: Performance Tuning New Features

  • Overview of Performance Tuning New Features
  • Adaptive Query Optimisation Enhancements
  • Optimiser Statistics Advisor Rules, Findings, Recommendations, and Actions
  • Expression Statistics Store
  • Enhancements to the SQL Performance Analyser
  • Configure the Automate SPM Evolve Advisor Task to Run Hourly
  • Automatic Resolution of SQL Plan Regression
  • Scalable Sequences

Module 13: Big Data and Data Warehouse New Features

  • Reduce Cursor Invalidations for DDLs
  • Automatic Indexing in 19c with DBMS_AUTO_INDEX
  • Real Time Statistics Gathering During DML Operations
  • Advanced Index Compression
  • Automatic SQL Plan Management
  • SQL Statements Terminated by the Resource Manager Quarantined
  • COUNT(DISTINCT) Rollup
  • Polymorphic Tables Enhancements

Module 14: Partitioning Enhancements

  • New Oracle Partitioning Strategies in 12.2
  • Automatic List Partitioning
  • Multiple Column List Partitioning
  • Multiple Column with Automatic List Partitioning
  • Interval Sub-Partitioning
  • Filter Data During Partition Maintenance Operations
  • Convert a Non-Partitioned Table to a Partitioned Table
  • Read Only Partitions
  • Defer Segment Creation for Sub-Partitioning
  • Online MERGE PARTITION and MERGE SUBPARTITION in 18c
  • Hybrid Partitioned Tables - Integrate Internal and External Partitions

Module 15: Data Pump Enhancements

  • Data Pump Parallel Import and Export of Metadata
  • Usage of Wildcards in TRANSPORT_DATAFILES
  • New Substitution Variables for Filenames
  • Parameter File Contents Written to the Log File
  • REMAP_DIRECTORY Parameter
  • DATA_OPTIONS Parameter Changes
  • Miscellaneous New Data Pump Features

Module 16: SQL*Loader and External Table Enhancements

  • In-Memory External Tables
  • External MODIFY Clause
  • Load XML Documents with the XML TAG Clause

Module 17: Database Diagnostic New Features

  • TFA Collector
  • Install the TFA Collector
  • Manage the TFA Daemon
  • Quarantined Objects

Module 18: Data Guard New Features

  • 12.2 Data Guard New Features
  • Create Scripts with the Broker DGMGRL Command Line Interface
  • Automatic Password File Management
  • Simple Repair of No Logging Operations
  • Active Data Guard Redirection
  • Automatically Replicate Restore Points from Primary to Standby
  • New Broker VALIDATE Commands
  • 19c Data Guard New Features
  • Export the Broker Configuration File
  • Observe Only Mode to Test Fast Start Failover
  • Dynamically Change Fast Start Failover Target Using the Data Guard Broker
  • Enhanced Control of Alternative Destinations
  • New Broker Commands
  • Use RMAN and Enterprise Manager to Create Far Sync Instances
  • Multi-Instance Redo Apply
  • Keep Buffer Cache at Role Change
  • 18c Data Guard New Features

Module 19: Active Data Guard New Features

  • 12.2 Active Data Guard New Features
  • Use all Standby Instances to Apply Redo
  • Data Guard Broker Support for DBMS_ROLLING Upgrades
  • Generating AWR Report from Active Dataguard
  • Control Login Attempts
  • New RECOVER STANDBY DATABASE FROM SERVICE
  • Execute DML
  • Create Global Temporary Tables

Module 20: Transparent Sensitive Data Protection

  • Use Cases for TSDP Policies
  • TSDP with Unified Auditing
  • TSDP with Fine-Grained Auditing
  • Create a TSDP Policy with TDE Column Encryption
  • TDE Column Encryption Encrypt Clause Settings Used with TSDP Policies
  • TSDP Data Dictionary Views

Module 21: Application Continuity Enhancements

  • Server Draining Prior to Stopping or Relocating Services
  • Oracle Database Recognition of Request Boundaries
  • Transparent Application Continuity
  • Application Continuity for Java

Show moredowndown

Who should attend this Oracle Database 12cR2, 18c and 19c New Features for Administrators Course?

The Oracle Database 12cR2, 18c, and 19c New Features for Administrators Course is designed for individuals who have a background or role in Oracle Database Administration and Management. This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Administrators (DBAs)
  • System Administrators
  • Database Developers
  • IT Managers and Decision Makers
  • Technical Consultants
  • Database Architects
  • Data Analysts

Prerequisites of the Oracle Database 12cR2, 18c and 19c New Features for Administrators Course

There are no formal prerequisites for attending the Oracle Database 12cR2, 18c and 19c New Features for Administrators Course.

Oracle Database 12cR2, 18c and 19c New Features for Administrators Course Overview

This Oracle Database Course focuses on the new features introduced in Oracle Database 12cR2, 18c, and 19c, empowering Database Administrators to manage and optimise their database environments effectively. It covers critical concepts such as multitenant architecture, container databases, enhanced auditing, privilege analysis, data redaction, performance tuning, and Big Data and Data Warehousing enhancements.

Proficiency in Oracle Database 12cR2, 18c, and 19c is essential for Database Administrators responsible for managing and maintaining Oracle database environments. This training is designed for experienced Oracle Database Administrators who want hands-on experience with the latest features and enhancements.

This intensive 3-day Oracle Certification Training explains data redaction and data encryption enhancements. Delegates will acquire knowledge of performance tuning, data pump, SQL*Loader, and external tables. They will also learn about SQL tuning enhancements using the optimiser statistics advisor and SQL join processing. This training also describes data guard, active data guard, and the broker. Furthermore, they will learn how to use the in-memory column to store new features for increasing SQL performance.

Course Objectives

  • To understand the concepts of multitenant architecture and container databases
  • To implement and manage Oracle Database 12cR2, 18c, and 19c features
  • To configure and utilise enhanced auditing and privilege analysis features
  • To protect sensitive data using data redaction and encryption enhancements
  • To leverage Big Data and Data Warehousing enhancements for advanced analytics
  • To troubleshoot and diagnose database issues using Oracle Database 12cR2, 18c, and 19c tools
  • To implement disaster recovery and high availability solutions using Oracle Data Guard

Upon completion of the Oracle Database 12cR2, 18c, and 19c New Features for Administrators Course, delegates will gain a comprehensive understanding of the latest features and enhancements in Oracle Database versions, enabling them to efficiently leverage these advancements in their database management tasks.

Show moredowndown

What’s included in this Oracle Database 12cR2, 18c and 19c New Features for Administrators Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 12cR2, 18c and 19c New Features for Administrators Certificate
  • Digital Delegate Pack

Why choose us

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

Toronto, a city in the Canadian province of Ontario, has an average population of roughly 2,615,000 spread across 243.33 square miles of land – making it the busiest and most populous region in the whole of Canada.  At The Knowledge Academy, we offer 50,000 classroom based training courses throughout the different areas of Toronto, in order to enhance people’s learning in an array of subject areas.  Education in Canada is generally funded by federal, provincial, and local governments; the system is divided into primary, secondary and post-secondary education and is operated under provincial jurisdiction.  On the whole, there are 190 days in a school year, starting in September and ending towards the last Friday of June.  Some popular and highly regarded universities in Canada include: the University of Toronto (notable alumni including: William Lyon Mackenzie King, Vincent Massey, Donald Sutherland and Lesra Martin), the University of British Columbia (notable alumni including: Eddie Peng, Justin Trudeau and Nardwuar the Human Serviette), and the University of Alberta (notable alumni including: Dayo Wong, George Stanley and Beverley McLachlin).  With its massively diverse citizenry and education options, it is hard to solely categorise the formation of its education system; it is also the home site to four publicly funded K12 school boards, a publicly funded religious K12 school board, a range of K12 private and prepatory school and a plethora of other religious, vocational, career and specialist schools.  As French is a commonly spoken language in Canada, there are also a number of public school boards designed for French language students.  Regarding religious schools, there are a number of Christian, Islamic and Jewish schools based in Toronto, all of which offering a slightly different educational system to their students and are tailored to best suit a specific religion.  With non-public schooling in mind, there are also a variety of religious non-public school boards spread throughout Toronto, namely the Board of Jewish Education of Toronto and the Toronto Adventist District School Board.  

Show moredown

Address

100 King St W,

Toronto,

ON M5X 1A9,

First Canadian Place, 

T: +1 6474932992

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Oracle Database 12cR2, 18c And 19c New Features For Administrators in Toronto. 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 Database 12cR2, 18c And 19c New Features For Administrators in Toronto, 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.

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 Database 12cR2, 18c And 19c New Features For Administrators in Toronto FAQs

Oracle Database 12cR2, 18c, and 19c are versions of Oracle's advanced, multi-tenant database management system, with 12cR2 introducing cloud-based features, 18c focusing on autonomous capabilities, and 19c offering long-term support and enhanced performance for enterprise applications.
Attending the Oracle Database 12cR2, 18c, and 19c Course is crucial for mastering the latest database technologies, enhancing your ability to manage and optimise Oracle databases effectively, and ensuring your skills remain current and competitive in the industry.
There are no formal prerequisites for attending the Oracle Database 12cR2, 18c and 19c New Features for Administrators Course.
This course is ideal for Database Administrators, IT Professionals, and Developers seeking to enhance their skills in managing, deploying, and optimising Oracle databases. It's also suitable for those preparing for Oracle Certification or looking to advance their careers in database management.
Yes, The Knowledge Academy offers 24/7 support via phone & email before attending, during, and after the course. Our customer support team is available to assist and promptly resolve any issues you may encounter.
In this training course, delegates will have intensive training with our experienced instructors, a digital delegate pack consisting of important notes related to this course, and a certificate after course completion.
This course takes 3 days to complete during which delegates participate in intensive learning sessions that cover various course topics.
You should receive the confirmation details for the course within 24-48 hours after registration. If you haven't received it by then, please check your spam folder or contact our support team for assistance.
In this Oracle Database 12cR2, 18c, and 19c Certification Course, you'll learn to manage, secure, and optimise Oracle databases, explore multi-tenant architecture, perform backup and recovery, implement database security, and utilise advanced features for performance tuning and efficient data management.
Yes, after completing this course you will receive a certificate of completion to validate your achievement and demonstrate your proficiency in the course material.
Attending this Oracle Database 12cR2, 18c, and 19c training provides delegates with in-depth knowledge of Oracle's advanced database features, improves their skills in database management and optimisation, enhances their career prospects, and equips them to implement and maintain Oracle databases effectively.
The Knowledge Academy provides flexible self-paced training for this course. Self-paced training is beneficial for individuals who have an independent learning style and wish to study at their own pace and convenience.
Yes, we provide corporate training for this course, tailored to fit your organisation’s requirements.
If you face any issues in accessing the course materials, then you can reach out to our customer support team who will provide you with quick assistance to resolve the issue.
After completing this training, you can pursue roles such as Oracle Database Administrator, Database Developer, Data Analyst, and IT Consultant. These positions typically involve managing, developing, and optimising Oracle databases in various business environments.
The Oracle Database 12cR2, 18c, and 19c Certification Training is designed to be accessible to individuals with basic knowledge of databases, but it also offers in-depth content that can challenge experienced professionals, making it moderately difficult overall.
Yes, the course will cover migration strategies between various Oracle versions, including best practices, tools, and techniques to ensure a smooth transition. Delegates will learn how to plan, execute, and troubleshoot migrations effectively.
The Knowledge Academy in Toronto stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition. It's a dependable option for those seeking this course.
The training fees for Oracle Database 12cR2, 18c and 19c New Features for Administratorsin Toronto starts from CAD5095
The Knowledge Academy is the Leading global training provider for Oracle Database 12cR2, 18c and 19c New Features for Administrators.
Please see our Oracle Training courses available in Toronto
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 +1 6474932992 and speak to our training experts, we should be able to help you with your requirements.

cross

BIGGEST
Christmas SALE!

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.