Oracle21c New Features

This course has been superseded

We suggest the following instead:
Advanced PL/SQL Tips and Techniques

Course Description

Give your IT staff the knowledge of using Oracle’s latest database new features. This course will cover the new features of the Oracle12C base database products (Oracle12C & 18C) and the Oracle19C base datatabase products (Oracle19C & 21C). The course will start off with working with installation and upgrade considerations. The new container databases, how to setup application and users, and how to manage moving current applications to this new environment. There are plethoras of new SQL tuning features that are covered. This course will cover SQL and PL/SQL new features. This course is designed for both DBAs and Developers with an emphasis on items of interest to Application developers. The course utilizes a variety of current tools. Students will have the opportunity to learn more about TOAD, SQL Developer, as well as the Oracle tools like SQL*Plus.
1 Day
Contact us for pricing
 

Prerequisites

A working knowledge of SQL and PL/SQL is required.

Topics covered

Oracle RDBMS Architecture and Product Direction
Oracle12c and Oracle19c system requirements/upgrading
Oracle Multi-tenant Database (Pluggable Database)
SQL and PL/SQL New Features
In Memory New Features
Partitioning New Features
Sharding New Features
External Table support for Hadoop and others
New Security Features
Performance Related New Features

Day One

Oracle RDBMS Architecture

Oracle RDBMS system requirements/upgrading
System Requirements
Supported Platforms
Where to get the software
Don’t forget the documentation!

SQL and PL/SQL New Features
New/Enhanced DDL
New features for Sequences
Row pattern matching
Left Outer Join
Fetch First
New column limits
Identity/Invisible columns
New Index Features
New Truncating Features
“Run Faster” PL/SQL Functions
New Features for GT’s
Changes to PL/SQL Program unit security

Day Two

Data Warehouse and BI New Features
Advanced Analytics
New OLAP/OBIEE Features
Information Lifecycle
In Database Archiving
Temporary Validity
Data Optimization (Heat Maps)
Compression
Temporal History

New Security Features
Auditing
Privilege Analysis
Data Redaction
Security Improvements
New Password Requirements

Performance Related New Features
Adaptive Stats/Incremental Stats
Adaptive Query Optimization
New Items in Explain Plans
Updated Histograms

Day Three

Partitioning New Features

Sharding New Features

In Memory New Features

External Tables, Hadoop, and other database support

Deprecated and Desupported Features

About Dan Hotka

Dan Hotka is a Training Specialist and an Oracle ACE Director Alumni (a recognized outside expert/evangelist on Oracle Products) who has over 40 years in the computer industry, over 34 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 14 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan is available for training in Ireland exclusively through Professional Training.
OracleDan HotkaDBAOracle 19cOracle Database 19cOracle PL/SQLOracle PL/SQL TuningOracle SQLOracle SQL Performance TuningOracle SQL TuningOracle SQL Tuning19cOracle TuningOracle 21cOracle Expert