Oracle 19c New Features

Course Objectives

Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore:

• New Features Overview
• Multitenant New Features
• Security Features
• Cloud Services
• Networking
• Globalization
• Big Data Support
• Database Installation and Configuration
• Database Tuning
• Backup and Recovery

Need different skills or topics?  If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate.  We offer a wide variety of Oracle, database and other related topics that may be blended with this course for a track that best suits your needs.  Our team can help design the course or learning path that best meets your needs and skills goals.

Course Prerequisites

This hands-on course is geared for IT professionals with prior database experience.  Incoming students should possess Basic understanding of Oracle Database principles.

Course Agenda

1. Oracle 19c New Features Overview

• Introduction to Oracle 19c New Features

2. Oracle 19c Multitenant New Features

• Refreshable PDB Switchover
• PDB Integration with Data Guard
• PDB Snapshot Carousel
• CDB Fleet Management

3. Oracle 19c Security Features

• Profile Lockdown
• Create a User Defined Master Encryption Key
• Encrypted Passwords in Database Links and Data Pump
• Create Keystores for Pluggable Databases
• Datapump and Unified Auditing
• Schema Only Accounts

4. Oracle 19c Cloud Services

• Oracle IaaS
• Oracle Saas
• Oracle PaaS

5. Oracle 19c Networking

• Database Connection Manager
• Database Proxy Support
• Tenant Isolation

6. Oracle 19c Globalization

• New globalization for Bind Variables
• New Database Local Support
• Additional Unicode Support

7. Big Data Support

• New Analytic Support
• Data Mining DataWarehouse
• Additional Parallel Processing Support
• Inline External Tables

8. Database Installation and Configuration

• Zero Downtime Upgrades
• Dry Run Command implementation
• New location for Password File
• Improved Bulk Operations

9. Database Tuning

• SQL Tuning Advisor and Exadata
• New SQL Tuning Set API
• Concurrent SQL and Sql Performance Analyzer
• Database In Memory Features
• In Memory Support for External Tables
• In Memory Features for Analytics

10. Oracle 19c Backup and Recovery

• Active Pluggable Cloning
• Pluggable and non Pluggable Database Migration

Course Materials

Student Materials: Each participant will receive a digital Student Guide and/or Course Notes, code samples, software tutorials, step-by-step written lab instructions (as applicable), diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Hands-On Setup Made Simple! Our dedicated tech team will work with you to ensure our ‘easy-access’ cloud-based course environment, or local installation, is accessible, fully-tested and verified as ready to go well in advance of the course start date, ensuring a smooth start to class and effective learning experience for all participants. In some cases we can also help you install this course locally if preferred. Please inquire for details and options.

Every-Course Extras = High-Value & Long-Term Learning Support! All Public Schedule courses include our unique EveryCourse Extras package (Course Recordings, Live Instructor Follow-on Support, Free *Live* Course Refresh Re-Takes, early access to Special Offers, Free Courses & more). Please inquire for details.