Oracle DBA Training At SysAdminExperts - Pune

SysAdminExperts
In Pune

Rs 40,000
You can also call the Study Centre
98819... More
Want to speak to an Advisor about this course?

Important information

Typology Certificate
Start Pune
Duration 6 Months
  • Certificate
  • Pune
  • Duration:
    6 Months
Description


Suitable for: Any student who has completed his/her graduation can apply for this course.

Important information
Venues

Where and when

Starts Location
On request
Pune
Office No. 2 ,First Floor,Punit-Yash Arcade,Karve Road,Near Kothrud Stand,Kothrud-411038, 411038, Maharashtra, India
See map
Starts On request
Location
Pune
Office No. 2 ,First Floor,Punit-Yash Arcade,Karve Road,Near Kothrud Stand,Kothrud-411038, 411038, Maharashtra, India
See map

What you'll learn on the course

SQL
Unix

Course programme

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

Achievements for this centre


Students that were interested in this course also looked at...
See all