2-Day Seminar and Workshop

Data Modelling Made Simple with PowerDesigner 16.5
You know what you need to do - learn how to do it with PowerDesigner

Click here for an in-house quote request or for further information regarding in-house training.

Overview
Do you already know the basics of data modelling and need to know how to do it in PowerDesigner? Perhaps you're an experienced data modeller working with PowerDesigner for the first time? Maybe you're using an old version of PowerDesigner and you need your skills brought up to date?

This course commences with a discussion of the different types of data model supported by PowerDesigner, followed by a detailed explanation of the PowerDesigner working environment. If you're familiar with other data modelling tools, you will realise that PowerDesigner operates differently - it has its quirks, and you'll see how to make use of them. You'll also know how to take advantage of the features that you may not have seen in other tools, such as the Dependency Matrix.

Once you've got to grips with the environment and facilities, you'll work through a detailed case study, creating a chain of data models from Conceptual to Logical to Physical, applying normalisation and de-normalisation techniques where appropriate. In the case study you'll see how PowerDesigner Projects enable you to visualise and manage your chain of models.

In addition, you'll see features added in version 16 – such as the Glossary and Reference models.

Learning Objectives

    This course will enable you to:

  • Use the right PowerDesigner data model for each task, by referencing the data model pyramid
  • Work effectively within the PowerDesigner environment
  • Create and manage Conceptual, Logical and Physical Data Models
  • Generate, merge and compare models
  • Reverse-engineer an existing database to create data models
  • Synchronise physical data models with databases
  • Communicate the content of your models
  • Use model extensions to enhance the information captured by PowerDesigner
  • Describe the importance of quality object names and definition

Seminar & Workshop Outline

  • The  Data Model Pyramid and PowerDesigner model types
  • Working in the PowerDesigner environment
    • A model is not just a load of symbols
    • Understanding Workspaces and Projects
    • PowerDesigner windows, views, browser, and toolbox
    • Creating Models
    • Working with diagrams
    • Object Names and Codes
    • Working with model objects
    • Options and Preferences
    • Replicas and shortcuts
    • Object Lists and List Reports
    • Dependency Matrices
    • Excel Imports
    • Attaching model extensions
    • Impact and lineage analysis
    • Checking Models
    • Drag and Drop
    • Names and Codes
    • Prettifying a Diagram
    • Inheritances / sub-typing
    • Exporting, Importing and Reporting
    • Utilising the Repository
  • Using the PowerDesigner Glossary and reference models
  • Linking with Business Analysis
  • Link and Sync, and Dependencies
  • Creating a Conceptual Data Model
  • Model Generation
  • Creating a Logical Data Model
    • Normalisation techniques
    • Inheritances
  • Comparing and Merging models
  • Creating a Physical Data Model
    • De-normalisation techniques
    • Triggers, Views and Procedures
  • Round-trip engineering
    • Reverse-engineering a database to create a PDM
    • Synchronising a database and a physical data model
  • Model management

Pre-requisites
This course has as prerequisite the Data Modelling Fundamentals course, or at a minimum an understanding of data modelling concepts.

Target Audience
Data Modellers, Data Architects and Database Developers, and anyone who needs to produce data models using PowerDesigner 16.5.

Client will Need to Provide
Access to a printer.

A workstation for each attendee or pair of attendees, with PowerDesigner 16.5 installed on each workstation.

Local modelling and naming standards (if applicable).

Duration
The standard duration is 2 days. However, there is an option to add a third day, either to increase the time available for learning, or to cover a selection of the following additional topics:

  • Sharing Resources
  • Creating Model Extensions
  • PowerDesigner in Data Governance
  • Sharing PowerDesigner Resources
  • User Profiles
  • Managing Naming Standards
  • Glossary approaches
  • Other types of PowerDesigner model
  • Running macros
  • Dimensional data models
  • PowerDesigner Web Portal

Speaker Biography

George McGeachie

George McGeachie has worked in the field of modelling and metadata since the 1980s, in the UK, Saudi Arabia and Germany. Over the years, he has become proficient with several well-known (and not so well-known) data modelling tools, and generally becomes the local power user of each tool. George is the co-author of "Data Modelling Made simple with PowerDesigner".

In-House Training
If you require a quote for running this course in-house, please contact us with the following details:

  • Subject matter and/or speaker required
  • Estimated number of delegates
  • Location (town, country)
  • Number of days required (if different from the public course)
  • Preferred date

Please contact:
Jeanette Hall
E-mail: jeanette.hall@irmuk.co.uk
Telephone: +44 (0)20 8866 8366
Fax: +44 (0) 2036 277202

Speaker: George McGeachie
George McGeachie

George McGeachie has worked in the field of modelling and metadata since the 1980s, in the UK, Saudi Arabia and Germany. Over the years, he has become proficient with several well-known (and not so well-known) data modelling tools, and generally becomes the local power user of each tool. George is the co-author of "Data Modelling Made simple with PowerDesigner".


Related Book
Click on image below for further information