I. Overview:

Oracle Database 19c: Administration Workshop Course Overview.

Oracle Database 19c Administration Workshop is an intensive learning experience in which the student gains hands-on and theoretical knowledge of Oracle Database 19c. The course provides a comprehensive introduction to the administration of Oracle 19c Database, covering topics such as installation, tuning, backup/recovery, security, and troubleshooting. It also covers more advanced topics like Oracle Routines, Autonomous Database, and multitenant architectures. This course is designed for those professionals looking to get up and running in the Oracle Database 19c environment quickly and confidently, and it is especially useful for those administering and managing Oracle Database 19c in mission-critical environments.

II. Duration: 5 days (40 hours)

III. Objectives:

After completing the Oracle Database 19c: Administration Workshop Course, individuals will acquire skills in managing an Oracle database, installing and crafting database environments, creating and managing database storage structures, managing database security, monitoring performance, managing database performance, implementing Oracle database auditing, database backup and recovery, and understanding Oracle Database Cloud Service. In essence, the certification will equip individuals with comprehensive knowledge of Oracle database administration.

After completing the Oracle Administrator (OCA) course, students will be able to pass exams: 1z0-082: Oracle Database Administration I. The first exam in the two exam path to obtain the Oracle Certified Professional (OCP) 19c certification.

IV. Intended Audience:

• Database administrators
• IT professionals looking to update their knowledge on Oracle Database
• System analysts and engineers
• IT managers handling database solutions
• Data warehouse administrators
• Technical consultants
• Tech-savvy individuals who want to expand their skill envelope Individuals seeking Oracle Database certification.

V. Prerequisites:

There are several prerequisites for attending this courses. Candidates should have the following:

• Basic understanding SQL
• Knowledge in Linux Operating System

VI. Course outlines:

1. Module 1: Introduction to Oracle Database 19c Administration

• Overview of Oracle Database Architecture
• Understanding Oracle Database Editions
• Preparing the Environment for Oracle Database Installation
• Installing Oracle Database 19c
• Configuring Oracle Net Services

2. Module 2: Managing Oracle Database Instance

• Understanding Oracle Database Instance
• Managing Database Initialization Parameters
• Starting and Stopping the Database
• Managing Memory and Processes
• Managing Control Files, Redo Logs, and Archive Logs
• Managing Database Storage

3. Module 3: Managing Oracle Database Storage Structures

• Understanding Oracle Database Storage Structures
• Managing Tablespaces and Data Files
• Managing Undo Data
• Managing Temporary Data
• Managing Oracle Database Files and Directories
• Managing Automatic Storage Management (ASM)

4. Module 4: Managing Users and Security

• Understanding Oracle Database Security Concepts
• Managing Database Users and Roles
• Managing Privileges and Permissions
• Managing Passwords and Profiles
• Managing Audit Policies

5. Module 5: Performance Tuning

• Monitoring and Tuning Oracle Database