Oracle Database 10g: Administration Workshop II Self-Study Course

Oracle University Self-Study CD Courses are a great accompaniment and reliable alternative to our inClass courses, and provide an excellent ongoing resource for reviewing key concepts and practicing skills.

This self-study CD ROM (SSCD) course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology, use RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery. In addition, this course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Finaly, earners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views.

Learn To:

• Match goals of Oracle Database 10g manageability features with the methods of achieving them.
• Identify features of the Oracle Database 10g manageability strategy.
• Identify globalization support features provided by Oracle Database 10g.
• Identify features of different encoding schemes supported by Oracle Database 10g.
• Distinguish between features of the database and national character sets used in Oracle Database 10g.
• Identify listener security features in Oracle Database 10g.
• Sequence the steps to set the listener password by using Enterprise Manager (EM).
• Identify steps to set the listener password by using Net Manager.
• Identify features of the RMAN.
• Match various RMAN components with their features.
• Identify features of RMAN media management.
• Match various RMAN commands with their features.
• Distinguish between the methods for issuing RMAN commands.
• Identify features of the BACKUP command.
• Identify features of the alert.log file.
• Identify features of alerts.
• Identify options that enable you to configure alerts.
• Identify features of incomplete recovery.
• Match incomplete recovery types with their features.
• Identify guidelines for performing incomplete recovery.
• Identify features of Flashback Database.
• Sequence the steps for configuring Flashback Database using SQL.
• Identify features of block corruption.
• Identify features of the DBVERIFY utility.
• Identify features of the ANALYZE command.
• Identify features of the advisory framework.
• Sequence the steps in an advisor tuning session.