Oracle19c 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 Oracle 12c through Oracle19c. 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. This course will cover SQL and PL/SQL new features. This course is designed for both DBAs and 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

Oracle19c Architecture
Oracle19c system requirements/upgrading
Oracle19c Multitenant Database (Pluggable Database) New Features
Backup/Recovery/Data Guard New Features
Manage Private Temporary Tables
SQL and PL/SQL New Features
New Security Features
New Manageability Features
Performance Related New Features
Database Sharding Features and Updates
In_Memory Features and Updates
JSON New Features
More New Features and Depreciated Features

Attendees Receive

Useful SQL and SQL*Plus scripts
A hands-on opportunity to learn more about Oracle19c, TOAD, and SQL Developer

Day One

Oracle19c Architecture
Oracle19c system requirements/upgrading
System Requirements
Supported Platforms
Where to get the software
Don’t forget the documentation!
Oracle19c Multitenant Database (Pluggable Database)
New Features and Updates
Backup/Recovery/Data Guard New Features

Day Two

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

Partitioning Enhancements

Sharding New Features
Support for Standby Database
Unique Sequence across Shards
Better PDB Support
Parameter Sharing

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

New Manageability Features
Many new Online Operations
New Enterprise Manager Database Express
New Administrator Privileges
Database Replay Enhancements
Query able Patch Inventory
Database Cloning
New Scheduler Script Jobs

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

In_Memory New Features
Support for External Tables
Dynamic Capture

JSON New Features
New ‘TREAT’ syntax
Support for LOB data types
New dictionary views
Key Field Name Updates
Object Mapping
New Update Operation
Syntax Simplifcations

More New Features
Data Pump Updates
Private Temporary Tables

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 Expert