Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to information and data modeling
Rating: 4.2 out of 5(121 ratings)
2,666 students

Introduction to information and data modeling

Using a combination of data modeling techniques in Sparx Enterprise Architect to create a three layer data model.
Created byBert Dingemans
Last updated 5/2022
English
English [Auto],

What you'll learn

  • Create information and data models at conceptual, logical and physical level
  • Use Sparx Enterprise Architect as a data modeling tool
  • Practice the various modeling techniques in a case based assignment

Course content

8 sections26 lectures6h 59m total length
  • What is data?26:19

    In this lesson we discuss the definition of data, information and knowledge. Furthermore we look at the four aspects of data

  • What is data modeling?27:19

    We discuss the various aspects of modeling, including the DaMa definitions, the modeling techniques and some general definitions

  • Quiz: What is data
  • Download the EBook "Get a grip on data modeling"

Requirements

  • Availabilty of a data modeling tool of your choice to create the models in the sample case, but the examples are with Sparx Enterprise Architect as data modeling tool
  • Installation of the trial version of Sparx Enterprise Architect

Description

This course draws a picture of the workfield of data and information modeling. Addressing the various modeling methodologies and the reasons behind choosing these different modeling methods. We will provide practical tips on how data modeling offers added value for your organisation, based on numerous backgrounds including databases, datawarehousing, messaging, data architecture, data governance, software development, big data and (master) data management.

You can create your own models based on a simple case giving you the opportunity to create a three layer information and data model based on:

  • The conceptual data model for business representatives

  • The logical data model for describing details of the data and information for both business and technical representatives

  • The physical data model, for database design and message modelling for technical staff.

The following modeling techniques are demonstrated:

  • Concept lists and trees,

  • SIPOC,

  • ArchiMate,

  • UML class and object modeling,

  • Entity Relationship,

  • XSD,

  • CRUD,

  • RACI,

  • OET,

  • Data Flows,

  • Snowflake and Star ModelsBased

All these techniques can be applied on the simple case so you are able to practice the theory. You get examples of how to create every modeling technique discussed. The demo models are prepared in Sparx Enterprise Architect, but you can also create your own modeling tool. Furthermore you will receive an example repository for Sparx Enterprise Architect with all the modeling techniques discussed.



Who this course is for:

  • Data modelers, information analysts, data architects, data owners and stewards