Services

• Professional Services
• Education
  • Introduction to Modeling 101
  • Fundamentals of ERwin 201
  • Intermediate ERwin 301
  • Technical ERwin 401
  • ERwin R8 Conversion Class
• Support
  • Support FAQ

Fundamentals of ERwin 201*

Sandhill Academy's Fundamentals of CA's ERwin® 201 teaches the fundamentals of using CA's ERwin® line of data modeling solutions, and includes courses designed for Data Modelers, System Analysts and DBA's to familiarize their use with CA's ERwin®, and CA's ERwin® Process Modeler. These introductory courses are designed to review data modeling, dimensional modeling and process modeling basics and progressively move to more advanced aspects of working with the products. Fundamentals of CA's ERwin® 201 courses include:

ERwin Fundamentals

CA's ERwin® Fundamentals, briefly reviews data modeling concepts, and delivers a detailed introduction to CA's ERwin® Data Modeler. The course teaches the essential features of an CA's ERwin® data model, shows how to create and define basic data model objects and basic relational structures, and demonstrates defining and using constraints. The physical elements of this one-day course are focused on generics rather than DBMS-specific support. CA's ERwin® Fundamentals is available as an instructor-led training class, held on-site at client locations.

Model Manager Workshop

Model Manager Workshop covers two different topics and two different audiences. The section dealing with setup and administration will target users involved in these tasks and will be specific to the DBMS (SQL Server, Oracle or Sybase) on which the repository is to be hosted. The second element focuses on working with the repository on a day-to-day basis and is aimed at the CA's ERwin® user who works with models held in Model Manager repository. Model Manager Workshop is available as a three-day training session, held on-site at client locations.

Dimensional Modeling Fundamentals

Dimensional  Modeling Fundamentals, starts with a brief overview of dimensional modeling concepts to level set the knowledge on the theory of Dimensional Modeling and reviews what are facts and dimensions.   The students then learn to describe, design and build dimensional models and model marts using Star Schemas’ or Snowflake Dimensional Modeling Techniques.  Students also learn how to define the three classic types of time variants and how they are traditionally positioned. Part of the class also focuses on  normalization / de-normalization as part of the design process, and assess their impact on the key structures.  This class is filled with hand on lab exercises and upon completion the student will know how to do dimensional modeling in CA's ERwin®.  Dimensional Modeling Fundamentals is available as an instructor-led training class, held on-site at client locations.

Process Modeling Fundamentals

Process Modeling Fundamentals delivers a detailed  introduction into CA's ERwin® Process Modeler. The course teaches the fundamentals of creating a process model and teaches students process modeling methods, techniques and notations.  This class is oriented to the Business  / System analyst who needs to document their business processes.  Process Modeling Fundamentals is available as an instructor-led training class, held on-site at client locations.