planmytrainings – Find soft skill trainers, IT trainers, Corporate trainers, freelance trainer jobs and training events

IT Archives - planmytrainings - Find soft skill trainers, IT trainers, Corporate trainers, freelance trainer jobs and training events

Focal Point Of Training

Training is a journey and not the destination. It is a process which involves the gaining knowledge, enhancing skills and change or inculcation of a desired behavior. Which eventually enhances the performance of employees. And thus leads to organizational development. But how many organizations understands the importance of training and its evaluation in the right way

It is vital for any organization to work on effectiveness of training before implementing one. This starts with correct planning. The planning includes the correct need identification. Trainings can provide immense benefits for employees as well as the organization, but only if they are carefully planned and well implemented. A clearly defined road map for any training not only helps the organization but also gives the motivation to learner. And later, this road map helps in evaluation of training outcome.

Any training would be related to one or more of below mentioned goals.

1. Enhance productivity of employees

2. Improved market performance of the organization

3. Boost the morale of employees by giving them the window of growth opportunities

4. Quick and smooth induction of new joiners.

5. Help meet the increased demand of market or specific customer demands related to quality and production standards

6. Quick and easier transition from current process to a new process or system in the organization.

It is important to identify which goal the training belongs to. An effective training starts from here. That is, the understanding of the focus area of the training. In most cases, it would be related to any one of above or any other specific goal of the organization. This process can be termed as ‘Focal point of training’.

Once the goal and training is decided, the right trainer is very important. Find your trainers here

Share

Data Modeling Training

Training outline

 

Participants will learn how to:

  • Create Entity Relationship Diagrams by identifying entities, attributes, relationships and constraints from a set of requirements
  • Normalize the Entity Relationship Diagram to third Normal form
  • Develop sound database designs by applying proven data modeling techniques
  • Engineer/Reengineer the data Models into and from relational database designs
  • Optimize the Relational Database Design for various functional/non functional requirements
  • How to work with database change requests and maintain existing databases with the help of tools.
  • Use ERwin Data Modeler

 

Data modeling topics covered:

  • Entities, Attributes and Relationships
  • Entity-Relationship Diagrams(ERD)
  • Data modeling notations(IE,IDEF1X)
  • Relationship types
    • Cardinality: 1:1,1:M,M:M
    • Optionality: Mandatory, Optional
    • Degree: Unary, Binary, Ternary
  • Modeling super-type & sub-types
  • Keys
  • Logical ó Physical transformations
  • Relational Model
  • Database Normalization
  • De-normalization and performance
  • Relational Algebra
  • Dimensional modeling
    • Dimensional modeling process
    • Fact and dimension tables
    • Star & snow-flake schemas
    • Slowly changing dimensions

 

ERwin Data Modeler functions covered:

  • Data Modeling and diagramming
  • Subject Areas
  • ER Diagrams for communication
  • Forward & Reverse Engineering
  • Synchronization between model ó database
  • Model Comparison
  • Reporting & Publishing
  • Domain dictionary
  • Bulk Editing
  • Working with objects: Tables, Columns, Constraints, Views, Indexes and other physical properties
  • User Defined Properties(UDP)
  • Standardizing & Reusing design elements
    • Naming Standards
    • Themes
  • Dimensional Modeling, Data Movement & Mapping
Share
Save Filter
×