Er Data Modeling design is used for OLTP applications.
Video Duration : 16 hours
Quizes : ( 70+ Questions)
ONE Month Video View Access.
PDF Material for each topic can be downloaded.
Check out Course Contents given below:

• Data Modeling Concepts


• Data Modeling Introduction


• Data Modeling - Application Development Cycle


• Introduction to Data Warehouse


• Difference between OLTP Database & Warehouse Database


• Normalization


• First normal form


• Second Normal Form


• Third Normal Form


• Entities


• Attributes


• Single, simple ,composite,derived attributes


• Relationships


• 1-1 , 1-Many, Many-Many relationships


• Resolving Many - Many Relationships


• Identifying ,Non-Identifying Relationships


• Sub Type ,Super Type Relationships


• Unary , binary , Ternary Relationships


• Conceptual model


• Logical model


• Physical model


• Subject area model


• Case Study for Design Levels


• Validating model for standards


• FAQ


• Case Study

------------------
Erwin Tool:
----------------------

• Introduction to Erwin Tool


• Installation and configuration of Erwin and Notation


• Creation of Entities and attributes


• Creation of Relationships, Degree, Cardinality


• Understanding constraints (PK,FK) in Erwin tool


• Creation of Domains , Default Values, Validation rules


• Creating Diagrams, Themes


• Creating Conceptual model


• Creating Logical model


• Creating Physical model


• Creating Subject area model


• Generating Scripts from Physical Model


• Naming standards Implementation


• Datatype Standards Implementation


• Building reports and Printing in erwin


• Forward Engineering


• Reverse Engineering


• Complete compare of models/schema


• Bulk Editor


• Generating diagram in Picture format


• Adding auditing columns using -Forward Engineering Template


• Adding auditing columns using -Script Template


• Vertical Partitioning in Erwin


• Excel Import into Erwin using Erwin API/Macro

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Contact :
info@dbvidya.com

+91 991 2323 000(whats app )

www.dbvidya.com
www.dbvidya.com/blog