ERWIN TRAINING COURSE CONTENT
https://www.globalonlinetrainings.com/erwin-training/
Identifying significant relationships
Determining the "cardinality" or "degree" of a relationship
One-to-One
One-to-Many
Many-to-Many
A relationship continues...
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
Recursive Relationships continues...
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 Modelling Concepts
Entities
Instances
Attributes
Keys
Relationships
Unification
Generalization hierarchies
Normalization
Erwin Dimensional Modelling 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 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
Overview of Erwin Training:
Erwin
Data Modeling Training is one of the important tools that help to discover the
good quality of data. It is one of the important solutions for data modeling of
custom-made information systems. In other words we can also say ERwin is the
combination of Entity Relationships (ER) and Microsoft windows (win). There are
three editions in ERwin Data Modeler. They are Standard, Workgroup and
Navigator. At our Global Online Trainings only you can get the practical
knowledge and with this practical knowledge only we can get the job easily.
What are the advantages of Erwin Training?
The
main advantages of Erwin Training are as follows.
§ For the enterprises, Erwin data modeling
develops a blueprint. This blue print helps in design solution.
§ With the Erwin tool we can build the data
model easily.
§ We can design the data models both
logically and physically.
§ Database objects are generated with the
help of models.
What are the uses of Erwin Training?
The
uses of the Erwin Training are as follows.
§ Erwin data modeler is used for the target
server by enabling the design of the physical data model. We can also say that
it is a drawing tool.
§ This is used to manage the infrastructure
that is related to complex enterprise data.
§ With the help of Erwin data modeling, the
quality can be increased and the cost of the maintenance is decreased.
“If any student misses the session we will
provide backup session according to the student flexibility”
What are the features of Erwin Training?
The
features of the Erwin Training are as follows.
§ If the data models are generated than the
visualizations of the complex data structures are made.
§ Due to the creation of database designs
from visual models. We can increase the efficiency.
§ Erwin helps in the comparison of
bidirectional synchronization of models.
§ It helps in presenting the diagrams as
well as metadata.
§ It can also handle other projects such as
BI tools, MDM hubs, ETL and also UML tools.
What is the methodology of Erwin Training?
§ The main reason for the development of
Erwin is to maintain the IDEF1X and IE modeling standards.
§ For the development of the system the
different levels of the IDEF1X method is used.
§ It helps to increase or decrease the
number of levels for the individual situations.
§ The levels of the model are normally spanned
related to the major entities that plays an important role for the business.
This is used to design the database by a specific DBMS.
§ At the last level of the detail, the
models depend on technology. For example, the models IMS database and the model
of DB2 database both are different.
§ At higher levels, models do not depend on
the technology and it is used to represent the information. That information is
not stored in any automated system.
§ The modeling levels are connected to a
top-down system development life cycle approach.
Highest level models:
The
highest level models are of two forms. They are ERD and KB.
§ ERD: ERD stands for Entity Relationship
Diagram. It is used to identify the major business entities and their
relationships.
§ KB: KB stands for Key Based. Sets the
scope of the business information requirement and begins to expose the details.
Lower level models:
The
lower level models are of two forms. They are FA and TM.
§ FA: FA stands for Fully Attributed. This Fully
Attributed represents a third normal form model that consists total details for
a particular implementation effort.
§ TM: TM stands for Transformation Model.
TM represents a transformation of the relational model that is related to the
DBMS used for the implementation. In many cases Transformation Model won’t
present in third normal form. The structures are optimized based on the
capabilities of the DBMS, the data volumes, and the expected access patterns
and rates against the data. In a way, this is a picture of the eventual
physical database design.
What is DBMS model in Erwin Data Modeling
Training?
DBMS
stands for Database Management System. In the DBMS model there is a database
design for the system. Depending on the level of integration of the information
systems of a business, the DBMS Model may be a project level model or an area
level model for the entire integrated system. For the database the security is
given by DBMS. Most used DBMS, now days are MySQL, Oracle, and SQL Server etc.
Along with Erwin Training learn Data
Modeling Training:
The
action that is taking place to create a data model is known as Data Modeling.
This Data Modeling is used to store the data in the database. With the help of
Data Modeling, we can see the data and this will also helps in enforcing
business rules and government policies.
Types of Data Models:
Data
models are of three types. They are Conceptual, Logical and Physical.
Conceptual Data Model: To known the system behavior, the
conceptual data model is used. This will be more useful for Business stakeholders
and Data Architects.
Logical Data Model: Logical Data Model defines the process of
implementation without the consideration of DBMS. This Logical Data Model is
more useful for Data Architects and Business Analysts. We can also maintain the
technical map.
Physical Data Model: Physical data model explains the
process of implementation with particular DBMS system. This Physical Data Model
is developed by DBA and developers. It is used to implement the database.
Uses of Data Modeling:
The
uses of Data Modeling are as follows.
§ Database requires data objects and these
data objects are supplied perfectly.
§ At all types of data models, we can design
the database.
§ The structure of the data model is used to
explain the relational tables, first and foreign keys.
§ We can visualize the base data and it is
helpful for the developers for developing physical database.
§ If any data is unknown then we can known
with the help of Data Model.
These
are just the basics of Data Modeling and you learn in detail of Data Modeling Training along with Erwin Training.
Learn Data Warehouse Architecture Training
along with Erwin Training:
Data
warehouse architecture consists of data from different sources. This is used to
analyze the organization. Data warehouse is used to collect the information
from different sources in an organization and this is utilized to take Wright
decisions.
Many
companies are showing interest in cloud-based data warehouses rather than
traditional warehouses. Due to the following reasons.
§ There is no need to buy physical hardware.
§ It is cheaper to set up the cloud data
warehouses.
§ It uses MPP. Where MPP stands for
Massively Parallel Processing.
The
layers of the Data warehouse architecture are as follows.
§ Data Source Layer
§ Data Staging Layer
§ Data Storage Layer
§ Data Presentation Layer
Data Source Layer:
In this
Data Source Layer, original data is collected from different internal and
external sources in the relational database. These stores data in Operational
Data, Social Media Data and Third-party data.
Data Staging Layer:
The
data staging layer is between the data sources and the data warehouse. Data is
taken from various internal and external data sources. There are two
components in Data Staging Layer. They are
§ Landing Database and Staging Area.
§ Data Integration Tool (ETL).
Data Storage Layer:
The data
is cleansed in the staging area is stored in the form of single central
repository. Based on the type of business and data warehouse architecture the
data is stored. It can be data warehouse, data mart or an Operational Data
Store.
Data Presentation Layer:
The
place where the users communicate with cleansed and organized is known as Data
Presentation Layer. The users have the capability to question the data for
product or service.
These
are just the basics of Data Warehouse Architecture. You can get the detailed
knowledge on Data Warehouse Architecture Training along with Erwin Training.
Learn Cognos BI Training along with Erwin
Training:
Cognos
BI stands for Cognos Business Intelligence. It is a based tool that is related
to reporting. This is mainly used for data aggregation. In Data Warehouse
there is a data and that data is taken from different heterogeneous data
sources.
Features of IBM Cognos Business
Intelligence:
Some of
the important features of IBM Cognos Business Intelligence are as follows.
§ IBM’s Cognos BI tool is based on Web. So
there is no need of any desktop tools.
§ There is also a mobile functionality.
§ We can also create not only online and but
also offline reports.
§ With the help of Cognos BI we can store
the data and information on cloud platforms.
§ This Cognos Business Intelligence consists
of different modules along with the functions.
Relationships in Cognos BI:
In
Cognos Business Intelligence there are many relationships. Some of the
important relationships are as follows. They are One to One, One to Many and
Many to Many.
One to One: If one query subject of instance is
related to another instance than it is known as One to One.
One to Many: One to Many relationships takes place if
the single instances of query subject are related to many instances.
Many to Many: Many to Many relationships take place when
various instances of a query subject are connected to many instances.
Query Studio:
Query
Studio is one of the web based tool to generate not only queries but also
reports.
The
functions that can be performed in Query Studio are as follows.
Viewing Data: To see the data in a tree hierarchy we
have to connect to data source. As a result we can see query details etc.
Creating BI reports: We can create easy reports with the help
of data source.
Changing the present reports: We can do the modifications for the
present reports by editing the layout.
Data Customization of the reports: We can also perform different
customization in reports.
These
are just the basics of Cognos BI Training. You can get the detail knowledge
on Cognos BI Training along with Erwin Training.
Conclusion to Erwin Training:
Erwin
course is one of the important in the present market. Many organizations are
looking for the candidates who are having good knowledge on Erwin. They are
ready to pay good salaries for the Wright candidates. On an average good
candidate can earn an average of 9.22 Lakhs per annum.
To Top
