Best Oracle 10g 11g Database Administrator Training Institute
OVERVIEW
The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts.
We at SKY INFOTECH provide quality training in ORACLE DBA 10g and 11g on RHEL/Windows platforms respectively.
ORACLE 10g /11g Training Course modules
Following modules are included in ORACLE 10g/11g training programme
SQLPLUS
Patching Overview of dataguard
All the advanced concepts of 11g
The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts.
We at SKY INFOTECH provide quality training in ORACLE DBA 10g and 11g on RHEL/Windows platforms respectively.
ORACLE 10g /11g Training Course modules
Following modules are included in ORACLE 10g/11g training programme
SQLPLUS
- Retrieving data using SELECT statement
- Restricting & sorting data
- Single row functions
- Group functions
- Joins
- DDL & DML statements
- Data dictionary
- Controlling user access
- Managing schema objects
- Advanced subqueries
- Introduction
- Install Oracle Database 10g and configure a database
- Manage the oracle instance
- Create manage and administer user accounts
- Manage privileges, roles and profiles
- Monitor, administer and configure oracle net services
- Perform backup & recovery of database
- Using export/ import utilities
- Introduction
- Use RMAN to create and manage backup sets and image copies
- Use Oracle Secure Backup to backup and recover a database
- Use Oracle’s Flashback technology to recover your database
- Detect block corruptions and take appropriate measures to correct them
- Use the various Database advisors and views to monitor and improve database performance
- Control database resource usage with the Resource Manager
- Simplify management tasks by using the Scheduler
- Review database log files for diagnostic purposes
- Customize language-dependent behavior for the database and individual sessions
- Database cloning
Patching Overview of dataguard
All the advanced concepts of 11g