Description

The Oracle Database 18c: New Features for Administrators course will provide professionals an overview of the Oracle Database 18c new features and enhancements associated to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Radiant Techlearning offers Oracle Database 18c: New Features for Administrators Training Program in Classroom and Virtual Instructor Led/Online mode.

 

Duration: 3 days

 

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

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 Golden Gate enhancements for Oracle Sharding support
  • query system objects across sshard
  • 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 professionals learn how to use these new or enhanced features of Oracle Database 18c.

 

Learning Objectives

  • 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

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

Audience Profile

  • Database Administrator
  • Developer

Course Content

Module 1: 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

Module 2: 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

Module 3: 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

Module 4: 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

Module 5: 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

Module 6: 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

Module 7: 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

FAQs

Q: What is active directory services integration?

 

A: It is newly created tool to add, modify, delete and organize various Windows accounts. It can also display and test Oracle database administration service and publish resources in the directory.

 

Q: What are the advantages of the implementation of sharding method being followed up in the administration?

 

A: Implementation of Sharding process has advantages listed below:-

  • Linear scalability along with complete fault isolation
  • Global data distribution for data proximity implementation
  • Simplicity via multi life management automation cycle service
  • Superior run time performance intelligence depending on data routing

 

Q: What is meant by PDB snapshot carousel?

 

A: PDB snapshot is in fact nomenclated replica of a PDB at a specific point of time. Such type of 8 snapshots form a snapshot carousel.  When the maximum limit of carousel is reached, it automatically overwrites the oldest copy.

 

Q: What is meant by In-Hash Index structure?

 

A: Actually Hash Indexes refer to organized collection of buckets in an array.Each bucket contains pointer at beginning of the row, to let us review the latest data update.

 

Q: How does a SQL Exadata helps in enhancing performance of database?

 

A: Exadata storage facilitates the database with aware storage services with various provisions like offline database processing from the base server to storage. It also boosts data transferring in magnitude order.

 

Q: What is GoldenGate?

 

A: Oracle database facilitates with the GoldenGate product which helps in filtering, replication and transforming of data from one database to other and also has the service of transforming from Oracle to the other heterogeneous databases.

 

Q: Why one should prefer Radiant Techlearning ?

 

A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.

 

Q: What if I/we have doubts after attending your training program?

 

A: Radiant team of experts would be available on the e-mail support@radianttechlearning.com to answer your technical queries even after the training program.

 

Q: Does this training program include any project?

 

A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.

 

Q: If I face technical difficulty during the session then is there any remedy for that?

 

A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.

 

Q: What is schedule of training program?

 

A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch