◊ ORACLE 10G DATABASE ADMINISTRATION II 1Z0-043 ONLINE TRAINING SERIES
Online Oracle 10g Database Administration II 1Z0-043 Training
Database » Oracle
Check out these great money-saving course packages:
Only $99.95
Oracle 10g Database Administration II 1Z0-043 Series (19 hours)
ONLINE TRAINING FEATURES
- Learn online with these interactive online courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the courses
- Retake the courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. Using Globalization Support Objectives
Time: 1 hours
This course discusses the purpose and importance of Globalization Support, which allows Oracle users to interact with applications in their native languages using the conventions of those languages for displaying data. This course also covers the date and time functionalities offered by Oracle to specify local time.
Objectives
- Customize language-dependent behavior for the Database and individual sessions
- Specify different linguistic sorts for queries
- Use Datetime Datatypes
- Query data using case insensitive and accent insensitive searches
- Obtain Globalization support configuration information
Topics
- Using Globalization Support Objectives
2. Configuring Recovery Manager
Time: 1 hours
This course discusses the four main components of the Recovery Manager (RMAN) and its uses for interacting with databases and maintaining information.
Objectives
- Configure database parameters that affect RMAN operations
- Change RMAN default settings with CONFIGURE
- Manage RMAN's persistent settings
- Start the RMAN utility and allocate channels
Topics
- Configuring Recovery Manager
3. Recovering from User Errors
Time: 1 hours
This course discusses using the Flashback Database feature to recover a table dropped by a user. This course also covers the Recycle Bin and how it can be used to recover dropped tables, nested tables, constraints, indexes, and other objects.
Objectives
- Recover a dropped table using Flashback technology
- Perform a Flashback table operation
- Manage the Recycle Bin
- Recover from user errors using Flashback Versions Query
- Perform transaction level recovery using Flashback Transaction Query
Topics
- Recovering from User Errors
4. Dealing with Database Corruption
Time: 1 hours
This course provides information and instruction on database corruption, how it occurs, and how to handle it.
Objectives
- Define block corruption
- List the causes and symptoms of block corruption
- Detect database corruptions using ANALYZE
- Use DBVERIFY
- Detect database corruptions using DBMS_REPAIR
- Implement the DB_BLOCK_CHECKING parameter to detect corruptions
- Repair corruptions using RMAN
Topics
- Dealing with Database Corruption
5. Automatic Database Management
Time: 1 hours
This course discusses the tools that help automate several routine administrative tasks, such as SQL tuning, space management, memory management, and overall performance diagnostics.
Objectives
- Describe the different database advisors and their purpose
- Use the SQL Tuning Advisor to improve database performance
- Describe how Oracle performs automatic undo retention
Topics
- Automatic Database Management
6. Using Recovery Manager
Time: 1 hours
This course discusses the Oracle database backup and recovery utility, Recovery Manager (RMAN).
Objectives
- Use RMAN to create backup sets and image copies using the RMAN BACKUP command
- Describe the use of and how to enable block change tracking within RMAN
- Manage the backups and image copies taken with RMAN using the LIST and REPORT commands
7. Recovering from Non-Critical Losses
Time: 1 hours
This course discusses not only how to recover from non-critical losses, but also how good architecture and backup policies can assure that certain media losses remain non-critical.
Objectives
- Recover temporary tablespaces
- Recover Redo Log Members
- Recover index tablespaces
- Recover read-only tablespaces
- Recreate a password file to the database
Topics
- Recovering from Non-Critical Losses
8. Monitoring and Managing Storage
Time: 1 hours
This course discusses the tools used to monitor and manage storage in an Oracle 10g Database, such as the Segment Advisor, the Undo Advisor, and the Redo Logfile Size Advisor. This course also covers index-organized tables, clustered tables, sorted hash clusters, and Resumable Space Allocation.
Objectives
- Describe the use of Redo and Archive logs
- Suspend transactions that hit space problems
- Size the tables appropriately using the Segment Advisor
- Rebuild indexes online
Topics
- Monitoring and Managing Storage
9. Automatic Storage Management
Time: 1 hours
This course discusses the use of Automatic Storage Management (ASM), and the different tools used to administer ASM.
Objectives
- Describe how to use Oracle Automatic Storage Management
- Set up the initialization parameter file for ASM
- Execute SQL commands with ASM file names
- Start up and shut down ASM instances
- Administer ASM disk groups and use RMAN to migrate to ASM
Topics
- Automatic Storage Management
10. Monitoring and Managing Memory
Time: 1 hours
This course discusses the System Global Area (SGA) and its uses for shared memory management, as well as the Program Global Area (PGA) and its uses for private memory storage.
Objectives
- Define the System Global Area (SGA) and list its components
- Describe Automatic Shared Memory Management (ASMM)
- Define the Program Global Area (PGA)
Topics
- Monitoring and Managing Memory
11. Database Recovery
Time: 1 hours
This course provides information and instruction on how to perform various types of database recovery.
Objectives
- Recover a Control file
- Describe reasons for incomplete recovery
- Perform incomplete recovery using EM, RMAN, and SQL
- Perform database recovery following a RESETLOGS operation
12. Flashback Database
Time: 1 hours
This course discusses the Flashback Database and related technologies that are used in database recovery situations.
Objectives
- Determine which Flashback technology to use for each recovery situation
- Configure, use, and monitor Flashback Database
- Use the Enterprise Manager Recovery Wizard to Flashback Database
- Manage and maintain the Flash Recovery Area
13. Managing Resources
Time: 1 hours
This course provides information and instruction on resource management using the Resource Manager feature of Oracle 10g.
Objectives
- Manage resources using Resource Manager
- Assign users to Resource Manager groups
- Create resource plans within groups
- Specify directives for allocating resources to consumer groups
14. Automating Tasks with the Scheduler
Time: 1 hours
This course provides information and instruction on how to perform the automation of tasks with the Scheduler.
Objectives
- Simplify management tasks by using the Scheduler
- Create a job, program, schedule, and window
- Re-use the Scheduler components for similar tasks
- View information about job executions and job instances
Topics
- Automating Tasks with the Scheduler
15. Practice Exam 1
Time: 1 hours
This course presents questions that will help you prepare for the Oracle 10g Database Administration II 1Z0-043 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
16. Practice Exam 2
Time: 1 hours
This course presents questions that will help you prepare for the Oracle 10g Database Administration II 1Z0-043 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
17. Practice Exam 3
Time: 1 hours
This course presents questions that will help you prepare for the Oracle 10g Database Administration II 1Z0-043 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
18. Practice Exam 4
Time: 1 hours
This course presents questions that will help you prepare for the Oracle 10g Database Administration II 1Z0-043 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
19. Practice Exam 5
Time: 1 hours
This course presents questions that will help you prepare for the Oracle 10g Database Administration II 1Z0-043 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
Resources for Oracle 10g Database Administration II 1Z0-043
- Know of a good resource for Oracle 10g Database Administration II 1Z0-043 Online Training? Please Let Us Know.
