homeaboutcatalogueSpeakersnewsschedulecontact


Data Modeling Essentials:
Capture Business Requirements with Entity relationship modeling
Wayne Little

June 12-13, Vancouver, BC  $1095 CAD   Register

2-Days. Also available for on-site delivery. Find out more.

 

Course Overview
Good data models are the common language of business application development. They provide a conceptual framework and syntax for capturing and describing requirements about the key business entities and their interrelationships, along with the rules that govern the processes using them. They provide a shared understanding of the business between the customer and analyst, and facilitate communication and refinement of the requirements. They also enable continued communication between the analyst and technical professionals and, once transformed into a data base, serve as a foundation for business applications.

What defines a good data model? It’s one that communicates.

This workshop will provide a guided two-day journey in learning how to use data models as a powerful communication tool, while sharing practical tips, traps and checklists. The workshop introduces the concepts, terminology and process of entity-relationship modeling in a hands-on, business-oriented practitioner's perspective.

Special emphasis is given throughout the course in motivating the "why" as much as the how, so that the student will understand and be able to confidently apply the techniques learned. Read More.

Who Should Attend
This workshop is ideal for business analysts and application developers responsible for the analysis and design of any component of an application, including the database, application logic, or user interface. Business managers and professionals needing to understand how data modeling can be used to improve understanding, consistency and accuracy in business terminology, policy, and rules will also benefit.

Benefits and Learning Objectives
On workshop completion, participants will be able to:

  • Explain what a data model is, why they are so important, and where they fit
  • Translate user requirements into appropriate entity-relationship model design structures
  • Use both top-down and bottom-up approaches to get started creating a data model
  • Recognize and apply basic design patterns and understand the choices involved
  • Explain the meaning and steps to normalization in an "unforgettable" way, and follow those steps to get to a normalized entity-relationship model.
  • Read a data model, and use it to communicate with both technical and non-technical audiences
  • Follow a conversation in data-geek-speak (cardinality, surrogate key, etc.); note actually using the terms in conversation is optional.
  • Review data models for "goodness" by being able to apply simple validation techniques
  • Get the full course outline.

Plus, receive valuable takeaways. The workshop manual supplies full step-by-step instructions for creating good models along with valuable concept explanations and techniques used within the course.

Get information about the Instructor : Wayne Little

Read about other courses led by this instructor:

Register early and Save $100. Benefit from 'early-bird' pricing on courses.

June 12-13  Vancouver, BC             $1095 CAD   Register

Read information on payment, cancellation policy and course locations.

 

Download detailed course description



This seminar is available for on-site delivery. Find out More.

Home | About | Catalogue | Speakers | News | Schedule |Contact | SPC