Price: Check with seller

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



  1.   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


 

More Details

Total Views:17
Reference Id:#323977
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com