> Formations > Oracle Database 19C: Administration Workshop

Publication date : 01/24/2024

Course : Oracle Database 19C: Administration Workshop

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY

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

Oracle Database 19C: Administration Workshop

OFFICIAL COURSE: DIGITAL SUPPORT AVAILABLE FOR 90 DAYS ONLY



With this course, you will learn the basics of Oracle database administration and management. You will also gain a conceptual understanding of Oracle database architecture.


INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Available in English on request

Ref. ODW
  5d - 35h00
Contact us




With this course, you will learn the basics of Oracle database administration and management. You will also gain a conceptual understanding of Oracle database architecture.


Teaching objectives
At the end of the training, the participant will be able to:
Describe Oracle database architecture
Describe the architecture and functionalities of Oracle Database Cloud Service (DBCS)
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Moving data between databases and files
Use basic monitoring procedures and manage performance

Intended audience
Database and data warehouse administrators, database designers, support engineers and technical administrators.

Prerequisites
Completion of Oracle Database 19c: SQL Workshop or equivalent knowledge and skills. Understanding of English and IT-specific English vocabulary.

Certification
Successful completion of the exam leads to certification "Oracle Database Administration I".
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 the Oracle database


2
Accessing an Oracle database


3
Create an Oracle database using the DBCA tool


4
Create an Oracle database using a SQL command


5
Starting and stopping a database instance


6
Managing database instances


7
Oracle Net Services overview


8
Configuring naming methods


9
Configuring and administering the Listener


10
Configuring a shared server architecture


11
Configuring Oracle Connection Manager for multiplexing


12
Configuring Oracle Connection Manager for access control


13
Create pluggable databases (PDB) from a model (Seed)


14
Using other techniques to create PDBs


15
Managing PDBs


16
Database storage overview


17
Creating and managing tablespaces


18
Manage cancellation data


19
Configuring privilege and role authorizations


20
Setting user resource limits


21
Implement Oracle database auditing


22
Introduction to loading and transporting data


23
Load and transport data


24
Use external tables to load and transport data


25
Automated maintenance tasks: presentation


26
Automated maintenance tasks: task and Windows management


27
Overview of monitoring and control performance


28
Monitor database performance


29
Database processes


30
Managing memory


31
Analyze SQL performance and optimize access paths