Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








Oracle9i Database Fundamentals II 1Z0-032
Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works

This online course includes: Time Needed
Networking Overview 1 hour
Basic Oracle Net Architecture 1 hour
Basic Oracle Net Server-Side Configuration 1 hour
Basic Oracle Net Services Client-Side Configuration 1 hour
Usage and Configuration of the Oracle Shared Server 1 hour
Backup and Recovery Overview 1 hour
Instance and Media Recovery Structures 1 hour
Configuring the Database Archiving Mode 1 hour
Oracle Recovery Manager Overview and Configuration 1 hour
User-Managed Backups 1 hour
RMAN Backups 1 hour
User-Managed Complete Recovery 1 hour
RMAN Complete Recovery 1 hour
User-Managed Incomplete Recovery 1 hour
RMAN Incomplete Recovery 1 hour
RMAN Maintenance 1 hour
Recovery Catalog Creation and Maintenance 1 hour
Transporting Data Between Databases 1 hour
Loading Data into a Database 1 hour
Practice Exam 1 1 hour
Practice Exam 2 1 hour
Practice Exam 3 1 hour
Practice Exam 4 1 hour
Practice Exam 5 1 hour
Estimated time needed to complete entire course 24 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Technical Pack, and receive this course plus many more, for only $197



Benefits

  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. 
Prices shown are per user.




What You will Learn

This study guide will prepare you to take one of the two required Oracle9i tests to be certified as an Oracle Certified Professional, Oracle9i Database Administrator. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

Certification:

The test that this series prepares students to take is a part of earning the Oracle9i Database Administrator Certified Professional certification.




Topic Details

  • Describe networking challenges in the business environment
  • Describe typical network configurations in the business environment
  • Identify and describe Oracle's solutions to networking issues
  • Describe the Open System Interconnection (OSI) architecture
  • Describe Oracle Net services
  • Describe Oracle Net layered architecture
  • Describe Web client services
  • Describe the components of the listener
  • Describe how to configure and control the listener
  • Describe dynamic service registration
  • Describe how to configure the listener for IIOP
  • Describe Oracle Net naming methods
  • Configure host naming and local naming methods
  • Configure net service names
  • Perform simple net troubleshooting
  • Identify components of the Oracle Shared Server
  • Define Oracle Shared Server architecture
  • Define how to configure Oracle Shared Server
  • Define how to query related dictionary views
  • Define the basics of Oracle database backup, restoration and recovery
  • Describe Oracle backup and recovery strategies
  • Create and implement disaster recovery plans
  • Implement Oracle's high availability features
  • Describe Oracle memory structures
  • Define Oracle background processes
  • Define Oracle database files
  • Describe the importance of checkpoints during instance recovery
  • Describe the differences between ARCHIVELOG and NOARCHIVELOG mode
  • Configure a database for ARCHIVELOG mode
  • Configure multiple ARCHIVELOG processes
  • Configure multiple destinations, including remote destinations
  • Query useful dynamic views
  • Describe the RMAN repository
  • Describe RMAN channel allocation
  • Describe the Media Management Library interface
  • Connect to RMAN without a recovery catalog
  • Configure the RMAN environment
  • Demonstrate how to perform user-managed closed and open database backups
  • Describe how to perform user-managed backups of read-only tablespaces, control files and archived redo logs
  • Show how to clean up after failed online backups
  • Describe the implications of LOGGING and NOLOGGING operations
  • Explain how to use the DBVERIFY utility
  • Describe how to perform server-managed backup and recovery
  • Demonstrate how to create and use RMAN image copies and backup sets
  • Explain how to create and use tags in backup sets and image copies
  • Describe how to back up control files and archived redo log files using RMAN
  • Explain how to query and interpret RMAN-related dynamic performance views
  • Demonstrate how to perform user-managed complete recovery
  • Describe how to perform user-managed complete recovery in NOARCHIVELOG mode
  • Describe how to perform user-managed complete recovery in ARCHIVELOG mode
  • Explain how to restore data files to different locations
  • Describe how to relocate and restore a tablespace using archived redo log files
  • Describe how to recover from the loss of an online inactive redo log group
  • Demonstrate how to perform complete recovery using the Recovery Manager
  • Explain how to perform complete recovery in NOARCHIVELOG mode
  • Describe how to perform complete recovery in ARCHIVELOG mode
  • Explain how to restore data files to different locations using the Recovery Manager
  • Describe how to relocate and recover a tablespace using archived redo log files
  • Describe how to perform block media recovery
  • Demonstrate how to perform incomplete recovery
  • Explain how to recover from a crash without applying all available redo using RESTORE and RECOVER commands
  • Describe how to identify and recover from the loss of an online redo log file
  • Explain how to perform media recovery in parallel
  • Describe dynamic performance views
  • Demonstrate how to perform incomplete recovery using the Recovery Manager
  • Describe how to perform incomplete database recovery using UNTIL TIME
  • Explain how to perform incomplete database recovery using UNTIL SEQUENCE
  • Describe how the Recovery Manager performs restore optimization
  • Demonstrate how to use the RMAN CROSSCHECK command to maintain the RMAN repository
  • Explain how to perform crosscheck of backup sets and image copies
  • Describe how to update the repository when backups have been deleted
  • Explain how to change the availability status of backup sets and image copies
  • Demonstrate how to exempt a backup set or an image copy from the retention policy
  • Describe how to catalogue backups made with operating system commands
  • Explain the benefits of creating and using a recovery catalog database
  • Describe how to create and use a recovery catalog
  • Demonstrate how to use the Recovery Manager to register, resynchronize and reset a database
  • Describe how to query the recovery catalog to generate reports and lists
  • Demonstrate how to create, store and run scripts
  • Explain how to back up and recover the recovery catalog
  • Describe export and import concepts and structures
  • Describe methods to invoke export and import
  • Define guidelines for using export and import
  • Describe SQL*Loader usage and how to perform basic SQL*Loader operations
  • Describe different loading methods in SQL*Loader
  • Describe the format of SQL*Loader files
  • Explain the guidelines for using SQL*Loader and direct load insert
  • Demonstrate how to perform direct path insert operations
  • Complete the practice exam questions
 

 







 

 

Copyright © 2008 TrainingCenter.com