| Oracle
8i DBA - Data Dictionary and Database Files
The course is aimed at familiarizing the student with the Data
Dictionary views and database files. You will learn to manage log
and control files, and obtain information from control files. The
planning, use, and troubleshooting of redo log files will be explained.
The course provides a list of Data Dictionary views and you will
type in commands to perform administrative tasks. You will also
learn to administer stored procedures and packages.
Data Dictionary and Database Files training covers such topics
as:
The Oracle Data Dictionary
Standard Packages and Objects
Control Files
Log Files Concepts
Working with Log Files
Oracle 8i DBA - Oracle Storage Architecture
This course is designed to give an Oracle DBA the necessary knowledge
and skills to manage data storage. It will provide detailed information
about logical structures such as tablespaces, segments, extents,
and Oracle data blocks. The creation and management of rollback
segments will also be covered. The course also provides a list
of data dictionary views that help in managing these logical structures.
Oracle Storage Architecture training covers such topics as:
Tablespaces
Datafiles
Logical Structures
Rollback Segment Concepts
Working with Rollback Segments
Oracle 8i DBA - Understanding Storage Allocation
This course covers the various aspects of optimizing database
objects. It discusses tables, clusters, and index-organized tables.
This course explains the different types of tables supported by
Oracle 8i, the structure of a row, the different data types supported
by Oracle 8i, and guidelines for creating a table. The course teaches
you how to create a cluster, a cluster index, and the tables in
the cluster. The course also explains how to create and manage
the index-organized tables.
Understanding Storage Allocation training covers such topics as:
Tables
Managing Tablespaces
Deleting Tables
Clusters And Index Organized Tables The course addresses the training needs of IT Professionals who
use Oracle 8i. This course also addresses the needs of IT professionals
who want to become
certified under the Oracle8i Certified Database Administrator (DBA) Track.
Completion of this course and the other course titles from this
curriculum prepares the learner for Oracle Exam #1Z0-001: Introduction
to Oracle: SQL and PL/SQL |
