> Formations > Oracle Database 23ai: Administration Workshop
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: Administration Workshop

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY

Practical course - 5d - 35h00 - Ref. OAW

Oracle Database 23ai: Administration Workshop

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY


New course

With this training course, you'll learn how to install, manage and secure an Oracle database. You'll learn how to create databases, configure Oracle Net Services, manage users, backups and prevent failures. Exercises are based on Oracle Database 23ai, but concepts also apply to previous versions.


IN-HOUSE
CUSTOM

Training at your location, our location or remotely

Ref. OAW
  5d - 35h00
Would you like to transpose this course—without changes—for your company?
Download in PDF format

Share this course by email




With this training course, you'll learn how to install, manage and secure an Oracle database. You'll learn how to create databases, configure Oracle Net Services, manage users, backups and prevent failures. Exercises are based on Oracle Database 23ai, but concepts also apply to previous versions.


Teaching objectives
At the end of the training, the participant will be able to:
Explain the memory architecture and processes of an Oracle database
Configure listener and naming methods to establish connections
Create and manage an Oracle database
Manage tablespaces and optimize UNDO space
Create and administer plug-in databases (PDBs)
Manage users, roles and privileges
Define and apply audit strategies, analyze results
Configure and monitor automatic maintenance tasks
Transport and import data between Oracle databases
Monitor and optimize SQL and database performance

Intended audience
Database administrators, database designers and developers.

Prerequisites
Knowledge of databases, as well as a good command of technical English and IT vocabulary.

Certification
This course helps you prepare for the [ Oracle Database 23ai Administration Certified Associate " 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
Introduction to database architecture and tools

  • Oracle database architecture.
  • Access to an Oracle database.
  • Database management tools.

2
Database creation, management and settings

  • Base creation with DBCA.
  • SQL database creation.
  • Start and stop a database.
  • Database instance management.

3
Database connections

  • Oracle Net Services.
  • Configuration of naming methods.
  • Listener configuration and administration.
  • Shared server configuration.

4
Storage, tablespaces, space management and UNDO

  • Database storage overview.
  • Create and manage tablespaces.
  • Optimized use of space.
  • UNDO data management.

5
PDB creation and management

  • PDB creation from seed model.
  • Other PDB creation methods.
  • PDB management.

6
User creation and management

  • Create and manage user accounts.
  • Configure privileges and roles.
  • Set user resource limits.

7
Implementing Oracle Database auditing

  • Understanding auditing.
  • Configure auditing.

8
Data loading and transport

  • Introduction to loading and transporting data.
  • Data loading.
  • Data transport.
  • Use of external tables.

9
Database management and performance overview

  • Automated maintenance tasks.
  • Task and window management.
  • Database performance monitoring.
  • Database performance monitoring.
PARTICIPANTS
Database administrators, database designers and developers.

PREREQUISITES
Knowledge of databases, as well as a good command of technical English and IT vocabulary.

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.