Free Webinar: ForgeRock Launches On Demand Training

closeClose

Oracle Database 18c: New Features for Administrators

  • Tuition USD $2,316 - $2,442
  • Reviews star_rate star_rate star_rate star_rate star_half 944 Ratings
  • Course Code 18cDB-NF-ADMIN
  • Duration 3 days
  • Available Formats Virtual, Classroom

This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Learn To:

  • Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.
  • Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.
  • Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.
  • Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.
  • Configure and use new features like Automatic In-Memory Management in Performance.
  • Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.
  • Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.

Benefits to You

The Multitenant architecture lesson covers CDB fleet, PDB snapshots carousel, dynamic container map, lockdown profile inheritance, static & dynamic lockdown profiles, refreshable copy PDB switchover, parallel statement queuing at PDB level and PDB cloning with DBCA.

The Security lesson covers schema only accounts, PDB keystore in isolated mode versus united mode, user-defined TDE master key, export and import database links, encryption of sensitive data in Database Replay files, Database Replay capture and replay with Database Vault,and direct Active Directory Services integration.

The RMAN lesson covers reuse of preplugin backups before and after a non-CDB conversion as a PDB or of a PDB migration to another CDB, clone of active PDBs into another CDB using DUPLICATE command, duplication of on-premises CDBs to Cloud as encrypted.

The General Database lesson covers private temporary tables, Data Pump import with a new option of the DATA_OPTIONS parameter, online modification of partitioning and subpartitioning strategy, online merging partitions and subpartitions, batched DDL generation by using DBMS_METADATA_DIFF package, and benefit from Unicode 9.0 Support.

The Performance lesson covers configuration and usage of Automatic In-Memory, IMEs window capture, memoptimized rowstore feature and use of In-Memory Hash Index structures, description of the new SQL Tuning Set package, the concurrency of SQL execution of SQL Performance Analyzer tasks, the SQL Performance Analyzer Result Set Validation, SQL Exadata-aware profile.

The Data Warehousing lesson covers query inlined external tables, in-memory external tables, analytic view new query capabilities, polymorphic table functions and the new functions for approximate Top-N queries.

The Sharding lesson covers the user-defined sharding method, support for PDBs as shards, Oracle GoldenGate enhancements for Oracle Sharding support, query system objects across shards, how to set multi-shard query data consistency level, sharding support for JSON, LOBs, and spatial objects, improved multi-shard query enhancements, and where to find Oracle Sharding documentation in Oracle Database 18c.

Hands-on Practices and Demonstrations

Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 18c.

Skills Gained

  • Use new features of the Multitenant architecture
  • Understand and benefit from new features of the Database Security
  • Benefit from new features of RMAN
  • Use new features of General Database
  • Configure and use new features in Performance
  • Manipulate new features of the Data Warehousing
  • Understand enhancements in Sharding

Who Can Benefit

  • Database Administrator
  • Developer

Prerequisites

Suggested Prerequisite

  • Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1
  • Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1
  • Oracle Database 12c R2: High Availability New Features Ed 1

Required Prerequisite

  • Knowledge of Oracle Database 11g R2 and 12c

Course Details

Topics

  • Leveraging Multitenant Enhancements
    • Manage application PDBs fleet
    • Manage PDB snapshots carousel
    • Benefit from dynamic container map
    • Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
    • Use refreshable copy PDB switchover
  • Managing Security
    • Create and use a schema only account
    • Isolate PDB keystores
    • Export and import database links
    • Configure encryption of sensitive data in Database Replay files
    • Explain direct Active Directory Services integration
  • Using RMAN Enhancements
    • Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
    • Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
  • Applying General Database Enhancements
    • Manage private temporary tables
    • Use the new Data Pump Import option of the DATA_OPTIONS parameter
    • Online modification of partitioning and subpartitioning strategy
    • Merging of partitions and subpartitions online
    • Generate batched DDL by using DBMS_METADATA_DIFF package
  • Improving Performance
    • Configure Automatic In-Memory
    • Use IMEs window capture
    • Describe the new SQL Tuning Set package
    • Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
  • Handling Enhancements in Big Data and Data Warehousing
    • Query inlined external tables and manage in-memory external tables
    • Use analytic view new query capabilities
    • Create and use polymorphic table functions
  • Describing Sharding Enhancements
    • Describe the user-defined sharding method
    • Understand support for PDBs as shards
    • Describe Oracle GoldenGate enhancements for Oracle Sharding support
    • Query system objects across shards
    • Describe improved multi-shard query enhancements
  • Manage application PDBs fleet
  • Manage PDB snapshots carousel
  • Benefit from dynamic container map
  • Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
  • Use refreshable copy PDB switchover

Managing Security

  • Create and use a schema only account
  • Isolate PDB keystores
  • Export and import database links
  • Configure encryption of sensitive data in Database Replay files
  • Explain direct Active Directory Services integration

Using RMAN Enhancements

  • Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
  • Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted

Applying General Database Enhancements

  • Manage private temporary tables
  • Use the new Data Pump Import option of the DATA_OPTIONS parameter
  • Online modification of partitioning and subpartitioning strategy
  • Merging of partitions and subpartitions online
  • Generate batched DDL by using DBMS_METADATA_DIFF package

Improving Performance

  • Configure Automatic In-Memory
  • Use IMEs window capture
  • Describe the new SQL Tuning Set package
  • Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation

Handling Enhancements in Big Data and Data Warehousing

  • Query inlined external tables and manage in-memory external tables
  • Use analytic view new query capabilities
  • Create and use polymorphic table functions

Describing Sharding Enhancements

  • Describe the user-defined sharding method
  • Understand support for PDBs as shards
  • Describe Oracle GoldenGate enhancements for Oracle Sharding support
  • Query system objects across shards
  • Describe improved multi-shard query enhancements

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

The course for Cognos Enterprise Admin was wonderful! Learned a lot and have started applying what was learned. Thanks.

It would be better if the classroom had two power point screens so the instructor could have two screens shown to the class at the same time to reduce confusion switching back and forth

Ken was great, maintained energy throughout... was extremely knowledgeable.

ExitCertified will give you more knowledge especially about cloud server networking cabling etc.

Instructor was knowledgeable and made the course fun. He knew how to convey the new material to students in simple and understandable manner. Used terminologies and apologies understood by all students in the v.classroom.

7 options available

undo
  • Oct 6, 2020 Oct 8, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    06:00 AM 14:00 PM PST
    Enroll
    Enroll
  • Nov 2, 2020 Nov 4, 2020 (3 days)
    Location
    Edison, NJ
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Nov 2, 2020 Nov 4, 2020 (3 days)
    Location
    Ottawa
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Nov 2, 2020 Nov 4, 2020 (3 days)
    Location
    Edison, NJ
    Language
    English
    Time
    09:00 AM 17:00 PM EST
    Enroll
    Enroll
  • Nov 2, 2020 Nov 4, 2020 (3 days)
    Location
    iMVP
    Language
    English
    Time
    9:00AM 5:00PM EST
    Enroll
    Enroll
  • Nov 16, 2020 Nov 18, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    08:00 AM 16:00 PM GMT
    Enroll
    Enroll
  • Nov 23, 2020 Nov 25, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    06:00 AM 14:00 PM PST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward