IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
ORACLE 9i DBA Part I

Duration: 5 days

Course Overview
This course is designed to give the delegate an introduction into Oracle Database Administration. It will give a firm foundation allowing the delegate to succeed at maintaining, troubleshooting and backup and recovery of an Oracle database.

The course will show the delegates how to use the Administration tools provided. It will cover database creation, user management and other general areas associated with an Oracle database. Delegates will gain an understanding of the Oracle9i database architecture. They will learn how the individual components of the database interact and what is needed in order for them to maintain an efficient operational database.

The course will give the delegate a hands-on approach to all areas of database administration. Each chapter will have practical exercises where possible and in addition will contain OCP questions for each chapter.

Course Objectives


By the end of the course attendees will:

• Understand the architecture of an Oracle database
• Be able to create an operational database
• Manage Oracle database files
• Manage tablespace, segments, extents and blocks
• Manage users
• Create tables and indexes
• Manage constraints
• Create rolls
• Audit users
• Diagnose and troubleshoot database problems
• Be able to use a number of different backup and recovery techniques
• Start-up and shutdown the database

Prerequisites


A good knowledge of SQL is essential, together with knowledge of basic operating system commands (e.g. copy, delete, move). Ideally delegates will have attended the Fundamentals of ORACLE 9i SQL and SQL*Plus course.

Course Content


Introduction
• Role of the DBA
• Tools & Utilities

Oracle Database Architecture

Creating a Database
• Optimal Flexible Architecture
• Planning a Database
• The CREATE DATABASE Command
• CATPROC and CATALOG
• Database Configuration Assistant

Managing an Instance
• STARTUP Options
• SHUTDOWN Options
• The Parameter Files PFILE and SPFILE

Oracle Enterprise Manager
• Console Window

The Data Dictionary
• Base Tables
• Views

Maintaining the Control File and Redo Log Files
• What is the Control File Used For?
• What is in the Control File?
• What are the Redo Log Files Used For?
• Redo Log File Structure

Managing Tablespaces and Data Files
• Logical Storage Structure of the Database
• Physical Structure of the Database
• Dictionary-managed Tablespaces and their uses
• Locally-managed Tablespaces and their uses
• Creating Tablespaces
• Relocating Tablespaces
• Resizing Tablespaces

Managing Undo Data
• What is Undo Data?
• Managing Undo Data

Managing Tables and Indexes
• Creating Tables
• Oracle Data Types
• ROWID Formats
• Creating b-tree Indexes
• Creating a Bitmap Index
• Controlling space used by tables
• Analysing tables for performance

Partitioned Tables and Indexes
• Range Partitions
• Hash Partitions
• Composite Partitions
• List Partitions

Utilities
• SQL Loader
• Import and Export

Backup and Recovery Overview
• Hot and Cold Backups
• Incremental and Cumulative Backups
• Early detection of block corruption
• Using Log and Trace Files to diagnose problems
• Recovery Manager

Users and Security
• System and Object Level Privileges
• Granting and Revoking Privileges
• Roles
• Creating Users
• Auditing
• Managing Passwords Using Profiles
• Administering Profiles

Using National Language Support
• Choosing the Database’s Character Set
• Specifying the Language-Dependent Behaviour

Enter your email address to register for our newsletter: