Oracle DBA, Real Application Cluster, Application DBA Training @ SysadminExperts - Mumbai

Monday, 9 February 2015

Item details

City: Mumbai, Maharashtra
Offer type: Offer

Contacts

Contact name Jaya Shelke
Phone 8983090907

Item description

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