Training Services

 

Contact Verticent

Call us at
800.251.8449

Data Modeling

1 day course / Services Rate * Hours
1 Day Course / $2,500 per Day (On-site)*
*Training at your facility for up to 10 students

 

Overview

This workshop has been designed to provide the participants with a basic understanding of the database models that are used throughout the Verticent applications.

Prerequisites

Fast Track to PowerBuilder course completed or equivalent experience.
Recommended

  • PowerBuilder development experience of six months or more.
  • Knowledge of the Verticent applications.

Who should attend?

This course is intended for PowerBuilder developers. At least one Senior Developer or Manager from each development site should attend this class.

Objectives

Upon completion of this course you should be able to:

  • Create good database construction
  • Understand the information that is contained in the major tables and columns
  • Understand how the tables and columns relate to the applications
  • Understand the relationships between the tables

Course Aim

This workshop will provide the participants with data models that are used throughout the Verticent applications. The relationships between the models and the functions of the tables and columns within the models will be explained.

Topics

Introduction

  • Definition of the term Data Model
  • The data models that are used in the Verticent suite of applications.

Distribution Data Model

  • Description of each major module within the application
  • Description and function of the tables and columns for each of the modules
  • Explanation of how these tables and columns relate to the application
  • The relationships between each of these tables

Financials Data Model

  • Description of each major module within the application
  • Description and function of the tables and columns for each of the modules
  • Explanation of how these tables and columns relate to the application
  • The relationships between each of these tables

Manufacturing Data Model

  • Description of each major module within the application
  • Description and function of the tables and columns for each of the modules
  • Explanation of how these tables and columns relate to the application
  • The relationships between each of these tables

SFA Data Model

  • Description of each major module within the application
  • Description and function of the tables and columns for each of the modules
  • Explanation of how these tables and columns relate to the application
  • The relationships between each of these tables

ERP Data Model

  • Description of the common shared tables in the ERP suite
  • Functions of the tables and columns in these tables
  • The relationships between these shared tables

Tools

  • Erwin
  • ISQL
  • Data Dictionary

 

For Information about attending Verticent training, please contact us today.