Speaker: Kevin Dahl

Session Description:

The Oracle Database Auditor Training class helps prepare database analysts, information systems auditors, and other support personnel for a database audit. Since all students are not at the same starting point with their database knowledge, students will learn the fundamentals of relational database technologies and learn how to view and retrieve data from an Oracle database. After reviewing the fundamentals with the students, the course will move into a deeper dive of the Oracle database architecture, user profiles, password management, data protection, user roles and privileges, and the creation of security and database reports. Exercises will be executed in the class using a sample Oracle database that will be downloaded by each student before attending the training.

Course Outline:

DAY 1

· Understand the basic concepts of relational databases

· Communicating with Databases – SQL Introduction

· Select and Where Clauses

· Run data manipulation statements (DML)

· Database access to specific objects

· Database access to data dictionary views

· Retrieve row and column data from tables

· Create reports of sorted and formatted data

DAY 2

· Learn about the Oracle Database Architecture

· Profiles and Password Management

· Learn basic information on backup and recovery method

· Oracle users and security

· Review of users, roles, and privileges

· Create reports providing database information and security

Who should attend?

IT auditors who perform audits on Oracle databases will benefit from this training by learning how to better request and seek out the necessary information.

IT professionals who work for organizations that seek to be compliant with industry regulations or strengthen internal controls will learn how to better configure and manage their environments. They will also discover how to be better prepared for IT audits.

Speaker Bio:

• Past 7 years as an independent consultant functioning as an Oracle related System Architect, Database Administrator, and Linux Administrator

• Prior to that, 11 years as a w2 consultant functioning as an Oracle related System Architect and Database Administrator, and Linux Administrator

• Prior to that, 20 years working for Fortune 500 companies as a Financial Analyst and then in IT related positions

• Undergrad degree: BSBA in Finance from University of Nebraska at Omaha

• Graduate degree: Masters of Computer Systems Management from Creighton University

Date/Time: October 16th and 17th from 8am to 4:30pm (Light breakfast and lunch will be served both days).

Location: Nashville State Community College, 120 White Bridge Road, Nashville, TN 37209

The event will occur at the Building S, room S-118

CPE: Up to 16 hours of credit will be issued to attendees.

Chapter Event Policy: See the Chapter website for complete details on the Chapter's event policies.