> Formations > Oracle Database 23ai: New Features for Administrators
Vous avez déjà un compte client ORSYS
Se connecter
Vous êtes nouveau chez ORSYS
Créer un compte
Vous ne souhaitez pas créer de compte
Poursuivre sans me connecter

Course : Oracle Database 23ai: New Features for Administrators

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY

Practical course - 3d - 21h00 - Ref. OAI

Oracle Database 23ai: New Features for Administrators

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY


New course

In this training course, you'll learn what's new in Oracle Database 23ai: performance, security, architecture and partitioning. You'll also learn how to use Blockchain tables, migrate data with RMAN, manage large tables and unlocked reservations. Exercises are carried out on 23ai, with notions valid for previous versions.


IN-HOUSE
CUSTOM

Training at your location, our location or remotely

Ref. OAI
  3d - 21h00
Would you like to transpose this course—without changes—for your company?
Download in PDF format

Share this course by email




In this training course, you'll learn what's new in Oracle Database 23ai: performance, security, architecture and partitioning. You'll also learn how to use Blockchain tables, migrate data with RMAN, manage large tables and unlocked reservations. Exercises are carried out on 23ai, with notions valid for previous versions.


Teaching objectives
At the end of the training, the participant will be able to:
Discover the key new features of Oracle Database 23ai
Improve performance and transaction processing
Understand changes in Oracle architecture
Reinforcing security and access management
Take advantage of new data-sharing options
Master features such as Blockchain, RMAN and wide tables
Apply these new features through practical exercises

Intended audience
Database administrators, database designers and developers.

Prerequisites
Experience with previous versions of Oracle Database and a good understanding of IT technical English.

Certification
This course helps you prepare for the Oracle Database 23ai Administration Certified Associate exam (exam 1Z0-182).
Comment passer votre examen ?

Practical details
Teaching methods
Animation de la formation en français. Support de cours et travaux pratiques en anglais, au format numérique et ACCESSIBLE UNIQUEMENT PENDANT 90 JOURS. Bonne compréhension de l’anglais à l’écrit.

Course schedule

1
Blockchain Table

  • What's new in Blockchain Tables in Oracle Database 23ai.

2
Availability

  • Simplified cross-platform database migration via RMAN backups.
  • Automatic transaction rollback.
  • Automatic transaction quarantine.
  • Location of Flashback logs.

3
Database architecture

  • Unrestricted direct loading.
  • Lock-Free Reservations.
  • Unrestricted parallel DMLs.
  • Wide Columns.
  • Better performance with Hybrid Columnar Compression (HCC).

4
Performance

  • Improvements to Fast Inserts.
  • Faster writing of LOB SecureFiles.
  • Data storage improvements.

5
Data analysis

  • What's new in Oracle Database 23ai for Automatic SQL Plan Management.

6
Manageability

  • Changes to time and date management.

7
Security

  • New security features in Oracle Database 23ai.

8
Sharding

  • New Sharding features in Oracle Database 23ai.
PARTICIPANTS
Database administrators, database designers and developers.

PREREQUISITES
Experience with previous versions of Oracle Database and a good understanding of IT technical English.

TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.

ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.

TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.

TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.

ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.

This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.


This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.