Oracle DBA Practical and Real Time Online Training @ SequelGate

[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.

 

Contact us Today for Oracle DBA Online Trainings @

Sequelgate

 

For free Oracle DBA Online Demo, Please visit:

http://www.sequelgate.com

 

SequelGate Training Institute

E Mail: [email protected]   

 

Schedules for Oracle DBA Online- TRAINING:

http://sequelgate.com/contact-us.html

 

India:

SR Nagar Branch:

Office: +91 (0) 40 64577244 

Mobile: +91 (0) 9666440801

Address-1: 108/2RT, Road No 1, SR Nagar, Land Mark: Beside Bus Stop, Hyderabad, India.

 

Madhapur Branch:

 

Mobile: +91 (0) 9030040801

Office: +91 (0) 4065358866

USA:

Office: +1 (510) 400-4845

 

Address-2: Sai Anu Avenue, Street Number 3, Patrika Nagar,  HITEC City, Hyderabad - 81 (India). 

http://www.sequelgate.com