India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Happy New Year 2015 Call Me Back

training courses

Data Modeling online training

  • Online Training : Available
  • Corporate Training : Available
  • United Global Soft provides Data Modeling online training

    In this class, get hands-on practice modeling requirements through entity relationship diagrams, supertypes and subtypes, and attributive and associative entities. You will learn to use logical data modeling to work directly with business users to accurately define requirements.

    What You'll Learn
    • How logical data models relate to requirements
    • Identifying entities and attributes
    • Determining relationships and business rules
    • Data integrity through normalization
    • Learn to create use data models.
    Who Needs to Attend

    Systems analysts, business analysts, IT project managers, associate project managers, project managers, project coordinators, project analysts, project leaders, senior project managers, team leaders, product managers, and program managers

    Prerequisites
    • Business Analysis Essentials
    • Requirements Development, Documentation, and Management
    • Use Case Modeling
    Introduction to Data Modeling
    What is a Data Model.
    Data Modeler Role
    • Business Requirement Analysis
    • Development of Data Model
    • Reports
    • Review
    • Creation of Database
    • Support and Maintenance
    Components of a Data Model
    Data Model Methodologies
    Entity-Relationship Model
    • Data Modeling as Part of Database Design
    • Steps In Building the Data Model
    • Identifying Data Objects and Relationships
    Read the documents provided by Trainer & google.
    Data Modelling Methodology
    • Logical Data Modelling.
    • Physical Data Modelling
    • Logical vs Physical
    • Relational Data Modelling
    • Dimensional Data Modelling
    • Relational vs Dimensional
    • Slowly Changing Dimensions
    • Identifying and Non-Identifying relationship
    • Many2Many relationship and Transform
    • Supertype & Subtype relationship
    What is Schema
    Schemas in Data warehouse
    • Normalization Concepts (1nf, 2nf, 3nf)
    • Third normal Form
    • Star Schema and its Transformation Restrictions
    • Snowflake Schemas

    • Dimensional Modeling for Data Warehouse
    Reports
    • Data Modelling Report
    • Logical Data Model Report
    • Physical Data Model Report
    Read the documents provided by Trainer & google.
    Erwin Features
    • Forward Engineering
    • Reverse Engineering
    • Complete Compare
    • Reoprts Generation
    • Data Model Versioning
    • Overview of all the features
    Indexing and Partitioning Concepts using SQL Sever as a DB
    Data Process and Managament
    • Data Profiling and Data Quality
    • Reference Data Managament
    • Data Dictionary
    • Data Conversion Techniques
    Read the documents provided by Trainer & google.
    • One Business Scenario - Requirement will be provided by trainer, based on requirement student has to to convert the same requirement to model. Trainer will clarify all his/her doubts incase any while creating the model

    If you want to know more about Data Modeling Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com