Delegates: |
|
Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 11g. The course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. This course is not aimed at delegates who are full time Database Administrators. Full time Database Administrators should attend the Oracle Database 11g DBA - Part I and Oracle Database 11g DBA - Part II courses.
|
Objectives: |
|
This course aims to give delegates practical experience in installing Oracle Database 11g software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks. The focus is on using Enterprise Manager to teach delegates how to carry out basic management of the database.
|
Topics Covered: |
- Installing Oracle Database 11g 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 and Restoring the Database
- Monitoring the Performance of the Database Using Advisors
|
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.
|
