Oracle DBA Training

Oracle Database Administrator (Oracle DBA) Training brings the best practices involved to install, configure, upgrade, administer, monitor, maintain, and secure Oracle databases in an organization.

Oracle DBA Training Curriculum

Overview of Oracle Database Administration

Relational Databases (RDBMS): Introduction

What is SQL?, Roles & Responsibilities of DBA

Oracle Architecture Process Architecture

Physical and Logical structures of Database

Types of files (Control file, Redo log file and Data file)

Different types of Data files Instance, SGA (System Global Area) and Background Process
Database Creation

Using Oracle Universal Installer

Installation Prerequisites

Setting Environment Variables

Installing the Oracle Database Software: Steps

Using the Database Configuration Assistant (DBCA)

Different Startup Modes

Different Shutdown Modes

Types of Database Creation

Introduction to Table space

Types of Table space
Configuring The Oracle Network Environment

Tools for Configuring and Managing the Oracle Network

Using the Listener Control Utility

Connecting to an Oracle Database

Oracle Net: Naming Methods

Using Oracle Net Manager to Configure Local Naming


Network default location

Introduction to Database Links
Managing The Oracle Instance

Oracle Instance Management

Oracle Processes

Oracle Memory Structures

Starting the Instance and Opening the Database

Shutting Down an Oracle Database Instance

Viewing and Modifying Initialization Parameters

Managing Memory Components

Viewing the Alert Log
Storage Parameters

Oracle Database Structures

Exploring the Storage Structure of the Oracle Database

What are segments?

What are extents?

What is Blocks?

Dictionary Managed Table space

Locally Managed Table space

Storage Parameters (Initial, Next, Min Extents, Pct increase)

Managing Undo Data
User Management

Who are Database Users?

Why to create a User?

Creation of Users

Assigning Privileges

Creating and granting Roles

Assigning default table space for the Users

Setting Profiles for the Users

Levels of Authentication
SPFile & PFile Managment

What is spfile?

Difference between spfile and pfile

Advantages of spfile
Redo-Log & Control File Management

Introduction to Redo log

Status of Redo logs

Multiplexing the Redo log files

Introduction/Multiplexing the Control file
Logical Backup/Restore

What is a logical backup

Why is it required

Export/import Utility

Data Pump

Difference between Data Pump and Traditional Export/import
Managing Oracle Database & Software

Managing the Oracle database –proactive checks

Understanding Software Management and Patch Releases

Patching Oracle Database Software

Using the Database Upgrade Assistant to Upgrade the Database
Creating Backups With RMAN

RMAN backup types

Creating and Using the RMAN backups

RMAN restore and recovery process
RMAN – Duplicating A Database

Purpose and Methods of Cloning a Database

Using RMAN to Create a Duplicate Database
Performance Management

Performance Monitoring

Managing Memory Components

Invalid and Unusable Objects

Automatic Workload Repository Baselines

V$ Views, Statistics and Metrics
Working With Oracle Support

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)

Manage patches
Moving Data / Data Migrations

Describe ways to move data

General architecture

Use Data Pump export and import to move data

Tools to data migrate
Introduction To ASM & RAC

Introduction of Oracle ASM.

Introduction to Oracle RAC

Database Best Practices & Scripts

Oracle features.

  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query
[contact-form-7 id="5639" title="Drop Us A Query"]
Create an Account