Data & Databases Management, Administration and Auditing (DDMA)

Organisations will increasingly expect Internal audit to provide greater coverage and depth in Internal Audit assurance and consulting activities. To this end, all this is achievable by analysing the vast amounts of data generated by the ever-evolving information and communication technology (ICT) i.e. analysis of data in audit activities.

Given the above, there are critical concerns over the security, integrity and authenticity of the data that is analysed and upon which important decisions are made.

Thus, it is essential for IA to understand the data, the characteristics of the data (metadata), the structure of the data (relationship), how the data is managed and administrated (database administration) and the auditable controls pertinent to this function.

Course Content:

• Brief overview of ICT Principles and Concepts in an inter-connected world
  • Complexity of ICT
  • Application systems inter-connectivity
  • Benefits and Risks of Applications residing in distributed platforms including “cloud-based” platforms
• Understanding Data and Databases
  • Data Classification and meta data
  • Types of applications
  • Integrated Applications
  • Database Management Systems
• Overview of Applications Systems design
  • Relational data base concepts
  • Normalization of data
  • Data Validation
  • [Group work: Design a database – scenario provided by facilitator]
• Database management, risks and controls
  • Management and administration of databases
  • Understand risk database management risks and,
  • Controls