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

Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
This Oracle Database 12cR2, 18c and 19c New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new non-container database features that have been introduced in Oracle Database 12cR2, 18c and 19c.
The delegate will gain an appreciation of how the enhanced features of Oracle Database 12cR2, 18c and 19c may be implemented at their own site.
Note: The focus of this course is on the general new features that have been introduced in Oracle Database 12cR2, 18c and 19c. The course covers an overview only of container and pluggable databases. The Oracle 18c Container and Pluggable Database Administration course covers Multitenant Architecture features in detail.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Objectives
The delegate will learn and acquire skills as follows:
- Install the Oracle Database 12cR2, 18c or 19c software with the OUI
- Create a non-container Oracle Database 12cR2, 18c or 19c Database
- Upgrade an Oracle database to Oracle 12cR2, 18c or 19c
- Migrate a database with Data Pump
- New database management features
- Enhancements to Unified Auditing
- Enhancements to administrative privileges and profiles
- Enable Privilege Analysis as part of the Enterprise Edition
- Schema and data management new features
- The SQL*Plus history commands and the SQLcl utility
- New SQL and PL/SQL features
- New RMAN and availability features
- Data Redaction and Data Encryption Enhancements
- Performance tuning new features
- Data Pump, SQL*Loader and External Table new features
- Partitioning enhancements
- Big Data and Data Warehousing new features
- Database Diagnostic new features
- SQL Tuning enhancements using the Optimizer Statistics Advisor and SQL join processing
- Using the Trace File Analyzer to collect and diagnose issues
- Data Guard, Active Data Guard and the Broker new features
- Use In-Memory Column Store new features to increase SQL performance
Target Audience
This Oracle Database 12cR2, 18c and 19c New Features for Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new non-Multitenant Architecture features and functionality introduced in Oracle Database 12cR2, 18c and 19c.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
Delegates attending the Oracle Database 12cR2, 18c and 19c New Features for Administrators course should have administration experience of Oracle Database 12.1. Knowledge of using PL/SQL packages is strongly recommended.
This course is run on a Linux operating system, a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
Linux Introduction
A 3-day Training Course on LINUX Introduction; training course gives practical knowledge of LINUX Operating System, command structures and editor facilities.
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
Code | Location | Duration | Price | Apr | May | Jun | Jul | Aug | Sep |
---|---|---|---|---|---|---|---|---|---|
Later scheduled dates may be available for this course. |