On-line training course catalogue

Oracle 9i Database Administration Fundamentals I

Type of course: Classroom

Course details

Fee	£2200
Days	5
Course code	ORO9IDBAI

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

Delegates will learn how to use an administration tool to start-up and shutdown a database, create a database, manage file and database storage, and manage users and their privileges. In addition, the delegate learns to organise the database and to move data into and between databases, under different environments.

Prerequisites

Delegates should have an Introduction into Oracle 9i SQL and understand stored procedures, functions, and packages concepts.

Delegates will learn how to

• Outline the Oracle9i architecture
• Create an operational database
• Start up and shut down an Oracle instance
• Manage Oracle physical database files
• Manage Oracle logical database structures
• Manage Oracle users, privileges, and resources
• Use global support features

Outline

ORACLE ARCHITECTURAL COMPONENTS:

Defining an Oracle server, the Oracle instance, and the Oracle database; understanding the physical structure; understanding the memory structure; understanding the process structure; understanding the logical structure; establishing a connection and creating a session; processing a SQL statement

GETTING STARTED WITH THE ORACLE SERVER:

Features of the universal installer; optimal flexible architecture; creating a database; identifying database administrative users; understanding operating system and password file authentication

MANAGING AN ORACLE INSTANCE:

Managing PFILE and SPFILE initialisation files; identifying the states of starting an instance; options to shutdown an instance; obtain and set parameter values; monitoring alert and trace files

CREATING A DATABASE:

Using database configuration assistant to create a database; creating a database

DATA DICTIONARY VIEWS CONTENTS AND USAGE:

Identifying the uses and contents of the data dictionary; using the data dictionary to obtain information

MAINTAINING THE CONTROL FILE:

Explaining the use of the control file; contents of the control file; multiplexing the control file; managing control file with OMF; obtaining control file information

MAINTAINING REDO LOG FILES:

Use of online redo log files; structure of redo log files; controlling log switches and checkpoints; managing online redo log files; managing online redo log files using OMF; multiplexing online redo log files; obtaining online redo log file information

MANAGING TABLESPACES AND DATA FILES:

The logical structure of the database; types of table spaces; creating tablespaces; changing the size of tablespaces; allocating space for temporary segments; changing the status of tablespaces; changing the storage settings of tablespaces; relocating tablespaces

STORAGE STRUCTURE AND RELATIONSHIPS:

Segment types; storage clause precedence; extents and their purpose; data block structure

MANAGING UNDO DATA:

Purpose of undo data; types of undo segments; automatic undo management concepts and configuration; creating and maintaining undo tablespaces

MANAGING TABLES:

Oracle data types; ROWID formats; structure of a row; creating tables

MANAGING INDEXES:

Different types of indexes; creating B*-Tree and bitmap indexes; reorganising indexes

MAINTAINING DATA INTEGRITY:

Implementing data integrity; maintaining integrity constraints; obtaining constraint information from the data dictionary

MANAGING PASSWORD SECURITY AND RESOURCES:

Managing passwords using profiles; administering profiles

MANAGING USERS:

Creating new database users; altering and dropping existing database users; monitoring information

MANAGING PRIVILEGES:

Identifying system and object privileges; granting and revoking privileges; controlling operating system or password file authentication; identifying auditing capabilities

MANAGING ROLES:

Creating and modifying roles; controlling availability of roles; removing roles; using predefined roles

USING NATIONAL LANGUAGE SUPPORT:

Database character sets and national character sets; using globalisation support parameters; obtaining globalisation support information

Related Certifications

This course forms part of the following certification track(s):

• Oracle9i Database Administrator Certified Associate