ISEB Data Management Essentials

Managing the information resource

e-business, Intranets, Data Warehousing applications and Multi-media developments all need confidence in the quality of the underlying data resource.

Data Management is the corporate service that assists the provision of these (and 'traditional') information systems by controlling and co-ordinating the definition and usage of reliable and relevant data. The industry standard approach adopted within this course sees Data Management as consisting of a number of vital roles and carrying out a set of critical activities.

Delegates will gain an understanding of the role of Data Management in defining and enforcing necessary procedures and standards in the area of database and application design.

The course provides delegates with the knowledge and skills needed to work effectively in the Data Management function within an IS department and is based on the syllabus for the ISEB Certificate in Data Management Essentials.

Who will the course benefit?

Data Management professionals wishing to implement a standard approach to their work, Data Management staff wishing to work towards a professional qualification in their area of expertise, Database Administrators wishing to widen their Data Management skills, experienced Business staff moving into a 'hybrid' role within Data Management.

Course Objectives

To enable delegates to understand the function of Data Management, in particular the importance of the Database Administration, Data Administration and Repository Administration roles and to work effectively as members of a Data Management team.

Skills Gained

This course will enable delegates to:

    * Practice Data Administration skills. e.g. data definition, corporate data modelling.
    * Create a Data Charter.
    * Practice Database Administration skills.
    * Identify Repository Administration skills e.g. managing a Data Dictionary software product.
    * Identify and control data duplication.
    * Assist in the selection of an effective distributed architecture.
    * Develop procedures for an organisations corporate data resource.
    * Assist in the definition of data to help define an organisation's business environment.
    * Practice Technology Direction Evaluation Skills.

Pre-Requisites

Delegates are expected to have some background in IT development, with practical experience of 'data' issues; OR in relevant business roles, including IS development project or IS strategy involvement. Significant DM experience is not required.

Course Content

Role/Authority of Data Management

The Data Charter.
Roles and responsibilities within Data Management.
Data Architecture concepts.
Data Management Techniques and Tools.

Data Administration

Data Analysis and Data Usage.
Data Definition.
Metadata principles.
Quality Assurance and Naming Conventions.
Ensuring Data Integrity.
Managing Data Replication.
Data Privacy, Security and Recovery.
Impact of Packages on Data Administration.
Data Modelling (project vs. corporate).
Functional Analysis role.
'Data over time' issues.


Database Administration

Physical Data Design.
Design of non-traditional databases.
DBMS selection.
Managing the DBMS.
Performance measurement and tuning.
Distributed DMBS issues.
Client/Server Issues.


Repository Administration

The role of the Data Dictionary.
Project vs. corporate dictionary issues.
Data Dictionary and Repository product features.
Repository Management.
Change Control.
Securing the Data Dictionary.


The Widening Scope of the Data Management Function

Introduction to Data Warehousing, OLAP and Data Mining - 'Business Intelligence'.
Internet and Intranet based systems.
Object Management.
e-business.