Description
This course is designed to teach participants how to create, maintain, and administer an Oracle7 database. Administering users, performing backups, recovering a database, and using the Data Dictionary are discussed. The course makes extensive use of the DBA tool SQL*DBA. This course does not cover application building with Oracle. The tools used to create applications are discussed only in the context of application tuning and database administration.

Audience
System administrators who will be supporting large Oracle databases, and application developers who will be developing database applications using Oracle.

Prerequisites
Familiarity (to a limited extent) with SQL, SQL*Forms and PL/SQL is required.

Hardware and Software
Dedicated Oracle7 server properly installed on any platform, with sufficient logins for the number of students and instructor. Administrator logins and privileges are also required.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Describe the role of the database administrator (DBA)
• Diagram the Oracle database architecture
• Create and administer an Oracle database
• Perform user administration in an Oracle database environment
• Backup and recover a database
• Use the Data Dictionary
• Use the Oracle SQL*DBA tool

What is a Database Administrator?

• Responsibilities of a DBA
• Data storage
• Integrity and consistency
• DBA accounts
• Performance monitoring

Oracle Architecture

• System processes
• Multiple Oracle instances
• User process structure
• The system and program global areas

Creating & Maintaining a Database

• The SQL*DBA tool
• Database states
• Instance management and modification
• Recovery
• Database configuration
• Creating a database

The Data Dictionary

• Data dictionary structure

File Structures

• Oracle database files
• Tablespaces and segments
• Data segments and row formats
• Oracle data formats
• Estimating storage requirements

Users and Security

• Enrolling users
• Privileges and roles
• Users and resources
• Information hiding
• Auditing

Backup and Recovery

• Database failure modes
• Redo logs, control files, and rollback segments
• Taking backups
• Recovering the database
• Using EXPORT and IMPORT
• Example scenarios and remedies

Distributed Databases

• Implementing a distributed database
• Distributed transaction processing