Description

During this internship, you will discover the major features of PowerDesigner. You will learn to build, formalize and maintain the models used to design a database (object-oriented model - UML, conceptual and physical model, dictionary, etc.).

Who is this training for ?

For whom ?

Designer and database administrator, developer analyst.

Prerequisites

No special knowledge. However, knowledge of a computer language is a plus.

Training objectives

Establish a data dictionary in PowerDesigner

Implement and verify a conceptual data model in PowerDesigner

Configure the rules for transforming the conceptual model into the physical data model

Generate the physical model of the data with PowerDesigner and analyze its result

Practice Reverse Engineering with PowerDesigner

Training program

• Introduction
  • Presentation of PowerAMC.
  • The main functionalities.
  • The interface and the menus.
  • Practical work Getting started from PowerDesigner.
• Data identification
  • Learn how to create a data dictionary.
  • Data description and controls.
  • How to define attributes? Practical work Analysis of documents and identification of the data contained.
  • Enter the selected attributes and the associated rules into PowerDesigner.
• Semantic data modeling
  • The object-oriented model (OMO - UML class diagram).
  • Identification of classes, associations, constraints.
  • The approach to developing a model.
  • Normalization: the role of normal forms in understanding data.
  • The main concepts proposed by PowerDesigner.
  • The checks proposed.
  • The Conceptual Data Model (CDM).
  • Presentation of the concepts of the CDM by analogy and difference with the MOO.
  • Practical work Build a class diagram from the data dictionary.
  • Enter the result with PowerDesigner.
  • Carry out the proposed checks.
  • Generate the MCD with PowerDesigner and analyze the result.
• Physical data modeling
  • Presentation of the rules for transforming a semantic model into a physical data model.
  • The main optimization rules.
  • How PowerDesigner generates a MPD? The generation of the corresponding SQL scripts.
  • Practical work Transform the semantic model into a physical model.
  • Generate the MPD with PowerDesigner and analyze the result.
• Reverse Engineering
  • Presentation.
  • Reverse Engineering with PowerAmc.
  • Functions to create a MPD from an existing database.
  • How to generate an MOO or an MCD from an existing MPD? Practical work Add new attributes to a database.
  • Regenerate upstream models.
• Conclusion
  • Presentation of PowerDesigner processing functions.
  • Other diagrams.