Data Modelling training course
Data Modelling training - 2 days - Please call for a quote

Data Modelling training

The Data Modelling training course is designed to be both practical and participative. Introductory ‘input’ sessions are interspersed with practical exercises to illustrate the points discussed and there is a continuing case study where participants can apply their knowledge to a practical scenario.

Data Modelling Training Course Objectives

At the end of this Data Modelling training course participants will be able to:

  • Describe the basic principles of data modelling
  • Define and identify entities, attributes, relationships and keys
  • Define, explain and use the concepts of data relationships
  • Build a logical data model using advanced concepts including sub-types, super-types and entity aspects
  • Describe the theory and application of relational data analysis
  • Use relational data analysis (‘third normal form’) to identify data relations and build a data model based upon them
  • Create a composite data model from the logical data model and the relational data model
  • Validate a data model against defined access and navigation requirements
business analysis training
HOME
BUSINESS ANALYSIS TRAINING COURSES
BOOKING FORM
DATES
BESPOKE TRAINING
download Data Modelling training course outline as PDF
WIN A COURSE

Data Modelling training uk

Data Modelling Training Course Content

 

1. Principles of data modelling

  • Entities
  • Attributes
  • Relationships
  • Keys
  • Entity descriptions

2. Data relationships

  • Cardinality
  • Optionality
  • Exclusivity
  • Recursion
  • Naming relationships
  • Relationship descriptions

3. Data modelling – further concepts

  • Attribute descriptions
  • Domain descriptions
  • Sub-types, super-types
  • Partitioning data models
  • Transferable and non-transferrable relationships
  • Entity aspects

4. Relational data analysis

  • Relations
  • Primary and candidate keys
  • Third normal form analysis

5 . Drawing third normal form models

  • Rationalising the results of relational data analysis
  • Representing relations and keys
  • Rules for building the TNF model
  • Comparing the TNF model with the data model

6 . Validating the data model

  • Validating against requirements
  • Access paths
  • Entry points and input attributes
  • Navigation
  • Volumetrics

Data Modelling Training Course Prerequisites:-

  • There are no prerequisites for this Data Modelling training course.

Data Modelling Training Recommended Reading:-

Data Modeling - G. Lawrence Sanders - buy from amazon
home book this course resources 01273 622272            info@siliconbeachtraining.co.uk

upISEB Systems Development Training

These courses can be taken as part of the ISEB Systems Development diploma - see details

Systems Development Essentials
Systems Modelling Techniques with UML

Systems Design and Implementation Techniques
Business Analysis Essentials

Software Testing Foundation Training
Evaluating & Procuring Software Packages

upISEB Business Analysis Training

These courses can be taken as part of the ISEB Business Analysis diploma - see details

Business Analysis Essentials
Requirements Engineering
The Organisational Context

 Modelling Business Processes
Software Testing Foundation

Systems Modelling Techniques
Systems Development Essentials

upSystems Development Training

These courses can be taken as part of the ISEB Systems Development diploma - see details

Business Analysis Essentials
Software Package Selection Training

Software Testing Training
Systems Design and Implentation Techniques Training

Systems Development Essentials Training
Systems Modelling Techniques Training

upBusiness Analysis Training

These courses can be taken as part of the ISEB Business Analysis diploma - see details

Agile Development Training
Analysis & Design Techniques
Business Analysis Essentials
Business Organisation Training

 Data Modelling Training
Object Oriented Modelling Training Requirements Engineering Training

Software Testing Practitioner Training
SSADM Essentials Training
User Centred Systems Design

home | about us | bespoke training courses | course dates | course offers | training resources | contact | clients | book course

systems development training | six sigma training | training courses | business analysis & design training | programming training | image print & dtp training | office & business applications training | web design & internet training | video games & 3D training | business skills training | coaching mentoring training | human resources training | management leadership training | project management training | sales training | heather buckley photography |

assertiveness resource | photoshop resource | time management resource | leadership resource
train the trainer | management resource | PRINCE2 resource | six sigma resource