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

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

The Federal Republic of Germany is the second most populous country in Europe and is located in Central Europe. The official language of the country is German. Germany is one of the richest countries in the world. The main exports of the country include motor vehicles and iron and steel products.

Here are some fun facts about Germany:
The fairy tale writer, the Brothers Grimm, came from Germany and wrote many famous stories such as Cinderella, Snow White, and Sleeping Beauty.
Germany is home to the largest theme park in Europe, the Europa-Park.
The famous composer Ludwig van Beethoven was born in Germany.
The Autobahn, the German highway system, is known for having no general speed limit.

Berlin was divided by the Berlin Wall from 1961 to 1989. Known for its street art, Berlin has many colorful murals and graffiti throughout the city. Also, Berlin is home to many famous museums, such as the Pergamon Museum and the Museum Island. Many clubs and bars stay open until the early hours of the morning in this big city.

Another popular city is Munich, which is famous for its Oktoberfest beer festival that attracts millions of visitors every year. Munich is also home to many historic buildings, including Nymphenburg Palace and the Marienplatz town square.

The country's capital and largest city is Berlin, however Frankfurt is considered to be the business and financial center of Germany. It is home to the Frankfurt Stock Exchange, the European Central Bank, and many other financial institutions. Because of its central location within Europe and its status as a major financial hub, Frankfurt is often referred to as the "Mainhattan," a play on the city's name and its association with the Manhattan financial district in New York City.

Frankfurt is also a major transportation hub, with the largest airport in Germany and one of the largest in Europe, Frankfurt Airport. Additionally, it is a popular destination for tourists, with its historic city center, beautiful parks, and vibrant cultural scene.

Some of the top German technology companies like Siemens AG, Bosch, SAP SE, Deutsche Telekom, Daimler AG and Volkswagen has business centers in Frankfurt. The country has a strong tradition of engineering and innovation, and is home to many other world-class technology companies and research institutions.

Tailored to meet the specific needs of Germany, Bilginç IT Academy combines cutting-edge training methodologies with our comprehensive range of Certification Exam preparation courses and accredited corporate training programs. Experience a transformative approach to IT training that will redefine your expectations.

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

Upcoming Trainings

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

Prerequisites

Outline

Upcoming Trainings