|
Auditing
Through the Computer Using SQL Server
Course
Objective
SQL
Sever presents various opportunities to different categories of
personnel. In audit for instance, the relational database
management system can be used to import and query any ODBC compliant
data files and thereby give an auditor a privilege of expressing
his/her opinion. This course is designed to upskill participant’s
capabilities with the use of SQL Server in auditing through the
computer.
Course
Outline
.
Computer Skill for Auditors
- Hands-on Session on Computer Operations
- Electronic File Methods of Recording, Storage and Retrieval
- Different Types of Files Kept in Computer and their methods
of audit
- Obtaining, accessing and managing the files to audit
- Performing the Workstation Audit
.
Introduction to Information Technology Audit Challenges
.
Overview of Computer Database Management
. Introduction to Windows Environment for Data Analysis
.
Fundamentals of Data Structure and File Format
. Introduction to SQL Server Environments
. Overview of SQL Server Architecture, Fundamental of SQL
Server Architecture
. Logical Database Components - Data Type and Table Structure,
SQL View,
SQL Stored Procedures, Constraints, Rules, Defaults and Triggers,
Systems Database and Data
. Physical Database Architecture and Systems Database
and Data
.
Establishing and Creating Data Directories: Importing and
Linking Data Files
.
Extraction and Analysis Functions: File Stratification, Key
Field Summarization
. Obtaining Field Statistics
.
Working with Computed Fields . Data Integrity Testing
Functions
.
Parallel Testing of Various Business Operations
.
Exception Reporting: Re-calculation of COT, Interest Income,
Charges as well as recomputation of Inventory Values
.
Payroll Audit, . Aging of Bills and Inventory
.
Gaps and Duplicate testing in serially numbered items
. Creating Reports: Formatting Views, Multi-line Reports and
Graphing
.
Development and Writing Program Checklist using SQL Statements
- Translating Audit Program Steps to SQL Statements and Functions
-
Simulating Data Flows and Processing
-
Writing statement to Capture Processes
.
Automation of Audit Procedures using SQL Statements
-
Building an SQL Statement
Who
Should Attend?
The
above workshop is designed for Internal Auditors, External
Auditors, Control Executives and Professional working in Information
Security Department of his/her organization
Dates
Duration
Venue
Cost (N)
Nov. 12-16
5 Days Ultimate
Systems Solutions Training Center 45,
500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Nov. 26-30
5 Days
"
45,
500
Dec. 10- 14
5 Days Ultimate
Systems Solutions Training Center
45, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Provision
Executive
Leather Bag, Lunch, Tea Break, Various Accounting Modules as stated
above on diskette, One Computer Per Participant, Group Photograph,
Workshop Materials
Note
Depending
on your choice, we can also run the above course for you in either
your office or your training center. But the number of participants
would not be less than 5.
| 