On-line training course catalogue

Oracle Database 10g: 2 Day DBA

Type of course: Classroom

Course details

Fee	£880
Days	2
Course code	OR10G2DBA

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.

The goal of this course is to teach Database Administrators how to install the Oracle Database 10g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required tasks. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses.

Delegates will learn how to

• Monitor the database and use the Advisors
• Manage database storage structures
• Configure and manage the Oracle Network environment
• Manage schema objects
• Install Oracle Database software and create a database
• Use Enterprise Manager Database Control to manage the database
• Back up and recover the Oracle Database
• Administer users and security

Outline

Overview of Oracle Database Administration

Overview of the Oracle Instance and Database

Tasks of an Oracle Database Administrator

Tools Used to Administer an Oracle Database

Working with Oracle Support

Searching MetaLink

Logging TARs

Installing Oracle Software and Creating the Database

Using the Oracle Universal Installer (OUI)

Installation Pre-requisites

Installing the Oracle Software

Using the Database Configuration Assistant (DBCA) to Create a Database

Using DBCA to Manage Templates

Upgrading the Database Using the Database Upgrade Assistant (DBUA)

Install the Oracle Software Using OUI

Use the DBCA to Create a Database

Using Oracle Enterprise Manager Database Control and SQL*Plus

Overview of Administering the Database Using Enterprise Manager (EM)

Starting the EM Database Console

Enterprise Manager Navigation

Granting EM Administrative Privileges

Start the EM Database Console

Navigate in EM

Grant EM Administrative Privileges to Another User

Configuring the Oracle Network Environment

Network Configuration Overview

Oracle Net Listener Configuration and Management

Oracle Net Naming Methods

Tools for Configuring and Managing the Oracle Network

Using EM to Configure and Manage the Oracle Network

Start and Stop the Listener

Configure Local Naming

Connect to the Database

Managing the Oracle Instance

Oracle Instance and Instance Management

Memory Structures

Background Processes

Accessing the Oracle Database

Initialization Parameters

Password File

Starting Up and Shutting Down the Instance

Viewing the Alert Log and Trace Files

Managing Database Storage Structures

Oracle Database Structures

Control Files

Multiplexing and Archiving the Redo Log Files

Tablespaces and Data Files

Creating a New Tablespace

Managing Undo in the Database

Using the Undo Advisor

Use EM to View the Storage Structure of the Database

Administering Users and Security

Overview of Users and Security

Creating and Administering Users

Locking and Unlocking Accounts

Setting Passwords

Administering Privileges and Roles

Create a New User

Grant Privileges to the User

Lock and Unlock the User Account

Managing Schema Objects

Creating Schema Objects

Create a New Table and View the Attributes and Contents of a Table

Understanding Data Integrity and Defining Constraints

Creating and Viewing Attributes of Indexes

Creating Views

Loading Data

Export and Import

External Tables

Performing Backup and Recovery

Backup, Restore and Recovery Concepts

Configuring the Database for Backup and Recovery and Setting Backup Policies

Configure the ARCHIVELOG Mode and Automatic Archiving

Configure the Flash Recovery Area

Retention Policy

Backing Up the Database Using EM

Oracle-Suggested Backup Strategy

Perform a Whole Database Backup and Recovery

Monitoring and Tuning the Database

Monitoring the Oracle Database

Self-Monitoring Architecture

Automatic Workload Repository

Metrics, Thresholds, and Alerts

Automatic Database Diagnostics Monitor (ADDM)

Monitoring and Tuning Usage Model

Setting Up Notification Rules

Using the Advisors