Course in Oracle Database Administration

The program includes the below enumerated subject areas:

1) Notions & Management

* Oracle fixations in Linux and Solaris
* Pattern kernel Standards
* Oracle Structural Design
* 10 G Mechanical Administration
* Program universal spot
* Beginning & power cut alternatives
* Creation of DB
* Management of control documents
* Management of log document
* Management of gaps within the tables
* Management of information documents
* Management of tables & directories
* Appeared Visions
* Divisions
* Locking system
* Information Reliability
* Gaps & Storeroom Standards
* Disengage
* Management of temporary files
* Temporary DB
* Consumers
* Tasks & privileges
* Outline
* Scheduler
* Database Management System jobs
* Practicum with Circumstances
* Evaluation

2) Support & Revitalization

* Export
* Import and information pumping
* Redundant Array of Independent Disks
* Storage Area Network
* Network-Attached Storage
* NFS Network File System Storage
* U.M.B.
* U.M.B. Re-creation
* Client Administered Revitalization
* P.I.T.T.R.
* Configuring Recovery Manager
* Recovery Manager Supports
* Recovery Manager Re-creation
* Combine Supports
* Recovery Manager P.I.T.T.R.
* Preserving Revitalization Directory
* Practicum with Circumstances
* Evaluation

3) Administrating Network

* Configuring Customer server
* T.N.S. names
* Lightweight Directory Access Protocol & identification server
* Listener manage usefulness
* Unix instruments: File Transfer Protocol, SSH File Transfer Protocol, S.C.P., Windows Secure CoPy
* Practicum with Circumstances
* Evaluation

4) Oracle Usefulness

* Exp/imp, Exp data pump, Imp data pump
* National Institute of Design
* C.S.S.C.A.N., C.S.A.L.T.E.R.
* Oerr
* Database verification
* Oraenv
* Ora password
* Space Physics Interactive Data Resource
* Tnsping
* Wrap
* Practicum with Circumstances
* Evaluation

5) Performance Regulation

* Reason behind Tuning
* Structured Query Language Tuning
* Implementation Tuning
* Tuning Types
* Sizing System Global Area & P.G.A.
* Examining Input & Output matters
* Handle Disputation
* Database Management System static’s
* Configuring Stats package & Automatic Workload Repository
* Stages of following
* Dynamic Meeting History
* Structured Query Language regulation consultant
* Structured Query Language admittance consultant
* 10046 & 10053 outline occurrences
* Usage of T.K.P.R.O.F.
* Understanding Automatic Workload Repository & Statistical pack
* Optimizer patterns & standards
* Networking regulation
* Operating system tuning
* Practicum with Circumstances
* Evaluation

6) Patching &Up gradation

* Oracle 9i To 10g - 11g Up gradation
* Applying Oracle patch
* Practicum with Circumstances
* Evaluation

7) Oracle Safety

* Database Vault
* F.G.A. Control
* Vital Product Data Regulations
* Practicum with Circumstances
* Evaluation

8) Data-guard

* Data-guard planning
* Guard arrangements
* Configuring physical reserve
* Configuration rational reserve
* Switch-over & fail-over