Ready to Learn More

MASTERING DATA MODELING

COURSE DESCRIPTION
What you will learn:

This 18-hour instructor-led course offers an in-depth look at data modeling. You gain hands-on experience in building a Data Model and will be better prepared to determine how to design and implement the best data structures through a formal process from the conceptual, logical, and physical phases of data modeling to support business processes.

COURSE OBJECTIVES

    At the end of this course, you should be able to:
  • How data modeling and data mapping are used to represent expert business knowledge
  • Develop a relational database design from a simple entity relationship diagram
  • Query, manipulate, and report on data stored using leading database
  • Create and maintain tables and views
    WHO SHOULD ATTEND?
  • Data Modelers
  • DBAs
  • Business Analyst
  • Project Managers
    REQUIRED PREREQUISITES
  • Understanding of entity-relationship modeling
COURSE CONTENTS
    MODULE ONE
  • The Value of Modeling
  • Data Modeling Concepts
  • Data Entity Types
  • Conceptual Data modeling for Business Requirements
    MODULE TWO
  • Entities, Attributes and Relationships
  • Cardinality and Domains
  • Normalization
  • Supertypes, Subtypes and their proper use
  • Integrating Data Models and Use Cases
  • Logical Data Modeling
    MODULE THREE
  • Creating physical models based on logical models
  • Reverse Engineering Databases
  • Creating DDL and DML
  • Working with Indexes and Views
  • Transforming XML Schemas
Note:

Enrollment is limited to 20 attendees.

The program course contents are delivered either only evening time or at the weekends or in combination of both.