Data Modeling Training with SAP PowerDesigner

Logical Data Modeling Training with SAP PowerDesigner 16.5:

  • How to normalize the logical data model?
  • Clinic, Students, Order Form Model Examples
  • How to group entities?
  • How to add data item, entity attributes to entities?
  • How to add identifier? (Key group in Erwin)
  • How to add inheritance link? (subtype relationship in Erwin)
  • How to add inheritance? (subtype category in Erwin)
  • How to create relationships?
  • What is cardinality? How to connect different entities with relationship lines?
  • How to add diagram?  (stored display and subject area in Erwin)
  • How to add annotations? (notes in Erwin)
  • How to add text block (text symbol in Erwin)
  • How to add text symbol? (text block in Erwin)
  • How to compare different versions of a Logical Data Model?
  • Banking, Mortgage, Staffing, Insurance, and Training Data Models

Physical Data Modeling Training with SAP PowerDesigner 16.5:

  • Understanding the technical requirements/specifications from Database Administrator.
  • How to add those requirements/specifications in a physical data model?
  • How to add check constraints?
  • How to add Reference (Relationship in Erwin)?
  • How to convert logical data model to physical data model?
  • How to implement the physical data model in different database (forward engineering?
  • What is reverse engineering?
  • How to compare the different versions of a physical data model?
  • How to compare the physical data model and a Current DBMS (Current DBMS)?
  • Banking, Mortgage, Staffing, Insurance, and Training Data Model Examples
  • Comparison between Erwin and PowerDesigner

Dimensional Data Modeling training with SAP PowerDesigner 16.5?

 

  • Why do you need a data warehouse in SAP PowerDesigner Data Modeling?
  • What is the reason for a data mart?
  • Why is star schema? How is that different from dimensional data modeling?
  • Why customers prefer dimensional data modeling or snow flake modeling?
  • What are slowly changing dimensions?
  • Point of Sales Data Model, Banking, Mortgage, and Clinic Examples

If you need more information on this SAP PowerDesigner Data Modeling Training, please contact: Training@LearnDataModeling.com or 91-9080157239.

Online Training Course Start Date: 9th January, 2023.

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!