Data Modeling Training
See home page for upcoming courses.
Simsion & Associates has a high-regarded program of data-modeling training from introductory to master-class level based on the book Data Modeling Essentials.
Please note: Graeme Simsion no longer delivers these courses personally. Instructors are experienced professionals who have worked closely with Graeme Simsion in the past.
Typical programs include:
Graeme Simsion has recently completed heavily revised versions of Data Modeling Fundamentals (2-4 days) and Data Modeling Advanced Workshop (2-3 days) and has presented them both in Europe in a temporary return to data modeling teaching.. Karen Lopez (www.infoadvisors.com) has now presented both courses in the US, and Glen Bell will be responsible for delivery in the Asia-Pacific region. We would be happy to tailor similar courses for your organization.
Data Modeling Essentials
I believe two to four days is a suitable length for an in an introductory course. There is a limit to how much material people can absorb (particularly if they lack any experience in the field), and many courses I’ve seen have impressive outlines, but don’t really achieve learning goals. Our basic course is two days. If extending it to three days or more, we focus on giving the attendees more experience and confidence with the basic techniques rather than introducing more concepts.
Data modelling is a design skill, and people learn it best by doing it. Accordingly, we use a true “workshop” format built around exercises and case studies. We cover:
Part I – the Basics
What data modelling is and where it fits
Part II – Putting it Together
A framework for data modelling
This course broadly follows the structure of the first two parts of Data Modelling Essentials, Third Edition by Simsion (me) and Witt, and the book itself serves as course notes – a much more satisfactory and comprehensive “take away” package than Powerpoint notes.
Data Modeling Masterclass
Part I Introduction - Data Modeling in today’s world
Part II Tools and Techniques
Working with Generalization
Attributes and Columns
Keys and identity
Alternatives and Extensions to Notations
The Time Dimension
Part III Data Modeling from End-to-End
The Data Modeling Project
Understanding User Requirements
Logical Database Design
Physical Design and the Data Modeler
Part IV Enterprise Modeling and Data Management (Optional)