Oracle DBA,RAC,Apps DBA Training at Pune

Oracle DBA is certification oriented course which covers FIVE major parts as:

1. UNIX

2. PL/ SQL

3. DBA Admin Part1 on 11g

4. DBA Admin Part2 on 11g

5. Real Application Cluster (RAC)

Syllabus:

*** UNIX

Fundamentals

Architecture

Commands

File System

The vi Editor

The SHELL & Shell Scripting

***PL/ SQL

Creating and altering tables and views

Writing and running PL/ SQL programs from SQL*Plus or SQL Developer

Using SQL statements within PL/ SQL

Conditional execution and loop constructs

Triggers, Cursors

Trapping and handling errors and exceptions in code

Implementing nested and labeled loops and blocks

Exceptions

Handling PL/ SQL records and tables

***DBA Admin1 on 11g R2

Installing and Configuring Oracle 11g R2

Creating and Managing Database Storage Structures

Managing Users, Profiles, Privileges and Roles

Maintaining Database Security

Monitoring the Performance of the Database

Backing Up and Recovering the Database

*** DBA Admin2 on 11g R2

Planning a backup strategy and a disaster recovery strategy

Altering a database to ARCHIVELOG and NOARCHIVELOG modes

Performing online and offline backups

Recovering a database from non-critical losses

Performing logical backups with the export and import utilities

Reviewing database logs for diagnostic purposes

Automating management tasks with the scheduler

***Real Application Cluster (RAC)

Installing and configuring an Oracle 11g R2 RAC Database

Administering and Monitoring a RAC database using Enterprise Manager and command line tools

Using configuration and management tools for RAC databases

Administering ASM using command line and GUI clients

Setting up services for workload management and application high availability

Backing up, restoring and recovering a RAC database

Creating duplicate and standby databases in a RAC Environment

Monitoring and tuning the performance of a RAC database

Faculty:

We are having world class faculty having 8+ years of experience in the DBA field.

Two certifications are:

Paper I: OCA: Oracle Certified Associates

Paper II: OCP: Oracle Certified Professional

Duration of this course would be approx 5. 5-6 months.

Oracle Application DBA Training:-

1. Oracle E-Business Suite Overview

2. AD Administration: Compile/Reload Database Entities Tasks

3. Preparing For Your Installation

4. AD Administration: Non-Interactive Operation and Maintenance Mode

5. Performing an Installation

6. Special Utilities

7. Finishing Your Installation

8. AutoConfig

9. Oracle E-Business Suite Components

10. License Manager

11. Environment Files, Control Scripts, and Languages

12. Reporting Utilities

13. Oracle E-Business Suite File System

14. Configuration Utilities

15. Oracle E-Business Suite Database

16. Patching and the Auto Patch Process

17. Advanced Configuration Options

18. Cloning Oracle E-Business Suite

19. Using the AD Utilities

20. Function Security

21. AD Administration: Generate Applications Files Tasks

22. Data Security

23. AD Administration: Maintain Applications Files Tasks

24. Oracle User Management

25. AD Administration: Maintain Database Entities Tasks

26. Profile Options