Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
24 Hours
-
HRDF SBL Claimable
-
Certificate of Attendance available
-
90 days of access from date of activation
-
3 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
Request more information
Inquiry for: Myself My Company
By providing your contact details, you agree to our Privacy Policy
Thank You
Our learning consultant will get back to you in 1 business day
Oracle Database 18c: New Features for Administrators Ed 1
WHAT YOU WILL LEARN
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.
AUDIENCE
• Database Administrators
• Database Administrators
• Database Developers
• Database Developers
PREREQUISITES
Suggested Prerequisite
• Knowledge of Oracle Database 11g R2 and 12c
Required Prerequisite
• Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1
• Oracle Database 12c R2: New Features for Administrators Part 2
• Oracle Database 12c R2: High Availability New Features
METHODOLOGY
This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises
COURSE OBJECTIVES
After completing this course, students will be able to:
• 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
Modules
• Use refreshable copy PDB switchover
• Configure encryption of sensitive data in Database Replay files
• Export and import database links
• Create and use a schema only account
• Explain direct Active Directory Services integration
• Isolate PDB keystores
• 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
• Merging of partitions and subpartitions online
• Generate batched DDL by using DBMS_METADATA_DIFF package
• Manage private temporary tables
• Online modification of partitioning and subpartitioning strategy
• Use the new Data Pump Import option of the DATA_OPTIONS parameter
• Describe the new SQL Tuning Set package
• Use IMEs window capture
• Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
• Configure Automatic In-Memory
• Use analytic view new query capabilities
• Query inlined external tables and manage in-memory external tables
• Create and use polymorphic table functions
• Understand support for PDBs as shards
• Describe Oracle GoldenGate enhancements for Oracle Sharding support
• Describe improved multi-shard query enhancements
• Query system objects across shards
• Describe the user-defined sharding method
Course Reviews
0
0 Ratings