Oracle Database 19C Training in Kuala Lumpur, Malaysia

This course offers an in-depth introduction to Oracle Database 19c, Oracle's long-term support release. Participants will gain foundational and advanced skills for administering Oracle databases, including installation, architecture, user management, backup and recovery, performance tuning, and security. Through practical labs, learners will develop the competencies required to manage an Oracle environment confidently.

Course Agenda

Introduction to Oracle 19c

• Features of Oracle 19c

• Editions and licensing overview

• Tools and interfaces (SQL*Plus, OEM, DBCA)

Oracle Database Architecture

• Physical and logical structures

• Memory structures and background processes

• Instance vs. database

Installing Oracle Database 19c

• System requirements

• Installation using Oracle Universal Installer (OUI)

• Creating a database using DBCA

Managing the Database Instance

• Starting and stopping the database

• Initialization parameters and SPFILE

• Diagnostic and alert logs

Managing Users and Security

• Creating users and assigning roles

• System vs. object privileges

• Auditing and password policies

Storage Management

• Tablespaces and data files

• Managing undo data

• Temporary tablespaces and redo logs

Backup and Recovery

• Oracle backup strategies

• RMAN configuration and usage

• Performing backups and restores

• Flashback technologies

Database Monitoring and Performance Tuning

• Monitoring tools: AWR, ADDM, Enterprise Manager

• Performance tuning best practices

• Using Automatic Workload Repository (AWR)

Hands-on Exercises