PowerDesigner Training

1. Training: SAP Sybase PowerDesigner for Data Modellers (3 Tage, Kurssprache: Englisch)
mehr…

2. Workshop: “Building the Data Model Pyramid with SAP Sybase PowerDesigner” (1 Tag, Kurssprache: Englisch)
mehr…

3. Workshop: “Take control of your database schemas with SAP Sybase PowerDesigner” (1/2 Tag, Kurssprache: Englisch)
mehr…

Klicken Sie hier für eine Angebotsanfrage oder um mit uns Ihre Anforderungen zu diskutieren.

 

“SAP Sybase PowerDesigner for Data Modellers” 

Dieser Standardkurs für Datenmodellierer nutzt die Konzepte des Buches “Data Modeling Made Simple with PowerDesigner”. Anhand unterschiedlicher Übungen erstellen die Teilnehmer eine Reihe von Modellen für einen Beispielverlag.

Der Kurs beinhaltet folgende Module:

Modul 1 – Introduction

  • Introduction to PowerDesigner
  • PowerDesigner Data Models
  • Data Modelling Objects

Modul 2 – Creating the Subject Area Model

  • General Options
  • Models and Diagrams
  • Menus
  • Model Options
  • Creating Symbols and Objects
  • Auto Routing
  • Undo
  • Graphical Synonyms
  • Contextual Menus
  • Object Lists
  • Display Preferences
  • Checking a Model

Übung 1

  • Domains
  • Data Items
  • Object Property Sheets
  • Opening Things
  • Working Environment
  • Workspaces
  • Names and Codes
  • What’s different about the CDM?
  • Suggested CDM Settings
  • Prettifying a Diagram

Übung 2

  • Drag and Drop
  • Working with Diagrams
  • Deleting Things
  • Notation
  • Finding Things
  • Link and Sync, and Dependencies

Modul 3 – Producing the Logical Data Model

  • Why Are Names and Definitions Important?
  • Workspaces, Projects and Folders
  • Working with Diagrams
  • Traceability Links
  • Applying Naming Standards
  • The Glossary
  • Model Generation
  • Identifiers
  • Reusing Attributes
  • Replications
  • Relationships
  • Inheritance / Subtyping

Übung 3

  • Extending the Metamodel
  • Copy by Generating
  • Sharing from Another Model
  • Linking with Business Analysis
  • Lists of Values

Übung 4

  • List Reports and Matrices
  • Impact Analysis
  • Exporting, Importing and Reporting

Übung 5

  • Spelling
  • Utilising the Repository
  • Handing Over Responsibility
  • Many Ways to do Things

Übung 6

  • Suggested LDM Settings
  • Description, Comment, Annotation
  • Modification Dates

Modul 4 – Producing and Working with the PDM

  • Creating and Generating PDMs
  • Naming Conventions
  • How Different is the PDM from the LDM?
  • Round-trip Engineering
  • Mapping Editor
  • Revising and Re-Generating
  • Changing Language
  • Denormalisation

Übung 7

  • PDM Settings

Übung 8

  • Compare and Merge

Übung 9

  • Dimensional Modelling in PowerDesigner
  • Packages

Klicken Sie hier für eine Angebotsanfrage oder um mit uns Ihre Anforderungen zu diskutieren.

 

Workshop: “Building the Data Model Pyramid with SAP Sybase PowerDesigner”  

Zusammenfassung:

In this fast-paced tutorial, learn how to construct a chain of three data models, conceptual, logical and physical, applying normalization and de-normalization techniques where appropriate.

Details:

PowerDesigner is the only data modelling tool with specialized support for all the levels of data model in the Data Model Pyramid.
In the case study you’ll see how PowerDesigner Projects enable you to visualise and manage your chain of models, including simple links to Requirements and to Business Rules.
We’ll also cover the role of the PowerDesigner repository, which provides facilities to support teamwork, change management, viewing and editing of models by non-specialists (via the web portal), and the management of common models and PowerDesigner resources via the Library. We’ll also examine the role that the PowerDesigner Glossary can play in managing naming standards.

licken Sie hier für eine Angebotsanfrage oder um mit uns Ihre Anforderungen zu diskutieren.

 

Workshop: “Take control of your database schemas with SAP Sybase PowerDesigner”

Zusammenfassung:

How do you create and update your database schemas? Do you use lovingly hand- crafted DDL, or data models? If you’re only using DDL, here’s how you can use PowerDesigner to take control of your schemas.

Details:

Learn how to create a PowerDesigner Physical Data Model from scratch or by reverse- engineering an existing design, control the DDL generated from the data model, check the validity of the model, and check the model against the database. Learn how the PowerDesigner repository supports your versioning strategy.

Klicken Sie hier für eine Angebotsanfrage oder um mit uns Ihre Anforderungen zu diskutieren.

TagCloud