I would definately recommend Bruce Gordon for any of the .net training courses. More Testimonials »

Oracle9i Database Fundamentals II 1Z0-032 eLearning Course

Oracle9i Database Fundamentals II 1Z0-032 eLearning Course Series (24 hours)

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.

Self-Paced eLearning Course Benefits

Only $42.95

12-month subscription!

Register Now

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $42.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. Oracle9i Database Fundamentals II 1Z0-032:1 Networking Overview (Time: 1 hours)

This eLearning course provides an overview of network configurations and the solutions provided by Oracle to manage networks.

Course Objectives

  • Describe networking challenges in the business environment
  • Describe typical network configurations in the business environment
  • Identify and describe Oracle's solutions to networking issues

2. Oracle9i Database Fundamentals II 1Z0-032:2 Basic Oracle Net Architecture (Time: 1 hours)

This eLearning course provides an overview of the Oracle Net technology and its architecture and structure atop basic industry standard protocols.

Course Objectives

  • Describe the Open System Interconnection (OSI) architecture
  • Describe Oracle Net services
  • Describe Oracle Net layered architecture
  • Describe Web client services

3. Oracle9i Database Fundamentals II 1Z0-032:3 Basic Oracle Net Server-Side Configuration (Time: 1 hours)

This eLearning course provides an introduction to the purpose and functionality of the listener in the Oracle Net environment, and how to configure and control the listener.

Course Objectives

  • 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

4. Oracle9i Database Fundamentals II 1Z0-032:4 Basic Oracle Net Services Client-Side Configuration (Time: 1 hours)

This eLearning course provides an introduction to Oracle Net's different naming methods and their respective advantages and disadvantages.

Course Objectives

  • Describe Oracle Net naming methods
  • Configure host naming and local naming methods
  • Configure net service names
  • Perform simple net troubleshooting

5. Oracle9i Database Fundamentals II 1Z0-032:5 Usage and Configuration of the Oracle Shared Server (Time: 1 hours)

This eLearning course describes how Oracle's shared server architecture allows a small number of shared servers to perform the same amount of processing as several dedicated servers.

Course Objectives

  • 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

6. Oracle9i Database Fundamentals II 1Z0-032:6 Backup and Recovery Overview (Time: 1 hours)

This eLearning course provides a foundation of Oracle backup and recovery fundamentals. It also covers how to classify and design backup and recovery strategies, create and implement disaster recovery plans, and describe and utilize Oracle's high availability features.

Course Objectives

  • 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

7. Oracle9i Database Fundamentals II 1Z0-032:7 Instance and Media Recovery Structures (Time: 1 hours)

This eLearning course provides information on Oracle's memory structures, background processes and datafiles. It also highlights the importance of checkpoints during instance recovery and the use of fast-start checkpoints and parallel recovery in tuning the recovery process.

Course Objectives

  • Describe Oracle memory structures
  • Define Oracle background processes
  • Define Oracle database files
  • Describe the importance of checkpoints during instance recovery

8. Oracle9i Database Fundamentals II 1Z0-032:8 Configuring the Database Archiving Mode (Time: 1 hours)

This eLearning course covers how to configure a database in ARCHIVELOG mode, perform manual or automatic archiving, and multiplex archived redo logs. It also covers the modes in which a database can operate and the ramifications of operating the database in a given mode.

Course Objectives

  • 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

9. Oracle9i Database Fundamentals II 1Z0-032:9 Oracle Recovery Manager Overview and Configuration (Time: 1 hours)

This eLearning course describes how to use Oracle's Recovery Manager (RMAN) utility to perform backup and recovery.

Course Objectives

  • 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

10. Oracle9i Database Fundamentals II 1Z0-032:10 User-Managed Backups (Time: 1 hours)

This course describes how to perform user-managed backup and recovery. It also covers how to perform closed and open database backups, manage backup and recovery of control files and archived log files, recover from backup failures, and use the DBVERIFY utility.

Course Objectives

  • 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

11. Oracle9i Database Fundamentals II 1Z0-032:11 RMAN Backups (Time: 1 hours)

This eLearning course describes RMAN's image copy and backup set structures. It also covers how to perform backups of Oracle databases, control files and archived redo log files using RMAN.

Course Objectives

  • 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

12. Oracle9i Database Fundamentals II 1Z0-032:12 User-Managed Complete Recovery (Time: 1 hours)

This eLearning course provides a foundation for recovering from a crash without losing any information through the explicit use of the RESTORE and RECOVER commands.

Course Objectives

  • 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

13. Oracle9i Database Fundamentals II 1Z0-032:13 RMAN Complete Recovery (Time: 1 hours)

This eLearning course describes the fundamentals of using Oracle's Recovery Manager to perform complete recovery without loss of data.

Course Objectives

  • 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

14. Oracle9i Database Fundamentals II 1Z0-032:14 User-Managed Incomplete Recovery (Time: 1 hours)

This eLearning course describes how to recover without necessarily applying all available redo รข€” a process called incomplete recovery. It also covers how and when to perform incomplete recovery, the implications of incomplete recovery, and techniques for improving the performance of incomplete recovery.

Course Objectives

  • 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

15. Oracle9i Database Fundamentals II 1Z0-032:15 RMAN Incomplete Recovery (Time: 1 hours)

This eLearning course introduces the fundamentals of incomplete recovery using Oracle's Recovery Manager (RMAN) utility. It also covers how and when to perform incomplete recovery, and the consequences of performing incomplete recovery.

Course Objectives

  • 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

16. Oracle9i Database Fundamentals II 1Z0-032:16 RMAN Maintenance (Time: 1 hours)

This eLearning course covers the use of the RMAN CROSSCHECK command. It also covers how to catalog backups made with operating system commands and maintaining the RMAN repository.

Course Objectives

  • 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

17. Oracle9i Database Fundamentals II 1Z0-032:17 Recovery Catalog Creation and Maintenance (Time: 1 hours)

This eLearning course explains the use and efficiency of the Recovery Manager. It also covers the use of a recovery catalog to store RMAN information and how to use it to extend and improve the behavior of RMAN.

Course Objectives

  • 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

18. Oracle9i Database Fundamentals II 1Z0-032:18 Transporting Data Between Databases (Time: 1 hours)

This eLearning course provides an overview on how to use Oracle's export and import utilities to perform logical copies of information in databases and transport information between databases.

Course Objectives

  • Describe export and import concepts and structures
  • Describe methods to invoke export and import
  • Define guidelines for using export and import

19. Oracle9i Database Fundamentals II 1Z0-032:19 Loading Data into a Database (Time: 1 hours)

This eLearning course provides information on how to use SQL*Loader to perform conventional and direct-path loads of data into the database. It also describes how to perform direct data loads from fat files and other formatted files into an Oracle database.

Course Objectives

  • 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

20. Oracle9i Database Fundamentals II 1Z0-032:20 Practice Exam 1 (Time: 1 hours)

This eLearning course presents questions that will help you prepare for the Oracle9i Database Fundamentals II 1Z0-032 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

21. Oracle9i Database Fundamentals II 1Z0-032:21 Practice Exam 2 (Time: 1 hours)

This eLearning course presents questions that will help you prepare for the Oracle9i Database Fundamentals II 1Z0-032 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

22. Oracle9i Database Fundamentals II 1Z0-032:22 Practice Exam 3 (Time: 1 hours)

This eLearning course presents questions that will help you prepare for the Oracle9i Database Fundamentals II 1Z0-032 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

23. Oracle9i Database Fundamentals II 1Z0-032:23 Practice Exam 4 (Time: 1 hours)

This eLearning course presents questions that will help you prepare for the Oracle9i Database Fundamentals II 1Z0-032 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

24. Oracle9i Database Fundamentals II 1Z0-032:24 Practice Exam 5 (Time: 1 hours)

This eLearning course presents questions that will help you prepare for the Oracle9i Database Fundamentals II 1Z0-032 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
Watch 3-minute Demo Video
of Live Online Training:
Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723