HOME

ABOUT US

COURSE OVERVIEW

One of the commonest database systems that IT Auditors are likely to encounter the Oracle Database System is a prime candidate for hosting applications. This course, hands-on in-house or in-lab only, will allow a small group of IT Auditors to experience Oracle first hand.

COURSE BENEFITS

Skills:

After completion of this course, you will be able to:

• Describe how Oracle works and the key database objects that comprise an Oracle system

• Evaluate the core database security controls

• Audit an Oracle database

• Appreciate the new facilities in later releases of Oracle

Support Materials:

This course is accompanied by a manual that includes full briefing notes.

WHO SHOULD ATTEND

This course is designed for a small group in-house, and by arrangement only. IT Auditors should have a minimum of six-months’ experience before they come on this course.

This course is by arrangement only

COURSE Programme

Introduction

• How Oracle works

• Components of the Oracle system

• Role and Objectives of the Database Administrator

Database Objects

• Tables and views

• Forms

• Triggers

• Structured Query Language

Database Security Controls

• User account management

• Database and OS authorisation

• User and Database Roles

• System privileges

Auditing Oracle Databases

• How to access the Data Dictionary

• Where to look for control information

• The Oracle audit trail

• Database triggers and their uses

• How to use SQL and ODBC to extract Oracle control information

New Oracle Features

• Oracle fine-grained auditing

• Virtual Private Databases

• Oracle grid computing with Oracle 10g

• Flashback queries

• Oracle Log Miner

• The Oracle web interfaces – Enterprise Manager and ISQL*Plus

TRAINING

In-House Training

Public Course Schedule

Course Library

CONSULTANCY

RESOURCES

CLIENTS

CONTACT US

Copyright 2008 MindGrove Ltd.

Call us on +44 (0)1925 732 757

All rights reserved.
to discuss your requirements