This 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 peo…
4.8 · Rated by learners Certificate of completion
Duration
20 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi
AI practice, included with this course
Rehearse the interview and test yourself before the real thing.
Available in your student dashboard as soon as you enrol —
no extra charge, nothing to install.
Course overview
About the Data Modeling and Design Using Erwin program.
This 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.
Why learn with BISP
Trusted by professionals across 30+ countries.
Industry trainers
Certified consultants with 12+ years of real project experience.
Hands-on practice
Real-time scenarios & live project modules, not just slides.
Placement support
Resume building, mock interviews & job referrals.
Certification
BISP certificate + full guidance for official exams.
Course curriculum
Designed by real-time industry professionals around current job roles.
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
05Attributes and Normalization10 topics
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
06Sub-types and Super-types2 topics
Identifying subtypes: real-world examples of subtypes and super types
Determining when entities are similar
07Determining when entities are similar3 topics
UIDs
Attributes
One-to-one relationships
08One-to-one relationships7 topics
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
09Recursive Relationships7 topics
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
10Erwin Data Modeling Concepts8 topics
Entities
Instances
Attributes
Keys
Relationships
Unification
Generalization hierarchies
Normalization
11Erwin Dimensional Modeling Fundamentals5 topics
Modeling Approaches
Dimensional Modeling First Steps
Dimensional Model Complexity
Time Variant Analysis
Dimensional Sources and Data Mapping
12Introduction to CA Erwin Data Modeler8 topics
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
13Intermediate CA Erwin Data Modeler12 topics
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
14Dimensional 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
15Delivery Methodology1 topics
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
16Class Delivery1 topics
Live Interactive classes with expert
Course details
Who it is for, what you need, and how it is delivered.
Who should learn Data Modeling and Design Using Erwin?
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
Prerequisites
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
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.
Class delivery
Live Interactive classes with expert
Certificate of completion
Earn an industry-recognised BISP Trainings certificate when you finish the course.
Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.
Can you schedule training as per my availability?
Yes. We discuss it with the trainer and schedule the training at a convenient time for you.
What if I miss a class?
You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.
Is there live project training?
Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.
How can I pay for the course?
Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.
More queries?
Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.
Call Us: +91 769-409-5404
