Flash Sale: Save 15% on IT Training

closeClose

Data Modeling with PowerDesigner 16.5

  • Tuition USD $3,272 GSA  $2,430.23
  • Reviews star_rate star_rate star_rate star_rate star_half 1453 Ratings
  • Course Code DEV355-v015
  • Duration 4 days
  • Available Formats Virtual, Classroom

Skills Gained

  • Define glossary terms
  • Distribute model templates using the Library
  • Create and manage conceptual and logical data models
  • Generate and manage physical data models
  • Generate database creation scripts
  • Produce implementation details, such as triggers, procedures, and views
  • Reverse engineer an existing database to create physical, conceptual, and object-oriented models
  • Compare and merge models
  • Synchronize physical data models with databases
  • Manage large models and multiple designers using the PowerDesigner Repository
  • Create effective reports on PowerDesigner models
  • Define glossary terms
  • Distribute model templates using the Library
  • Create and manage conceptual and logical data models
  • Generate and manage physical data models
  • Generate database creation scripts
  • Produce implementation details, such as triggers, procedures, and views
  • Reverse engineer an existing database to create physical, conceptual, and object-oriented models
  • Compare and merge models
  • Synchronize physical data models with databases
  • Manage large models and multiple designers using the PowerDesigner Repository
  • Create effective reports on PowerDesigner models

Who Can Benefit

  • Business Analyst
  • Data Consultant / Manager
  • Database Administrator
  • Developer
  • Developer Consultant

Prerequisites

  • Essential:
       -Understanding of relational database concepts and database implementation issues.
       -Exposure to Entity Relationship (ER) data modeling and data normalisation.
  • Recommended:
       -NONE

Course Details

Course Content

  • SAP PowerDesigner
       -Identifying Key Components of the SAP PowerDesigner Environment
       -Creating a Project in the Workspace
       -Adding a Model to the Library
       -Creating a Glossary
  • Conceptual Data Models (CDMs) and Logical Data Models (LDMs)
       -Applying Model Properties and Options
       -Creating Entities and Domains
       -Creating Relationships in CDMs and LDMs
       -Creating Inheritance Links in a Model
       -Checking a CDM
  • Physical Data Models (PDMs)
       -Generating a PDM from Another Model
       -Implementing Data Integrity Checks in a PDM
       -Creating Views, Stored Procedures, and Triggers
       -Creating Indexes and Alternate Keys
       -Checking a PDM
       -Generating a Database from a PDM
       -Reverse Engineering from a Database
  • Model Synchronization
       -Comparing Models
       -Merging Models
       -Synchronizing Models
  • Model Organization
       -Creating and Modifying a Package
       -Creating a Diagram
       -Creating a Package from a Diagram
       -Creating a Dependency Matrix
  • Reporting
       -Creating a Report Template
       -Creating a Report
       -Generating a Report
       -Creating a Multi-Model Report
  • Impact Analysis
       -Creating Requirements
       -Creating a Link Between Models
       -Generating an Impact Analysis Model (IAM)
  • The Repository
       -Modifying Documents in the Repository
       -Setting up a Repository Workflow
       -Integrating Changes Across Repository Branches
       -Managing a Repository

Notes

  • The course material is available in English only

Course based on software release

  • SAP PowerDesigner

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Good job coping with the "new" training, of having video learning in a group setting.

Virtual delivery and coordination of the course was great. It had to be rescheduled several times by ExitCertified was always on top of things.

Great Class that will help as the state moves forward with the Cloud solution.

Course trainer was excellent, content was well organized. However, labs should be instructor lead versus on your own. Much time is wasted for newbees in getting acclimated to tool set, AWS environment, navigating and setting up things to complete tasks. This was my third class and I was barely able to finish most of the labs. (The first 2 classes I only finished one lab exercise for the 2 together.)

Excellent facilities, excellent staff.. and the coffee is good too! Thanks for helping to advance my career and the career of my colleagues!

4 options available

undo
  • Mar 29, 2021 Apr 1, 2021 (4 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Jun 22, 2021 Jun 25, 2021 (4 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Sep 7, 2021 Sep 10, 2021 (4 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
  • Dec 6, 2021 Dec 9, 2021 (4 days)
    Location
    Virtual
    Location Details
    Language
    English
    Time
    9:30 5:30 EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward