• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

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.


Duration : 30 hours


Fee: 319


Job Trends

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

You will get recordings of each training session that you attended

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

Data Modeling and Design Using Erwin Download  

Data Modeling and Relational Database design using ERwin

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

Subtypes and Super-types

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

UIDs
Attributes
One-to-one relationships

  • Creating subtypes and supertypes
  • "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 Datatype 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 Modelling 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
 

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

Prerequisit for Data Modeling and Design Using Erwin

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 Meghodology used to deliver Data Modeling and Design Using Erwin

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

Data Modeling and Design Using Erwin FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?