• Course Overview
  • Objectives
  • Prerequisites
  • Course Outline

In this database administration course students gain the skills necessary for how to install and maintain an Oracle database.Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

After completing this course, the participant will be able to:

Participants are required to meet the following prerequisites:

70 hours

Advanced Administration

  • Flash recovery area
  • Oracle flashback database
  • Guarantee Restore point
  • Plug-able database management
  • LAB - Configure FRA
  • LAB - Create restore points
  • LAB - Flash back database to restore point
  • LAB - Create plug-able database using DBCA
  • LAB - Start, stop, connect to plug-able and container database
  • LAB - Drop pluggable Database

ASM Concepts

ASM Administration

  • LAB - Create and delete Automatic Storage Management (ASM) disk groups
  • LAB - Set the attributes of an existing ASM disk group
  • LAB - Perform ongoing maintenance tasks on ASM disk groups
  • LAB - Monitor ASM using the V$ASM dynamic performance views
  • LAB - Migrate Non ASM to ASM Database

Enterprise Manager Cloud control Concept

EM Administration

  • LAB - Install oracle RDBMS
  • LAB - Install repository
  • LAB - Install Cloud control
  • LAB - Integrate existing database with cloud control
  • LAB - Start/Stop Cloud control

Transparent Data Encryption Concept

Database Vault Concept

  • LAB - Configure TDE on table level
  • LAB - Configure TDE on column level
  • LAB - Enable database vault
  • LAB - Disable database vault
  • LAB - Access Database Vault through EM

Data guard Configuration

  • Data guard Concepts
  • Data guard Administration
  • Data guard Benefits
  • LAB -Configure Data guard
  • LAB - Configure data guard broker and use fast-start fail over
  • LAB - Create and manage a physical / logical and snapshot standby
  • LAB - Active Data Guard
  • LAB - Real time apply
  • LAB - Switch over / Fail over

RMAN

  • RMAN Concepts
  • Archive log Concepts
  • Retention policy
  • Backup types
  • Restoration
  • LAB - RMAN Concepts
  • LAB – Archive log Concepts
  • LAB - Retention policy
  • LAB - Backup types
  • LAB - Restoration
  • LAB - RMAN Hot Backup
  • LAB - Recovery
  • LAB - Incremental & Cumulative backups
  • LAB - Backup retention policies
  • LAB - Restoration & Recovery scenarios

Real Application Cluster

  • Oracle Grid Infrastructure Concepts
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • LAB - Implement Pre-requisites for RAC Installation
  • LAB - Configure storage RAC Installation
  • LAB - Install Grid Infrastructure
  • LAB - Install Oracle RDBMS
  • LAB - Database creation
  • LAB - RAC Testing
  • LAB - RAC Troubleshooting

Performance & Tuning

  • A review of the Oracle architecture
  • Overview of SQL tuning
  • Oracle RAM usage and bottlenecks
  • Oracle CPU usage and bottlenecks
  • Oracle disk I/O overview
  • Overview of AWR/ADDM Reports
  • LAB - Memory tuning
  • LAB - Trace sql statements
  • LAB - Generate explain plan
  • LAB - Monitor CPU/IO/Memory
  • LAB - Generate AWR/ADDM Reports
  • Oracle Indexing
  • Oracle parsing
  • Optimizer modes
  • Oracle Partitioning
  • LAB - Creating indexes
  • LAB - Rebuild indexes
  • LAB - Gather statistics
  • LAB - Create table partitions

Goldengate Configuration

  • Technology Overview
  • Oracle Golden gate architecture
  • LAB - Install Golden gate
  • LAB - Configure Golden gate
  • LAB - Configure Golden gate replication
  • LAB - Monitor Replication
  • LAB - Start/Stop Replication

Contact Us and let our consultant support you to assess the training requirements for your organization

Get in touch with our consultants