Focusing on the fundamentals of the Oracle database structure and architecture, Oracle Database 11g Administration Workshop II training imparts knowledge on managing the space so that database storage can be optimized to respond to growing space requirements. The Oracle Database 11g: Administration Workshop II certification facilitates in-depth understanding of the responsibilities that a DBA has to perform: performing backup and recovery and a lot more which helps them to add perfection in their work.
After completing the Oracle Database 11g Administration Workshop II certification, the candidates would be able to:
- Diagnose and repair data failures with Flashback technology.
- Make the use of compression to optimize database storage and duplicate a database.
- Understand and describe what is Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)?
- Implement the intelligence of configuring the database instance, such a way that resources are appropriately allocated among sessions and tasks.
- Manage major database components, including memory, performance and resources.
- Make an effective use of flashback technology to view past states of data and to revert either objects or the entire database back to a past state.
- Describe as well as test your own backup and recovery scenarios.
- Manage memory effectively, perform the performance evaluation and tuning tasks.
- Make an effective use of the compression to optimize database storage and duplicate a database
Target audience
- Support Engineer
- Technical Consultant
- Database Administrators
- Technical Administrator
Prerequisites
The candidates should have knowledge of Oracle Database 11g Database Administration and working knowledge of SQL and how to use PL/SQL packages