Oracle Database 12cR2, 18c And 19c New Features For Administrators in Canberra

Home

Courses

Oracle Training

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

Canberra

Oracle Database 12cR2, 18c, and 19c New Features for Administrators Training in Canberra introduces the latest updates in Oracle database management. Learners explore performance optimisation, streamlined administration, and strengthen skills in configuration, security, and data handling.

Learn how to install Oracle Database 18c/19c software with the OUI.
Create a non-container Oracle Database 18c or 19c database.
Learn about performance tuning, data pump, SQL*Loader and external tables.

Dates & Prices

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

Course syllabus

Who it’s for

What’s included

FAQs

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

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.

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

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 12cR2, 18c and 19c New Features for Administrators in-house or onsite training in Canberra? We specialise in corporate group training and bulk bookings for organisations of all sizes in Canberra. 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 Canberra 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.

Canberra is the capital city of Australia and largest inland city. The population of Canberra is around 380,000 and is located 170 miles south-west of Sydney in the Northern end of the Australian Capital Territory. Canberra was elected as the nation’s capital in 1908 against the two rivals Melbourne and Sydney. There are two main universities in Canberra the Australian National University which has over 10,000 full-time students and the University of Canberra with over 8,000 students attending. St. Mark’s Theological College is a part of the Charles Sturt University. As of 2004 there were a total of 140 schools in Canberra with 96 of them being government run and 44 being private. During the 2006-2008 period some schools were closed and others were merged together. There is a high percentage of non-government run schools in Canberra that make up almost 41% of ACT enrolments. There are a number of military schools in Canberra including the Australian Defence Force Academy and the Royal Military College.

Ways to take Oracle Database 12cR2, 18c and 19c New Features for Administrators in Canberra

Online Instructor-Led Learning

Online Self-Paced Learning

Classroom Based Learning

Onsite Learning

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Oracle Database 12cR2, 18c and 19c New Features for Administrators. 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 12cR2, 18c and 19c New Features for Administrators in Canberra delivered by one of the largest training providers, with scalable instructor-led classes, accessible worldwide.

Master Oracle Database 12cR2, 18c and 19c New Features for Administrators 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 12cR2, 18c and 19c New Features for Administrators 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 12cR2, 18c and 19c New Features for Administrators 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 12cR2, 18c and 19c New Features for Administrators 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 12cR2, 18c and 19c New Features for Administrators in Canberra from a trusted global training provider delivering consistent learning to professionals worldwide.

Cost-Effective Training

Benefit from the cost-effective Oracle Database 12cR2, 18c and 19c New Features for Administrators 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.

Experience the most sought-after learning style with The Knowledge Academy's Oracle Database 12cR2, 18c and 19c New Features for Administrators Course. 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 Database 12cR2, 18c and 19c New Features for Administrators sessions.

Highly experienced trainers

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

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 class sizes

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

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 Oracle Database 12cR2, 18c and 19c New Features for Administrators Course at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

Tailored learning experience

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

Maximise your training budget

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

Team building opportunity

Our Oracle Database 12cR2, 18c and 19c New Features for Administrators offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

Monitor employees progress

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

Oracle Database 12cR2, 18c and 19c New Features for Administrators Schedule in Canberra

Online Instructor-Led

Online Self-Paced

Classroom

Onsite

Package deals for Oracle Database 12cR2, 18c and 19c New Features for Administrators in Canberra

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

Oracle Database 12cR2, 18c And 19c New Features For Administrators in Canberra FAQs

What is Oracle Database 12cR2, 18c and 19c?

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.

What is the importance of attending this Oracle Database 12cR2, 18c and 19c Course?

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.

Are there any prerequisites for taking this training course?

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

Who should attend this 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.

Do you provide 24/7 support for this online course?

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.

What is included in the course?

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.

What is the duration of this course?

This course takes 3 days to complete during which delegates participate in intensive learning sessions that cover various course topics.

How long until I receive the course confirmation details?

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.

What will I learn in this Oracle Database 12cR2, 18c and 19c Certification Course?

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.

Do you provide a certificate after completion of this training?

Yes, after completing this course you will receive a certificate of completion to validate your achievement and demonstrate your proficiency in the course material.

What are the benefits of attending this Oracle Database 12cR2, 18c and 19c Training?

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.

Do you provide self-paced learning for this Oracle Database 12cR2, 18c and 19c Online Training?

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.

Do you provide corporate training for this course?

Yes, we provide corporate training for this course, tailored to fit your organisation’s requirements.

Who should I contact if I'm unable to access this training?

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.

What kind of jobs can I expect after completing this training?

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.

What is the level of difficulty for this Oracle Database 12cR2, 18c and 19c Certification Training?

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.

Will the course cover migration strategies between these Oracle versions?

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.

Why choose The Knowledge Academy in Canberra over others?

The Knowledge Academy in Canberra 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.

What is the cost/training fees for Oracle Database 12cR2, 18c and 19c New Features for Administrators in Canberra?

The training fees for Oracle Database 12cR2, 18c and 19c New Features for Administrators in Canberra starts from AUD6295

Which is the best training institute/provider of Oracle Database 12cR2, 18c and 19c New Features for Administrators in Canberra?

The Knowledge Academy is one of the Leading global training provider for Oracle Database 12cR2, 18c and 19c New Features for Administrators.

What are the best Oracle Training courses in Canberra?

Please see our Oracle Training courses available in Canberra

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

Oracle Database 12cR2, 18c And 19c New Features For Administrators in Australia

Sydney Melbourne Brisbane Perth Canberra Adelaide Darwin