Video Duration : 21 hours
Quizes : ( 70+ Questions)
ONE Mock Test ( 40 questions)
ONE Month Video View Access.
PDF Material for each topic can be downloaded.
Check out Course Contents given below:

• Dimensional Data Modeling Concepts


• Data Modeling Introduction


• Data Modeling - Application Development Cycle


• Introduction to Data Warehouse


• Operational Data Store


• Data Mart


• Difference between OLTP Database & Warehouse Database


• Normalization


• First normal form


• Second Normal Form


• Third Normal Form


• Design levels


• Conceptual model


• Logical model


• Physical model


• Subject area model


• Case Study for Design Levels


• Types of Dimensional Data Model


• Star Schema


• Snow Flake


• Introduction to Dimension Tables


• Slowly Changing Dimensions


• SCD-Type 1


• SCD-Type 2


• SCD-Type 3


• Fast changing dimensions


• Junk Dimensions or Garbage dimensions


• Measures and Facts


• Facts


• Additive


• Semi-additive


• Non-additive


• Factless Fact Tables


• Hierarchies & Levels


• Identify the Grain


• 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


• import excel into erwin using erwin api/macro

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Contact :
info@dbvidya.com

+91 991 2323 000(whats app also)

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

Video Duration : 21 hours
Quizes : ( 70+ Questions)
ONE Mock Test ( 40 questions)
ONE Month Video View Access.
PDF Material for each topic can be downloaded.
Check out Course Contents given below:

more