This course is to help the auditors to understand how to use Data Mining to assist in their auditing of large data.  Because of the Paper Reduction Act, many audits are going toward looking at large chunks of data from a database. Knowing how to ask for the data, knowing where to look, and having the basic skills will allow you to be successful in your auditing career.

Upon completion of this course, the participants will know and understand:

• Methodologies of Data Mining,

• Learning the process of Data Mining,

• Learning the approach to Data Mining,

• How to read Data Base Architecture,

• Reading Oracle Database Structure,

• Reading SQL Server Database Structure,

• Understanding Common naming conventions to help you understand the data,

• Learning basic rules in database structure,

• How to get your results,

• Learning SQL basic,

• SQL Aggregation Reports.

Auditors with little or no knowledge of Data Mining.

Prerequisite: Knowledge of MS Access and work on Database projects. IS background is helpful

Field of Study: Specialized Skills and Applications

Course Level: Intermediate