Introduction to Data Modelling

In this information age, data and data relationships have never been more important to … hmm … well just about everything. How much money is in your bank account? What platform does the train leave from? What is Barack Obama tweeting in Twitter? The answer to all of these questions is in the data and data relationships.


The ability to model data is an essential skill, whether it be for understanding key relationships in your organisation, modelling entity relationships as a basis for relational database design, or modelling object classes for software implementation.


This course provides a pragmatic introduction to data modelling for anyone involved in information management and related projects. The course is highly practical and involves group and individual exercises based on real world examples. Those needing more than an introduction should also attend the Data Modelling Workshop course that follows this course.


The ‘Introduction to Data Modelling’ course is delivered by Equinox training partner John Fisher. John is a well known and incredibly experienced data modeller and enterprise architect, who has undertaken data modelling for many key New Zealand organisations.

Duration

1 Day


Course Objectives

Following the completion of this course, students will be able to:

  • Appreciate the value of data and its importance to an enterprise
  • Understand the nature of data and its form
  • Identify and evaluate candidate entities in a business domain
  • Draw basic data model diagrams
  • Map data models to database schema

Audience

  • Business Analysts
  • Business Representatives
  • Architects
  • Developers
  • Testers
  • Project Managers

Course Syllabus

Introduction

  • The value of data

Basic Data Modelling

  • The elements of data
  • Patterns in relationships
  • Diagramming conventions

Data Modelling Approaches

  • Basic approaches
  • Structured modelling
  • Entity/class identification exercise

Data Modelling Practice

  • A basic data modelling exercise

Data Modelling and Databases

  • The nature of attributes and domains
  • Normalisation
  • Database mapping and information retrieval

Related Courses

Refer to Equinox's full suite of Business Analysis training courses.


Prerequisites

None.


View printable course description
Course NameDurationPriceDatesCourse Status
Introduction to Data Modelling1 Day$750Wellington 13/07/2012Scheduled
Auckland 21/09/2012Scheduled

All course prices listed by Equinox are in New Zealand dollars and exclude GST.