Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Oracle8i Database Administration: Create a Database

Click here for more information or to take this course 		Serebra Learning Corporation
  home  : Computer  : Oracle  : Oracle8i
Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts associated with storage structure components managing rollback segments temporary segments and indexes. In addition creating and maintaining databases will be covered.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:8 hours
Training Presented in:English
Related Keywords:  oracle8i database administration 

Training Program Details

Audience

Database Administrators System Administrators Network Administrators Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110) Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111) Oracle SQL and SQL*Plus: DML and DDL (61112) Oracle PL/SQL: Basics (60113) Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023.

Objective

  • Identify and create a database.
  • Identify the data dictionary views.
  • Identify the data dictionary views to retrieve information.
  • Identify the scripts to set up the PL/SQL environment.
  • Identify control files
  • Identify redo log files
  • Identify tablespaces and data files.

Topics Include

Unit 1: Creating a Database: Procedure

  • Identify the guidelines for creating an OFA structure.
  • Match the ORACLE_HOME subdirectories with their contents.
  • Identify the factors to be considered when creating a database.
  • Identify the requirements for creating a database.
  • Identify the guidelines to be followed for planning a physical database design.
  • Identify the steps involved in manually creating a database.
  • Identify the registry entries that have to be specified for proper database functionality.
  • Create a specified password file for a given instance by using the ORADIM80 utility.
  • Create a specified parameter file by editing specific settings in the default init.ora file.
  • Start a specified instance in the NOMOUNT mode by using Oracle SQL*Plus Worksheet.
  • Identify the functionality of the CREATE DATABASE command options.
  • Create a database with specified parameter values by using the CREATE DATABASE command.
  • Identify the commonly encountered situations in which the CREATE DATABASE command fails.
  • Identify the contents of a database after its creation.

Unit 2: Data Dictionary Views and Standard Packages

  • Identify the types of information stored in the data dictionary.
  • Identify the features of the data dictionary components.
  • Create a data dictionary view for a specific database by executing the appropriate script.
  • Identify the contents of the data dictionary view categories.
  • Retrieve specific information by querying the Dictionary view.
  • Create PL/SQL functionality for a specific database by executing the appropriate script.
  • Match the administrative script categories with the views and package components they create.
  • Identify the properties of stored procedures.
  • Identify the properties of packages.
  • Identify the benefits of stored program units.
  • Match the Oracle-supplied packages with their functions.
  • Retrieve information about invalid objects in a specified database by querying the required data dictionary view.
  • Retrieve information about a stored program unit specification by using the Oracle SQL*Plus Worksheet.
  • Identify the common situations when dependent objects may have an invalid status.

Unit 3: Maintaining Redo Log Files and Control Files

  • Identify the functions of a control file.
  • Identify the types of information stored in a control file.
  • Identify the dynamic performance views and the information they contain about the control files.
  • Multiplex a control file.
  • Identify the uses of redo log groups.
  • Identify the features of redo log members in a group.
  • Match the parameters that limit the number of online redo log files with what they determine.
  • Identify the situations in which a log switch occurs.
  • Force a log switch by using Oracle Backup Manager.
  • Identify the activities that are performed during a checkpoint.
  • Force a checkpoint by using Oracle Backup Manager.
  • Identify the functions of the initialization parameters that can be set to control database checkpoints.
  • Identify the features of archive modes.
  • Identify the command and dynamic performance views with the information they contain about the log and archive status of a database.
  • Identify the dynamic performance views and the information they contain about online redo log groups and members.
  • Add a redo log group by using Oracle Backup Manager.
  • Add a online redo log member to a redo log group by using Oracle Backup Manager.
  • Relocate the online redo log file by using Oracle SQL*Plus Worksheet.
  • Drop an online redo log group by using Oracle Backup Manager.
  • Drop a online redo log member by using Oracle Backup Manager.
  • Reinitialize an online redo log file by using Oracle SQL*Plus Worksheet.
  • Identify the factors to be considered while planning for the number of online redo log files.
  • Identify the reasons for storing the online redo log files on different disks.
  • Identify the factors that influence the sizing of the online redo log files.
  • Identify the Log Writer (LGWR) errors and effects when specific online redo log members are not available.
  • Identify the possible LGWR errors with their solutions.

Unit 4: Managing Tablespaces and Data Files

  • Identify the logical database structure.
  • Identify the components of the logical and physical structure of a database.
  • Identify the relationships between database components.
  • Identify the features of a tablespace.
  • Identify the uses of a tablespace.
  • Identify the features of a datafile.
  • Differentiate between the types of tablespaces.
  • Create a specified tablespace by using Oracle Storage Manager.
  • Identify the segment storage allocation parameters and what they determine.
  • Create a temporary tablespace by using Oracle Storage Manager.
  • Add a datafile to a tablespace by using the Oracle Storage Manager.
  • Enable automatic extension of a datafile in a tablespace by using Oracle Storage Manager.
  • Resize a datafile by using Oracle SQL Worksheet.
  • Change the values of the storage parameters by using Oracle Storage Manager.
  • Identify the features of the modes in which a tablespace can be taken offline.
  • Take a tablespace offline by using Oracle Storage Manager.
  • Move a datafile of the Non-SYSTEM tablespace by using Oracle SQL*Plus Worksheet.
  • Move a datafile belonging to the SYSTEM tablespace by using Oracle SQL*Plus Worksheet.
  • Make a tablespace read-only by using Oracle Storage Manager.
  • Sequence the steps to create a read-only tablespace on a read-only media.
  • Drop a tablespace by using Oracle Storage Manager.
  • Identify the effects of dropping a tablespace.
  • Identify the benefits of using multiple tablespaces.
  • Identify the benefits of specifying storage parameters for a tablespace.
  • Identify the dynamic performance views and the information they contain.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
  • At least a double speed CDROM drive.
  • An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
The network version of this course requires:
  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM and 22MB available hard disk space or file server space.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
More Oracle8i Database Administration Training from Serebra Learning Corporation
Click here for more information or to take this course
Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
Training-Classes.com by Skillbox® 07/18/08
Copyright 1998-2008 skillbox, inc. All rights reserved		 Connecting people who want to learn with people who love to teach
 Are you an Oracle8i database administration training provider?
You could be on this page today - for FREE!
This page was last updated on sb5 - 07/18/08 at 04:28:28 - 03:03:58