Data Modelling — A 2 day course
Please see our Training Homepage for currently available courses.
Data modelling is normally assumed to be a technique employed in the initial stages of database design. Properly employed, data modelling will lead to the design of databases that hold the data required by the business to carry out its tasks in such a way that the business is presented with consistent, up-to-date and accurate information, whilst allowing for future changes in business practices. But data modelling techniques can also be used to help to understand and document the information requirements of a business, irrespective of whether that is to lead to the development of a database or not. Data modelling is a powerful business analysis tool in its own right. This two-day course teaches the key techniques of data modelling to prepare attendees to take their place in system development or business analysis teams. It will also be of benefit to business managers who may need to review data models. The course will be delivered through a mix of presentations, discussions and exercises. The course will use the data modelling notation used in the ORACLE® case tool and in the later versions of SSADM (Structured Systems Analysis and Design Method). This course is endorsed by DAMA UK.
This course teaches the key techniques of data modelling and data analysis that allow analysts to document information needs and system developers to satisfy the business information needs. On successful completion of the course, attendees will be able to:
- Identify the information requirements for a business system and develop a model to represent these
- Carry out accurate relational data analysis to remove data redundancy, ambiguity and anomalies
- Document and build logical models based on the business relationships of data requirements
This course is for:
- Business Analysts
- System Designers
- Database Administrators
- Business staff involved with defining system requirements
There are no specific prerequisites for this course but an appreciation of the need for well-ordered data and the difficulties of developing such would be an advantage.
This course has been retired and is no longer available.