Relational Technology International

Database design & Services organisation

Data Modeling

Practical Data Modeling – A practical three days workshop course with industry experienced tutors  

This course is ideal for those who wish to understand a practical model for database design.

Anyone from beginner to an experienced programmer or business analyst will benefit.

This course is often used to enhance departmental understanding and business analysis within an organisation.

No specific experience is assumed.

Fees: $1,950 + GST

Objectives

At the end of the course, students will be able to

  • analyse an enterprise or business area, identifying data components and relationships among them
  • model data for an enterprise and represent it via entity-relationship diagrams
  • validate the model using normalization
  • understand design tradeoffs among flexibility, performance, ease of use, and cost
  • understand considerations for the physical database design

 

Topics

This course presents a practical model for database design. It teaches how to represent a real-world situation, capturing world objects and behaviors in a database. Course examples and exercises drawn from realistic applications providing students with exposure to all components of the model.

  • Basic principles
  • Relationship types
  • E-R diagrams and how to read them
  • Keys and how to choose them
  • Normalisation
  • Role models
  • Dealing with missing data
  • Redundancy
  • Sub-Entity modeling
  • Conversion of data models to database designs

Course Dates and Registration

For the full list of dates and courses please see the training schedule 

To register your interest please fill the Training Registration Form and one of our training consultants will call you to discuss your needs