Data Management Essentials

Course Description:

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.

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.

This course includes the following modules:

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