InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
  10g DBA Track  
  10g iDS Track  
  10g Java Develop. Track  
  10g App. Server Track  
  9i DBA Track  
  9i iDS Track  
  9i J2EE Java Develop. Track  
  9i AS Web Adm. Track  
Oracle Data Warehouse
























































Oracle 9i Database Administration Fundamentals I

This course is designed to give you a firm foundation in basic database tasks. In this course, you'll learn how to design, create, and maintain an Oracle database. Participants will gain a conceptual under­standing of the Oracle database architecture and how its components work and interact with one another. Participants will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. The lesson topics are reinforced with structured hands-on practices.

This course helps Participants prepare to successfully pass the Oracle certification exam #1z0-031 to become an Oracle Database Administrator Certified Associte (OCA-DBA).


Course schedule

Duration: 30 hours
To view the schedule for this class, click here.

Who should attend

Administrators and other IT Professionals involved in the management of Oracle 9i databases.


Introduction to Oracle9i: SQL course or equivalent knowledge.

Course Outline

Oracle Architectural Components
  • Defining an Oracle Database, the Oracle server, and the Oracle Instance
  • Establishing a connection and creating a session
  • Understanding the physical structure
  • Understanding the memory structure
  • Understanding the process structure
  • Understanding the logical structure
  • Outlining the stages of an SQL statement
Getting Started with the Oracle Server
  • Identifying database administrative tools
  • Identifying the features of the Universal Installer
  • Defining the Optimal Flexible Architecture
  • Creating a database during installation
  • Creating a new database
  • Identifying database administrative users
  • Understanding operating system and password file authentication
  • SQL*Plus
  • Enterprise Manager
Managing an Oracle Instance
  • Creating, managing, and using initialization files: PFILE and SPFILE
  • Identifying the various states of starting an instance
  • Identifying the various options available to shutdown an instance
  • Monitoring Alert and Trace files
Creating a Database
  • Using the Database Configuration Assistant to create a database
  • Creating a database manually
Using the Data Dictionary
  • Identifying the uses and contents of the data dictionary
  • Using the data dictionary to retrieve information about the database
Maintaining the Control File
  • Explaining the uses of the control file
  • Listing the contents of the control file
  • Multiplexing the control file
  • Managing control file with Oracle Managed Files (OMF)
  • Obtaining control file information
Maintaining Redo Log Files
  • Explaining the purpose of and how online redo log files work
  • Control log switches and checkpoints
  • Maintaining online redo log files
  • Managing online redo log files using OMF
  • Multiplexing and maintaining online redo log files
  • Archiving online redo log files
  • Obtaining online and archived redo log file information
Managing Tablespaces and Datafiles
  • Describing storage hierarchy
  • Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
  • Creating and managing tablespaces
  • Creating a tablespace when using OMF
  • Obtaining tablespace and datafile information
Storage Structures and Relationships
  • Describing the logical structure of the database (segments, extents, blocks)
  • Listing the segment types and their uses
  • Understanding the use of extents and their allocation and deallocation
  • Understanding the structure of a database block
  • Maintaining storage structures with automatic segment - space management
  • Maintaining storage structures manually
  • Obtaining storage structure information
Managing Undo Data
  • Understanding the difference between automatic undo management and manual undo management
  • Creating and maintaining UNDO tablespaces
  • Obtaining undo information
Managing Tables
  • Creating and maintaining tables using appropriate storage settings
  • Obtaining table information
Managing Indexes
  • Listing the different types of indexes and their uses
  • Creating b-tree and bitmap indexes
  • Maintaining Indexes
  • Identifying unused indexes
  • Obtaining index Information
Maintaining Data Integrity
  • Implement data integrity constraints
  • Maintain integrity constraints
  • Obtain constraint information
Managing Password Security and Resources
  • Manage passwords using profiles
  • Administer profiles
  • Control use of resources using profiles
  • Obtain information about profiles, password management and resources
Managing Users
  • Create new database users
  • Alter and drop existing database users
  • Monitor information about existing users
Managing Privileges
  • Identify system and object privileges
  • Grant and revoke privileges
  • Identify auditing capabilities
Managing Roles
  • Create and modify roles
  • Control availability of roles
  • Remove roles
  • Use predefined roles
  • Display role information
Using Globalization Support
  • Choose a database character set and national character set for a database
  • Specify the language-dependent behavior
  • Use the different types of National Language Support (NLS) parameters
  • Obtain information about Globalization Support usage




INFORMIT - Skill Development Center
Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
Fax. (022) 4231 168 - E-mail:

  Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
© 2006, InformIT Ganesa Pratama. All Right Reserved