Oracle9i Database Administration Fundamentals I

start > courses and registration > training feature sheet

This course has been upgraded to:

»	Oracle Database 10g: Administration Workshop I Release 2

This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.

Oracle9i Database Administration Fundamentals I

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

9i-DBA1

length.

5 days

type.

Instructor-Led

partner.

Oracle

price.

$3,000 :: contact for GSA GOV.

Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this class, you'll learn how to design, create, and maintain an Oracle database.

Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students 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 is designed to prepare you for the corresponding Oracle Certified Associate exam: Exam #1Z0-031.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

	Database Administrators
	Database Users
	Database Developers

prerequisites

	Introduction to Oracle9i: SQL
	Introduction to Oracle9i: SQL Basics

skills gained

	Manage tablespaces, segments, extents, and blocks
	Manage users, privileges, and resources
	Create an operational database
	Start up and shut down an Oracle instance and database
	Manage Oracle database files
	Use Globalization Support features

related courses, exams and materials

	after related training and products

Oracle9i Database Administration Fundamentals II

course content details

	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