Oracle DBA Database Administrator course Expert level by sequelgate

All our sessions are completely Practical and Real-time.

ORACLE DBA with PROJECT - CLASSROOM TRAINING COURSE DETAILS:

Oracle 11g RDBMS Architecture

Structural components of Server

Oracle Database versions

Differences between Physical & Logical Structures

Oracle 11gR2 Database Installation

Software & Hardware Requirements

Linux Commands

Installing Oracle 11gr2 RDBMS

Database Creation

Creating with Database Configurations Assistant (DBCA)

Metadata

Tables & Views

Metadata Views

Stages in Starting & Stopping the Database

Startup Options

Shutdown options

Database Files

Adding parameter to spfile

Deleting parameter from spfile

Multiplexing a control file

Multiplexing using pfile

Multiplexing using spfile

Managing Files & Tablespaces

Data File Management

Different status of a Data File

Types of Tablespaces

Different status of Table space

Modes of Tablesp

User Management

Schema Management

Quota Management

Privilege Management

Profile Management

Role Management

Networking

Introduction to Networking

Client side Configuration

Server Side Configuration

Oracle Listeners

Backups & Recoveries

Introduction to Backups

Types of Failures

Types of Backups

Physical Backups

Database Cloning

loning Concepts

Cloning Techniques

Cloning Oracle Home & Database

Patching & Upgrading of Database

atch using Opatch utility

Understanding the upgrade process

Upgrading Oracle11g to Oracle 12Z

Database Performance Tuning

Oracle Tools for Performance Tuning

Instance & Database Tuning

Execution Plans, using EXPLAIN PLAN

TKPROF AWR, ADDM

All Sessions are Completely Practical and Real time. One Real-time Project for every course.