Oracle DBA Practical Online Training @ SequelGate Lenexa, Kansas, United States
Posted on June 8, / 106


Listing Type : Others

Oracle DBA Practical Online Training @ SequelGate – SequelGate Tech (SequelGate Technologies Pvt. Ltd.) is one of the Training Organizations providing specialized in Oracle DBA including Oracle DBA and Oracle Apps DBA 

All our sessions are completely Practical and Real-time. 

ORACLE DBA WITH PROJECT – ONLINE 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. 

adkumari
Related Listings