Oracle 9i DBA Training

Oracle9i Database Administration - 35 Hour Online Class or 5 Day Classroom Workshop

Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 9i Database. Provides an overview of the Oracle Data Dictionary and Oracle 9i architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing; Security; creating & managing Tablespaces, Indexes and Constraints; B-Tree concepts; managing storage; managing Undo, Redo Logs and Control Files; backup and recovery with Oracle RMAN; Logical Backups; SQL*Loader; an introduction to Oracle Networking and a comprehensive overview of creating an Oracle 9i database.

Online Class Schedule

Request a Class

 		 

Request More Info

    

Buy Course Book

  

Topic Summary | Print Version

Class Description:

This course provides you with the foundation skills necessary to create, maintain and manage an Oracle9i database. In this class we will focus on the techniques and skills necessary for day-to-day database administration tasks such as security, creating users, creating object (tables, tablespaces) and backup and recovery. An in-depth discussion of database architecture is provided.

This course has been completely updated for Oracle9i. Working examples are included throughout the course book and students have access to electronic versions of all examples and lab solutions. Approximately 50% of class time is spent on hands-on exercises.

This class will help prepare you for Oracle Certified Professional exam "Oracle9i Database: Fundamentals I Exam #1Z0-031". It also covers some of the material required for the next test, "Oracle9i Database: Fundamentals II Exam #1Z0-032".

This course provides the foundation of knowledge for but does not cover database tuning.

Audience: Database and System Administrators

Prerequisites: Oracle SQL, SQL*Plus and PL/SQL experience. This can be obtained in SkillBuilders' Introduction to Oracle9i for Developers class.

Objectives: After successfully completing this course, you will be able to:

  • Describe the major architectural components of Oracle9i, including the SGA, background processes and files that make up the physical database.
  • Query the data dictionary (e.g. DBA_TABLES, DBA_TABLESPACES) to determine the structure of the database.
  • Create administrative users, including granting and using the SYSDBA privilege
  • Start and stop a database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT.
  • Alter initialization parameter values, including the use of the 9i Server Parameter File.
  • Create new users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles.
  • Utilize the user password management features such as password expiration and account locking.
  • Audit activity on a database such as logon attempts.
  • Create and manage locally managed tablespaces including adding free space, monitoring free/used space and using the 9i OMF feature to locate and name the underlying datafiles.
  • Create heap tables including various datatypes such as VARCHAR2, DATE and NUMBER. Also use the table compression feature. Use DBMS_STATS to gather optimizer statistics on the tables you've created.
  • Create constraints on tables.
  • Create simple B-Tree indexes on tables. This includes understanding the fundamental rules for when and where to create and when to avoid using indexes.
  • Manage storage for objects (e.g. tables and indexes) with the PCTFREE and PCTUSED parameters. Also control concurrency with the INITTRANS and MAXTRANS parameters.
  • Work with the Oracle9i Automatic Undo Management feature including creating and enabling new undo tablespaces and monitoring for space-related problems.
  • Ensure that the database is recoverable by checking the archive log status of the database.
  • Understand the role and importance of control files and add additional control files.
  • Use the basic features of Recovery Manager to perform simple backup and recovery operations in the event of a lost or corrupted datafile.

Books that may help you learn

Look Inside This Book:

Topic Summary

To Top | Topic Summary