Online Undo eLearning Training
From Serebra Learning Corporation
Data Storage in Oracle9i
To describe the data storage structures in an Oracle9i database and explain how to manage them Anyone wanting to learn about Oracle9i database administration
more...
Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Tuning Database Structures in Oracle9i
To describe how to tune components of an Oracle9i database Anyone wishing to learn about Oracle9i database performance tuning
more...
Oracle Database 10g Managing Undo Data and Lock Conflicts Release 2
To discuss how to manage undo data and manage lock conflicts in an Oracle database Anyone wanting to learn about Oracle Database 10g database administration
more...
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
Oracle Database 10g New Space Management Features
To identify the new space management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Working with text and paragraphs in Word 2003
To demonstrate how to format text and organize paragraphs in Word Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent
more...
ECDL ICDL 4 Module 3 Word Processing - Word 2003 Text and Paragraphs
To demonstrate how to format text and organize paragraphs using Word 2003. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a word-processing application; end users wanting to attain competency in using Microsoft Word 2003; end users wanting to attain an ECDL or
more...
Oracle9i Database Administration: Create a Database


The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain
more...
Oracle9i Database Administration: Manage Storage Structures


The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary
more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention


The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.
more...
Oracle9i Database Administration: Create a Database
The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components management of rollback segments temporary segments and indexes. In addition this course discusses how to create and maintain
more...
Oracle9i Database Administration: Manage Storage Structures
The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course participants learn the concepts associated with storage structure components. In addition this course teaches users the procedures for managing segment free space undo space temporary segments
more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention
The content of this course includes details about each component of an Oracle database instance such as data blocks disks memory CPU and dynamic views. Students learn about migration and chaining reorganizing indexes optimizing sort operations tuning rollback segments managing automatic undo monitoring activities implementing the Oracle shared server and troubleshooting.
more...
From 123-CBT Computer Based Training
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention

... operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To: o Match the component of database storage with its definition. o Avoid dynamic allocation of extents by using the ALTER TABLE command. o Avoid the dynamic allocation disadvantages by creating a locally managed tablespace. o
more...
Oracle9i Database Admin Manage Storage Structures

...hes users the procedures for managing segment free space, undo space, temporary segments, and indexes. Learn To Identify the types of segments in the storage hierarchy. Identify the benefits, working, and packages of automatic management of segment free space. Identify the ways in which extents are controlled by segments. Identify the block space
more...
Oracle9i Database Admin Create a Database

...ew features of Oracle9i, such as Oracle Managed Files and Undo tablespaces, and the new features of the LogMiner utility. Learn To Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories. Identify the requirements and factors considered while creating a database, the guidelines for planning the physical database design, the
more...
Oracle Database 10g Administration Workshop II Part 3

...shback Table operation.
Identify features of guaranteed undo retention.
Unit 2: Database Corruption
Identify features of block corruption.
Identify features of the DBVERIFY utility.
Identify features of the ANALYZE command.
Identify features of the DB_BLOCK_CHECKING parameter.
Sequence the steps for using the DBMS_REPAIR package to manage data block corruption.
Identify
more...
Oracle Database 10g Administration Workshop I Part 4

...ract with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques.
Learn To:
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to use Undo efficiently.
Match database failures with their possible causes.
Identify features of instance recovery.
more...
Oracle Database 10g New Features for Administrators Part 2

...collection in Oracle Database 10g.
Identify features of undo retention tuning in Oracle Database 10g.
Identify features of automatic checkpoint tuning in Oracle Database 10g.
Unit 2: Manageability Infrastructure
Identify features of Automatic Workload Repository (AWR).
Identify features of Automatic Workload Repository (AWR) snapshots.
Identify options for configuring Automatic
more...
Oracle Database 10g New Features for Administrators Part 3

...nt.
Identify options for setting the parameters for the undo management area.
Identify features of sorted hash clusters.
Unit 3: Enhanced VLDB Support
Identify features of bigfile tablespace (BFT).
Identify tasks to be performed for managing bigfile tablespace (BFT).
Identify features of a temporary tablespace group.
Identify tasks to be performed for managing temporary
more...
Oracle Database 10g New Features for Administrators Part 4

...hich they are used.
Identify the features of guaranteed undo retention.
Identify tasks to be performed for configuring Flashback Databases.
Identify features of the SYSAUX tablespace.
Identify the steps to relocate SYSAUX occupants by using Enterprise Manager (EM).
Identify conditions for renaming tablespaces in Oracle Database 10g.
Audience:
The target course audience is Data
more...
Office XP New Features Part 2 Access Outlook FrontPage

...e-mail, and Internet software. Learn To Identify the undo and redo capabilities of Access 2002. Learn To: Identify the features of error logging in database conversions. Learn To: Convert a database from a previous version to Access 2002 format. Learn To: Identify the enhancements to the message header area in Outlook 2002. Learn To: Identify the capabilities of account selection in
more...
