Project Management Services
eBusiness Services E-Business enterprise architecture solutions Business process mapping Project Management Services
Introduction to Oracle Database Administration

COURSE DURATION 5 days

DESCRIPTION

This course provides the new Oracle database administrator (DBA) knowledge and structures for performing basic administrative functions and enables the setup, maintenance, and troubleshooting of an Oracle8 or 8i database. Students learn to create, startup, and shutdown a database; and to manage files and storage parameters, users, user roles, and granting of privileges. This class supports the student in preparing for the Oracle Database Administrator certification exam. Lectures are followed by workshops, with hands-on Oracle tool exercises.

AUDIENCE

  • Application programmers requiring DBA skills
  • Database administrators
  • System designers and administrators

PREREQUISITES

Students should attend the following class prior to attending:

  • Oracle 8i: Introducing SQL and PL/SQL

TECHNICAL REQUIREMENTS FOR CLASS SETUP

PC-equipped classroom with Oracle v8.0 or 8i installed on student PCs. Barco projector to display instructor?s PC.

Note: Client will need a technical person to install Oracle on a non-production database server, and install client product on student/instructor PCs. Also check install and call instructor to verify all set five days before class.

LOCATION AND MAXIMUM ATTENDANCE

All classes are scheduled and held at client site training rooms. No minimum attendance requirement. Maximum number of students: 16.

CONTENTS

  • Manage Oracle tablespaces, segments, extents, and blocks
  • Manage users, user privileges, and user roles; granting resources
  • Create, startup, and shutdown an operational database
  • Manage database files and other architectural components
  • Understand Data Dictionary Views and Standard Packages
  • Maintain the Control File and Redo Log Files
  • Manage Data Files and Storage Parameters
  • Manage tables, indexes, and Rollback Segments

Please contact us for availability, pricing and details of our Oracle Database Administration training.

Renee Taylor Consulting
Tel. 1 (530) 692 2000
Fax. 1 (530) 692 2011
Based in Sacramento
Serving State government clients, other public sector and corporate clients nationwide, including California and the entire West Coast

expert@rt-consulting.com



Copyright ©2001 Renée Taylor Consulting. All rights reserved.
Web Site Design: Volo Studios, Inc.