Oracle Database Administration

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000 people days annually. Computeraid is supplier-independent so does not sell hardware or software. As well as training thousands of staff from hundreds of smaller companies Computeraid also works with many of the largest organisations in the region. References from all sources are excellent. We offer a range of commercial training options, funded courses and subsidised consultancy. With training centres in Swansea, Cardiff, Neath and Carmarthen we are within easy reach of businesses throughout South Wales.

Company History

Computeraid was founded in 1988 and celebrated its 10th anniversary year by being awarded the Western Mail "Welsh Small Business of the Year" award. Our qualified and dedicated tutors have provided training solutions for thousands of businesses over the last twenty years.

Computeraid is an Investors in People organisation.

Course Objectives:

This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database. The Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment.

Course Contents

• Shell Environment
• Installing and Configuring Oracle
• Creating and Managing an Oracle database
• Administering an Oracle database
• Configuring the Oracle Network Environment
• Configuring Shared Servers
• Creating and Managing Database Storage Structures
• Managing Redo Log Files and Control Files
• Managing Schema Objects
• Managing Users, Profiles, Privileges and Roles
• Managing Undo Data and Temporary Segments
• Monitoring and Resolving Lock Conflicts
• Maintaining Database Security
• Monitoring the Performance of the Database
• Loading and Unloading Data
• Backing up and Recovering the Database
• Flashback

Course Details

This is a five-day course running from 9:30 am - 4:30 pm.
Courses run in Cardiff.

Prerequisites

To gain the maximum benefit from this course A working knowledge of SQL*Plus is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.

What Next?

Oracle SQL
This course is designed for anyone who needs to access and work with an Oracle Database.