We can host this training at your preferred location. Contact us!

This course covers the latest additions and improvements in Oracle Database 23ai. It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on performance, architecture, security, and database sharding. The topics include updates to Blockchain Tables, Data Migration with RMAN, Wide Tables, and Lock-Free Reservations.

Existing database administration experience on a modern version of Oracle Database.

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Module 1: Blockchain Table

Blockchain Tables 23c New Features

Objectives
Blockchain Table Overview
Blockchain Table User Chains
Blockchain Table Delegate Signer
Blockchain Table Countersignature
Summary

Module 2: Availability

Simplified Database Migration Across Platforms Using RMAN Backups

Objectives
Overview
Methods of transporting with Recovery Catalog
Methods of transporting in NOCATALOG mode
Methods of transporting over network link
Prerequisites generic
Prerequisites specific
Recovery Catalog methods for PDBs
Transport a PDB by using a pre-existing Backup with Recovery Catalog
Transport a PDB using multiple increamental Backups with Recovery Catalog
Recovery Catalog methods for Tablespaces
Recovery Catalog method for Tablespaces
Transport a Tablespace by using a pre-existing Backup with Recovery Catalog
Transport a Tablespace using multiple incremental Backups with Recovery Catalog
Transport a by using multiple incremental Backups with Recovery Catalog
Methods of transporting in NOCATALOG mode
NOCATALOG mode for PDBs
Quickly transport a PDB NOCATALOG
Transport a PDB using a pre-existing Backup NOCATALOG
Transport a PDB using multiple incremental Backups NOCATALOG
NOCATALOG mode for Tablespaces
Quickly transport a Tablespace NOCATALOG
Transport a Tablespace by using a pre-existing Backup NOCATALOG
Transport a Tablespace using multiple incremental Backups NOCATALOG
Methods of transporting over Network Link
Quickly transport a PDB over Network Link
Transporting PDBs by Restoring Backups Incrementally over the network
Methods of transporting over Network Link
Transporting Tablespaces over Network Link
Quickly transport a Tablespace over Network Link
Transporting Tablespaces by Restoring Backups Incrementally over the network
Summary

Automatic Transaction Rollback

Objectives
Overview
Using Automatic Transaction Rollback
Automatic Transaction Rollback
Using Automatic Transaction Rollback
Monitoring
Benefits
Summary

Automatic Transaction Quarantine

Objectives
Overview
Automatic Transaction Quarantine: Workflow
Monitoring Quarantined Transactions
Resolving Quarantined Transactions
Resolving Quarantined Transaction examples
Dropping Quarantined Transactions
Quarantined Transactions escalation
Summary

Flashback Log Placement

Objectives
Flashback Log overview
Flashback Log parameters
Flashback Log management
Summary

Module 3: Database Architecture

Unrestricted Direct Loads

Objectives
Direct Loads pre 23c
Direct Loads 23c
Benefits
Summary

Lock-Free Reservations

Objectives
Optimistic vs Lock Free
Optimistic approach
Lock-Free approach
Frequently modified values
Lock-Free reservations
Lock-Free reservation features
Lock-Free reservation benefits
Functionality requriements
Create, Modify, Delete
Lock-Free Journal Table
Journal Table restrictions
Lock-Free reservations
Views
Summary

Unrestricted Parallel DMLS

Objectives
Overview parallel DML
23c parallel DML improvements
Benefits
Summary

Wide Columns

Objectives
Priori challenges
Benefits
Increase Column Limits
Performance
Summary

Improved Performance Hybrid Columnar Compression (HCC)

Objectives
HCC pre 23c
HCC in 23c
Database compatibility
Performance
Summary

Module 4: Performance

Fast Inserts Enhancements

Objectives
Fast Ingest overview (AKA Deferred Inserts)
Using Fast Ingests
Enhancements
Benefits
Management
Summary

Accelerate SecureFiles LOB Write Performance

Objectives
Overview
Benefits
Summary

Data Storage Improvements

Objectives
SecureFiles
Traditional SecureFiles Shrinking
Automatic SecureFiles Shrinking: Advantages
High-level view
Controlling Automatic SecureFiles Shrink
Automatic storage compression
Automatic storage compression and automatic clustering
Automatic storage compression: Advantages
Controlling Automatic storage compression
Summary

Module 5: Data Analytics

Oracle Dataase 23c Automatic SQL Plan Management: New Features

Objectives
Automatic SQL Plan Management: Overview
SPM Evolve Advisor
Benefits
Problems it solves
When to use
how to use it
Summary

Module 6: Manageability

Time and Date Handling Changes

Objectives
Enhanced Time Zone data upgrade
Time Zone definitions change: Considerations
Optimizing Time Zone file upgrade
Benefits of enhanced Time Zone update
Tables with TIMESTAMP WITH TIME ZONE data
New parameter in the init.ora file
Configuring database parameters
SYSDATE and SYSTIMESTAMP
Data and Time in Oracle databases
Database time verus OS System time
Database-specific time in Oracle database 23c
Setting Database-specific time: Example
Summary

Module 7: Security

Oracle Database 23c Security: New Features

Objectives
Database Security
Pluggable Database Hybrid Read-only mode
Read-Only user and session
New Developer role
Simplified Schema privileges
Simplified Schema privilages: Example
Audit object actions at the column level
Ability to control authorizations for Unified Auditing with Database Vault
Integration of Microsoft Azure Active Directory with additional Oracle database environments
Summary

Module 8: Sharding

Oracle Database 23c Sharding New Features

Objectives
Database Sharding
Oracle database Sharding
Oracle database 23c Sharding new features
Sharding native replication (RAFT-based)
Directory-based Sharding
Coordinated Backup and Restore for Sharded databases
Centralized Backup recovery
Automatic bulk data move on Sharding key update
Split/Move of a partitionset with bulk data movement
Summary

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Oracle Database 23ai: New Features for Administrators Training Course in Canada

Canada is a North American country. Known as the second-largest country of the world, Canada’s capital city is Ottawa. Toronto, Vancouver and Montreal are the biggest and most popular cities of this country. The 8,891-kilometer southern and western border between Canada and the United States is the world's longest intergovernmental land border. This country also has the longest coastline in the world.

Canada is a constitutional monarchy. The country was originally a British Empire colony and is now a part of the British Commonwealth. Both French and English are Canada’s official languages. Canada’s national animal is a beaver and the its flag design is a vertical triband of red and white with a red maple leaf charged in the centre. Some of the top-rated tourist attractions in Canada are Niagara Falls, Banff National Park and Rocky Mountains, CN Tower in Toronto City, Bay of Fundy, Old Quebec (Vieux-Quebec in French), the ski resort of Whistler, Ottawa's Parliament Hill and Vancouver Island.

Choose from our extensive selection of IT courses, covering programming, data analytics, software development, business skills, cloud computing, cybersecurity, project management. Our highly skilled instructors will deliver hands-on training and valuable insights at a location of your choice within Canada.

Oracle Database 23ai: New Features for Administrators Training in Canada

Upcoming Trainings

Oracle Database 23ai: New Features for Administrators Training in Canada

Prerequisites

Outline

Upcoming Trainings