ORACLE DBA

5.0

About Course

QA Training Hub’s online training program in Oracle DBA equips the students with installation, configuring, upgrading, administering, monitoring, maintaining, and securing Oracle databases in any organization. Our Oracle DBA online training program is comprehensive and complete. We focus on turning each student into a successful administrator with hands-on expertise in database configuration, administration, programming, performance tuning, backup and recovery and high availability.

Course Content

INTRODUCTION TO ORACLE DBA

What is DBA ?
Why a Company needs a DBA?
Roles & Responsibilities of DBA

Oracle Architecture

DATABASE CREATION

TABLESPACE MANAGEMENT

STORAGE PARAMETERS

USER MANAGEMENT

Who are Database Users?
Why to create a User?
Creation of Users
Assigning Privileges
Creating and granting Roles
Allocating table space Quotas to Users
Assigning default table space for the Users
Setting Profiles for the Users
Levels of Authentication
Schema Management(11g)
Security(11g)

UNDO MANAGEMENT

SPFILE & OMF

NETWORKING IN ORACLE

Introduction to Database Links

REDO-LOG & CONTROLFILE MANAGEMENT

LOGICAL BACKUP

PHYSICAL BACKUP

PEFORMANCE TUNING

What is Performance Tuning?
Why Tuning required?
Types of Tuning
Database Tuning
Tuning
SQL Tuning
Memory Tuning
Network Tuning
Partitioning and Indexes
Partitioning Enhancements
AWR/ASH/ASMM/ADDM
RAT(Real Application Testing)(11g)
SQL Performance Analyses (11g)
Row chaining and Row migration
Resemble Table spaces

AVAILABILITY

Introduction to Data Guard
Types of Standby databases
11g New features in Data Guard
Types of Protection modes
Active standby/snapshot standby(11g)
Log Miner
RMAN Point in time Recovery
Introduction to Database Cloning
RMAN Cloning
Automatic Storage Management(ASM)

+91 8977262627

ORACLE DBA

About Course

Course Content

INTRODUCTION TO ORACLE DBA

What is DBA ?

Why a Company needs a DBA?

Roles & Responsibilities of DBA

Oracle Architecture

Physical and Logical Phase of Database

Types of files(Control file, Redolog file and Datafile)

Different types of Datafiles

Instance

SGA(System Global Area) and Background Process

DATABASE CREATION

Different Startup Modes

Different Shutdown Modes

Types of Database Creation

Manual Method of Creation

TABLESPACE MANAGEMENT

Introduction to Table space

Types of Table space(BIG & SMALL)

Temporary Table space

Altering/Renaming a Table space

Renaming a data file

Temporary Groups

Table space Encryption(11g)

STORAGE PARAMETERS

What are segments?

What are extents?

What is Blocks?

Oracle Blocks

Estimation of Extents

Dictionary Managed Table space

Locally Managed Table space

Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

Who are Database Users?

Why to create a User?

Creation of Users

Assigning Privileges

Creating and granting Roles

Allocating table space Quotas to Users

Assigning default table space for the Users

Setting Profiles for the Users

Levels of Authentication

Schema Management(11g)

Security(11g)

UNDO MANAGEMENT

What is Undo?

Why Undo required?

Pending offline status

Brief idea about Rollback segments

Flashback Features

Flashback Table

Flashback query

Flashback Version query

SPFILE & OMF

What is spfile?

Difference between spfile and pfile

Advantages of spfile

What is OMF?

Advantages of OMF

Files conventions of OMF

NETWORKING IN ORACLE

Introduction to Oracle Networking

Network default location

Editing Network file

Introduction to Database Links

Types of Database Links

Introduction to Materialized views

Advantages of Materialized view

Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

Introduction to Redo log

Status of Redo logs

Multiplexing the Redo log files

Re-creation of Control file

Renaming the Database

Multiplexing the Control file