Intermediate erwin Data Modeler

This course builds on the entry level course ‘Introduction to erwin Data Modeler’ and provides erwin users with a deeper understanding of the tool.

It focuses on how naming and datatype standards are an integral element of the tool and how these can be used and managed. It also provides students with an introduction to a range of erwin functions which are used in many corporate environments.

  • Creating and using ‘User Defined Domains’
  • Managing naming standards
  • Managing Datatype standards
  • An introduction to Forward Engineering (SQL Generation)
  • An introduction to Reverse Engineering
  • An introduction to Complete Compare

The link between an Attribute/Column and its assigned domain is one of the mostfundamental and powerful aspects of erwin. To avoid confusion and utilise this power, this course will give students a detailed understanding of that critical relationship.

The link between object names in a logical model and their counterpart in the physical model can cause some difficulties with some modellers. This course will place a particular emphasis on giving students a detailed knowledge of how erwin manages these issues. While this topic is most significant to those working with combined logical/physical modelsor with linked logical-only and physical-only models, fully understanding this subject is of benefit to all erwin users.
This intermediate course also provides an introduction to the core erwin functions of Forward Engineering, Reverse Engineering and Complete Compare. These topics are covered in greater depth in the advanced courses for the Complete Compare function.

Students should have a basic understanding of data modelling concepts and a knowledge of erwin equivalent to that provided by attending Sandhill’s course ‘Introduction to erwin Data Modeler’.