Oracle Database 10g DBA using Enterprise Manager

2 days @ £995.00 exc. VAT

Course Code: O10GDBA

Virtual Events You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.

Oracle Database 10g DBA using Enterprise Manager Course Overview

The Oracle Database 10g DBA using Enterprise Manager course is aimed at database administrators of small sized databases who need to carry out basic administration tasks on an Oracle 10g database. The course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The focus is on using Enterprise Manager to teach delegates how to manage the database.

The Oracle Database 10g DBA using Enterprise Manager course is not aimed at delegates who are full time Database Administrators. Full time Database Administrators should attend the Oracle Database 10g DBA - Part I and Oracle Database 10g DBA - Part II courses.

The delegate will learn and acquire skills as follows:

Installing Oracle Database 10g Software
Creating an Oracle database
Administering an Oracle database with Enterprise Manager
Configuring the Oracle Network Environment
Creating and Managing Database Storage Structures
Managing Schema Objects
Managing Users
Maintaining Database Security
Backing up, Restoring and Recovering the Database
Monitoring the Performance of the Database Using Advisors

Who will the Course Benefit?

The Oracle Database 10g DBA using Enterprise Manager course will benefit Database Administrators of small sized databases who need to install Oracle Database 10g software, create, monitor and support a 10g database. The Oracle Database 10g DBA using Enterprise Manager course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 10g software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Course Objectives

The Oracle Database 10g DBA using Enterprise Manager course aims to give delegates practical experience in installing Oracle Database 10g software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Requirements

Delegates who wish to attend this Oracle Database 10g DBA using Enterprise Manager course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.

Pre-Requisite Courses

Oracle SQL

Follow-On Courses

Notes:

Course technical content is subject to change without notice.
Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

View Course Contents - DAY 1

Oracle Database 10g DBA using Enterprise Manager Training Course

Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: INTRODUCTION

Oracle product overview
Oracle Support services
Relational database concepts
Oracle architecture
Database administration tasks
Database administrators responsibilities

Session 2: INSTALLATION & CONFIGURATION OF AN ORACLE DATABASE

Understand system requirements
Use Oracle Universal Installer to install Oracle software (OUI)
Create a database using Database Configuration Assistant (DBCA)
Delete a database using DBCA
Use DBCA to manage templates
Upgrade a database using Database Upgrade Assistant (DBUA)

Session 3: ADMINISTER A DATABASE

Administrative tools available to a DBA
Use SQL*Plus and iSQL*Plus to manage a database
Administer the database using Enterprise Manager (EM)
Start and stop the EM Database Console
EM navigation
Grant EM administrative privileges to a user

Session 4: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

Overview of network configuration
Oracle Net Listener configuration and management
Oracle Net Naming methods
Tools for configuring and managing the Oracle network
Configure local naming for client connections with Net Manager
Start and stop the Oracle listener
Configure the listener with EM
Use TNSPING to test Oracle Net connectivity
Connect to the database

Session 5: MANAGE AN ORACLE INSTANCE

View Course Contents - DAY 2

Oracle Database 10g DBA using Enterprise Manager Training Course

Session 6: DATABASE STORAGE STRUCTURES

Oracle database structures
Control files
Redo log and archive redo log files
Tablespaces and data files
Create tablespaces
Manage tablespaces
Manage undo and use the Undo Advisor
Use EM to view the storage structure of the database

Session 7: MANAGE USERS

Session 8: MANAGE SCHEMA OBJECTS

Create schema objects
Create a new table
View the attributes and contents of a table
Understand data integrity
Define constraints
Create indexes
View index attributes
Create views
Create synonyms
Create sequences

Session 9: BACK UP, RECOVER AND RESTORE A DATABASE

Oracle backup strategy
Overview of backup, restore and recovery
Backup and recovery configuration
Configure ARCHIVELOG mode
Backup and recover the database using EM
Schedule backups
Configure backup settings
Configure recovery settings
Configure catalog settings
Perform recovery

Session 10: PERFORMANCE MONITORING

Self-monitoring architecture
Monitor an Oracle database
Automatic Workload Repository
Automatic Database Diagnostics Monitor (ADDM)
Use the advisors
Set up notification rules

Home Let Us Call You Enquiry

Place A booking

97.35%
Instructor
Quality
Rating

92.54%
Course
Practical
Rating

94.35%
Overall
Courseware
Rating

96.29%
Overall
Course
Rating

Print Friendly

97.35%
Instructor
Quality
Rating

96.29%
Overall
Course
Rating

Please call for Dates

Request a Centre .......

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.

Enquiry