Oracle DBA Training At SysAdminExperts - Pune

This institution provides a helpful course in oracle which specifically covers database training.

Syllabus Content:

1) UNIX

* Basics
* Architecture
* Instructions
* File System
* vi Editor
* SHELL & Shell Script

2) Structured Query Language

* Creation & alteration of tables & view
* How to Write & Run Procedural Language / Structured Query Language programs from Structured Query Language* Plus or Structured Query Language Developer
* Usage of Structured Query Language statements within Procedural Language / Structured Query Language
* Restricted implementation & loop construction
* Triggers, Cursors
* Catching & treating errors & exceptions in code
* Executing nested & label loops & blocks
* Exclusives
* Treating Procedural Language / Structured Query Language records & tables


3) D.B.A. Part One

* Installation & Configuration of Oracle
* Creation & Management of D.B. Storage designs
* Management of Users, Profiles, Privileges & Tasks
* Maintenance of DB Security
* Checking the Functioning of DB
* Back Up & Recovery of the DB

4) DBA Part Two

* Structuring a backup policy & a disaster recovery policy
* Alteration of a DB to ARCHIVELOG & NOARCHIVELOG forms
* Performance of online & offline backup
* Recovery of a DB from non critical loss
* Performance of logical backups by means of export & import utility
* Evaluating DB logs for diagnostic purpose
* Automatic supervision tasks with the scheduler

5) Real Application Cluster

* Installation and configuration of an Oracle 10g Real application cluster DB
* Administration & Checking of a Real application cluster DB by means of Enterprise Manager & command line tools
* Usage of configuration & supervision tools for Real application cluster DBs
* Administration of A.S.M. by command line & Graphical user interface clients
* Setting up services for workload management and application high availability
* Backing up, restoring and retrieving a Real application cluster DB
* Creation of duplicate & standby DBs in a Real application cluster Environment
* Checking & tuning the functioning of a Real application cluster DB