Data Modelling is the sharpest scope management tool available to information systems development.
Practical Data Modelling
Data modelling is not optional; no database was ever built without at least an implicit model
On completion of this course, you will be able to:
Benefits of this course
Gives you confidence to:
Who is this course for?
It is targeted at anyone working in data requirements specification, data modelling or those working extensively with data modelling professionals and wish to be able to develop and review at more than just a basic level.
Why Data Training?
- Organisations mandate training to protect valued assets: People, Money, Reputation and Data
- Helps staff Improve their understanding and confidence in handling data assets.
- “Organisations rely on their data assets to make more effective decisions and to operate more efficiently” (DMBoK V2 P20)
The course contains 2 sections:
- An introduction to data modelling
- Practical data modelling
An introduction to data modelling
The course teaches:
- How to read data models
- Modelling from primary sources
What to look for Rich in case studies the course also covers the areas of:
- Introduction to Relational modelling
- Removing redundancy through normalisation
- Entity Modelling
- Attribute modelling including data types, value range & codes
- Development of attributed conceptual models
- Practical development of a data model utilising example scenarios
Practical data modelling
The course expands on section 1 content with:
- More sophisticated modelling techniques
- Practical warehouse/lake modelling
- Larger case studies
The course also covers the areas of:
- Subtypes & Supertypes
- Time & History
- Nulls, optional and completeness
- Types of identifiers (keys)
- Reuse, patterns & resources
- Data warehousing modelling (Star Schemes and an introduction to Vault models)
- Bringing together a number of skills by solving a specific tangible large case study
- No SQL considerations.