Data Modeling and Design Using Erwin

Inquire now

Course Overview:

This Data Modeling and Design Using Erwin training course introduces people to the principles and process of logical data modeling, Physical Data Modeling using ERWin Tool. The course details how to convert the business data requirements into a graphical representation. It teaches people how to analyze business requirements that should be incorporated into a logical data model and in Physical Data model in turn. In short, participants will learn proven, practical skills for analyzing and modeling data requirements, and make them ready to be transformed into a relational database and design multi Dimensional Database.

Target Audience:

  • Anyone who is interested to learn
  • Who wants to make a career in data Modelling
  • Database Administrators
  • Database Modelers
  • Analytics Managers
  • ETL and BI Developers

Pre-requisites:

This certification training course does not presume or require any prior knowledge or prerequisites.

However, basic knowledge of database concepts be an added advantageous.

We are recommending that students should have following:

  • Basic knowledge of database

Course Duration:

  • 3 Days ( 21 hours )

Course Content:

Introduction to Logical Data Modeling

  • Definitions
  • Benefits of logical data modeling
  • Data modeling vs. physical database design
  • Roles involved in data modeling
  • Steps in the data modeling process
  • Example data model

Entities

  • Identifying entities
  • Validating entities

► Documenting “instances” of entities

Distinguishing entities from attributes

  • Naming entities
  • Starting an Entity/Relationship (E/R) diagram
  • Workshop

Relationships

  • Identifying significant relationships
  • Determining the “cardinality” or “degree” of a relationship
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • Determining whether a relationship is optional or mandatory
  • Giving a relationship a name
  • Documenting the relationships in the E/R diagram
  • Walking people through an E/R diagram
  • Workshop
  • Resolving Many-to-Many Relationships
  • Real-world examples of many-to-many relationships
  • Why many-to-many relationships are broken down into simpler relationships
  • Identifying “association” or “intersection” entities
  • Documenting the new relationships in the E/R diagram
  • Workshop

Attributes and Normalization

  • Defining and categorizing attributes
  • Domains and integrity rules
  • Unique identifiers/primary keys
  • Foreign keys
  • Occurrence population
  • Normalization: validating the placement of each attribute
  • Attribute does not repeat (first normal form)
  • Attribute is dependent on its entire UID (second normal form)
  • Attribute is dependent only on its UID (third normal form)
  • Workshop

Sub-types and Super-types

  • Identifying subtypes: real-world examples of subtypes and super types
  • Determining when entities are similar

Determining when entities are similar

  • UIDs
  • Attributes
  • One-to-one relationships

One-to-one relationships

  • Creating subtypes and super types
  • “Type” entities
  • Using subtypes to apply fourth normal form
  • Establishing the relationships of the sub- and super-entities to other entities
  • Mutually exclusive vs. non-mutually exclusive subtypes
  • “Role” entities to handle complex subtypes
  • Workshop

Recursive Relationships

  • Real-world examples of recursive relationships
  • Discovering recursive relationships
  • Determining whether the relationships are optional or mandatory
  • Documenting the new relationships in the E/R diagram
  • Hierarchical vs. Network recursive relationships
  • “Structure” or “Bill of Materials” entities: fifth normal form
  • Workshop

Erwin Data Modeling Concepts

  • Entities
  • Instances
  • Attributes
  • Keys
  • Relationships
  • Unification
  • Generalization hierarchies
  • Normalization

Erwin Dimensional Modeling Fundamentals

  • Modeling Approaches
  • Dimensional Modeling First Steps
  • Dimensional Model Complexity
  • Time Variant Analysis
  • Dimensional Sources and Data Mapping

Introduction to CA Erwin Data Modeler

  • Creating and configuring new models
  • Creating and defining entities
  • Creating and defining attributes
  • An introduction to the relationship of an attribute and its assigned domain
  • Creating and defining relationships
  • Creating and using Subject Area views of models
  • Extending Erwin with user defined metadata
  • Erwin reporting

Intermediate CA Erwin Data Modeler

  • Creating and using user Defined Domains
  • Managing naming standards
  • Managing Data type standards
  • An introduction to Forward Engineering (SQL Generation)
  • An introduction to reverse Engineering
  • An introduction to Complete Compare
  • Complete Compare Scenarios
  • Complete Compare Exercise
  • Design Layer Architecture
  • API programming
  • ODBC reporting
  • Data Warehouse modelling

Dimensional Modeling Self Paced Sessions

Session_1: Identify User Requirements

Session_2: Modeling Design Phase

Session_3: Semantic Layer

Session_4: Multi Dimensional Database Path I

Session_5: Multi Dimensional Database Part II

Delivery Methodology

  • We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course

 

 

Course Customization Options

To request a customized training for this course, please contact us to arrange.

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy