Oracle Database 10g DBA using Enterprise Manager

2 days @ £725.00  
S5

Oracle Database 10g DBA using Enterprise Manager Course Overview

This 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.

This 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.

Skills Gained

The delegate will practise:

  • 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?

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

This 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.

Examinations

This Oracle Database 10g DBA using Enterprise Manager course covers the main topics of the optional Oracle exam #IZ0-041- Oracle Database 10g 2 Day DBA Assessment.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Requirements

Delegates should have an understanding of relational database concepts and basic operating system knowledge.  They should also have a working knowledge of Oracle SQL*Plus; this can be gained by attendance on the pre-requisite course.  Knowledge of PL/SQL would be beneficial.

Oracle Database 10g DBA using Enterprise Manager Training Course

Course Contents - DAY 1

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 administration tools

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

  • Oracle instance
  • Instance management
  • Memory structures
  • Background processes
  • Access an Oracle database
  • Initialization parameters
  • Password file
  • Shutdown the database
  • Startup the database
  • View alert log and trace files

Oracle Database 10g DBA using Enterprise Manager Training Course

Course Contents - DAY 2

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

  • Database administration accounts
  • User accounts
  • Create and administer user accounts
  • Lock and unlock user accounts
  • Change a user's password
  • Administer privileges and roles

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

Pre-Requisite Courses

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600 6116
Manchester centre:
MWB Manchester
Pall Mall Court
61-67 King Street
Manchester
M2 4PD
UK
Birmingham centre:
MWB Birmingham
43 Temple Row
Birmingham
B2 5LS
UK
Bristol centre:
Woodhouse Manor
Fern Hill
Almondsbury
Bristol
BS32 4LX
UK
Leeds centre:
c/o Blue Chip Training Solutions
11 New Princess Street
Leeds
LS11 9BA
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Oracle Database 10g DBA using Enterprise Manager outline