Back to Search Results

Training Course Summary:

The delegate learns 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 student learns to organise the database and to move data into and between databases, under different environments.

Pre-Requisites:

Introduction to Oracle: SQL and PL/SQL (SPLI)

Suggested Prerequisites

Understanding of stored procedures, functions, and packages concepts

Training Course Overview/Content:

Oracle Architectural Components
Oracle Architecture Main Components
Structures Involved in Connecting a User to an Oracle Instance
Listing the Stages in Processing: Queries; Data Manipulation Language (DML) Statements; COMMITs

Getting Started with the Oracle Server
Features of the Universal Installer
Setting Up Operating System and Password File Authentication
Main Components of Oracle Enterprise Manager

Managing an Oracle Instance
Creating the Parameter File
Starting Up an Instance and Opening the Database
Closing a Database and Shutting Down the Instance
Managing Sessions
Monitoring the ALERT File and Trace Files

Creating a Database
Preparing the Operating System
Preparing the Parameter File
Creating a Database

Data Dictionary Views and Standard Packages
Constructing the Data Dictionary Views
Preparing the PL/SQL Environment
Administering Stored Procedures and Packages
Database Event Triggers

Maintaining the Control File
Explaining the Use of the Control File
Contents of the Control File
Multiplexing the Control File
Obtaining Control File Information

Maintaining Redo Log Files
Use of Online Redo Log Files
Obtaining Log and Archive Information
Controlling Log Switches and Checkpoints
Multiplexing and Maintaining Online Redo Log Files
Planning Online Redo Log Files
Troubleshooting Common Redo Log File Problems
Analyzing Online and Archived Redo Logs

Managing Tablespaces and Data Files
The Logical Structure of the Database
Types of Temporary Segments
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
Logical Structure of the Database
Segment Types
Criteria for Separating Segments

Managing Rollback Segments
Creating Rollback Segments
Maintaining Rollback Segments
Planning the Number and Size of Rollback Segments
Troubleshooting Common Rollback Segment Problems

Managing Tables
Creating Tables Using Appropriate Storage Settings
Controlling the Space Used by Tables
Analyzing Tables to Check Integrity and Migration
Retrieving Information About Tables from the Data Dictionary
Converting Between Different Formats of ROWID

Managing Indexes
Different Types of Indexes
Creating B*-Tree and Bitmap Indexes
Reorganizing Indexes
Dropping Indexes

Maintaining Data Integrity
Implementing Data Integrity
Maintaining Integrity Constraints
Obtaining Constraint Information from the Data Dictionary

Loading Data
Loading Data Using Direct-Load Insert
Loading Data into Oracle Tables Using SQL*Loader

Reorganising Data
Reorganising Data Using Export and Import
Moving Data Using Transportable Tablespaces

Managing Password Security and Resources
Managing Passwords Using Profiles
Administering Profiles
Obtaining Information About Profiles, Password Management, and Resources

Managing Users
Creating New Database Users
Altering and Dropping Existing Database Users
Monitoring Information About Existing Users

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
Displaying Role Information from the Data Dictionary
Using National Language Support



Course Objectives

Start up and shut down an Oracle instance and database.
Create an operational database.
Manage Oracle database files
Manage tablespaces, segments, extents, and blocks.
Manage users, privileges, and resources.
Use National Language Support (NLS) Features