Introduction To Information And Data Modeling

Using multiple data modeling techniques in Sparx Enterprise Architect

Last updated 2022-01-10 | 3.9

- 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

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

* 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 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, software development, big data and (master) data management.

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 on a simple case you are able to practice the theory. You get examples of how to create every modeling technique discussed. Furthermore you will receive an example repository with all the modeling techniques discussed.

Who this course is for:

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

Course content

8 sections • 37 lectures

Introduction to data and modeling 3 lectures

What is data? Preview 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? Preview 27:19

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

Quiz: What is data

Five questions on data and modeling

Modeling in Sparx Enterprise Architect 4 lectures

Basic modeling concepts of Sparx Enterprise Architect Preview 22:04

Introduction to the basic modeling concepts like getting around, repository based modeling and using perspectives.

Data modeling techniques in Sparx Enterprise Architect Preview 32:59

Introduction to the navigation and usage for the various data modeling techniques, creating basic diagrams and creating a repository structure

Assignment Alberto Sparx Enterprise Architect

In this assignment you create a simple repository structure and some diagrams in Sparx Enterprise Architect

Quiz: Modeling in Sparx Enterprise Architect

Five questions on Data Modeling in Enterprise Architect

Conceptual Data Modeling 6 lectures

Introduction to conceptual data modeling Preview 10:41

Discussion of the conceptual data modeling techniques. Including tips and tricks for conceptual data modeling

Concept lists and trees Preview 24:22

Techniques and usage for concept lists and trees

SIPOC Preview 13:37

Description of the modeling technique Supplier - Input - Process - Output - Consumer

Data models using ArchiMate Preview 26:50

Using the Enterprise Architecture modeling language ArchiMate for creating conceptual data models

Assignment Conceptual Data Model

There are two assignment tracks. The first one is about time registration. the second about home delivery. Please feel free to select one of these. When you want to do both that is alo perfect of course. A sample repository can be found in the last section of this training