Back To Oracle Training Courses

Oracle9i Database Fundamentals I Training CBT Suite

Price: $645.00

CBT Course Overview:

The Self Study Store Computer Based Training Introduction to Oracle9i Database Fundamentals I covers the database administration strategies and procedures provided in Oracle9i. This curriculum introduces the participants to the concepts and procedures associated with Oracle architectural components, the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this curriculum teaches users the procedures for managing segment free space, undo space, temporary segments, and indexes. Lastly participants will learn the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data, and the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. This curriculum will help candidates prepare for the Oracle9i OCP DBA Certification and is mapped to Exam 1Z1-031.

Total Training Duration:

40 hours

CBT Course Modules:

• Oracle9i Database Administration: Manage an Instance Training
• Oracle9i Database Administration: Create a Database Training
• Oracle9i Database Administration: Manage Storage Structures Training
• Oracle9i Database Administration: Manage Data Storage Training
• Oracle9i Database Administration: Manage Security Training

Training Course Topics:

• Learn the memory structures of the SGA and the information stored in the database and nondatabase files.
• Learn the connection procedures and the processes generated during database connection.
• Learn the stages in processing a query and the memory structures used in query processing.
• Learn the steps of DML processing and the memory structures involved in DML processing.
• Learn the uses of SCN and the features of a process commit.
• Learn the tasks of a DBA and the Oracle Enterprise Manager tools used by a DBA.
• Learn the OEM console components, steps to set up these components, and the functions of the OEM DBA tools.
• Learn the default DBA user accounts and set up authentication methods to validate users.
• Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories.
• Learn the requirements and factors considered while creating a database, the guidelines for planning the physical database design, the registry entries that must be specified for proper database functionality, and create a password file.
• Learn the types of parameter files, create a parameter file by editing settings in the init.ora file, and start an instance in the NOMOUNT mode.
• Learn the command options of the CREATE DATABASE command, the situations in which it fails, create a database by using the CREATE DATABASE command and Learn its content after creation.
• Learn the benefits of using Oracle-Managed Files and manage data files, control files, and online redo log files using OMF.
• Describe the data dictionary structure, Learn the data dictionary categories, and retrieve data dictionary information.
• Execute catproc.sql and Learn the uses of administrative scripts categories.
• Learn the types of segments in the storage hierarchy.
• Learn the benefits, working, and packages of automatic management of segment free space.
• Much more.