Data Modelling Fundamentals 2013

Data Modelling Fundamentals contains a complete explanation of data modelling concepts and terminology, along with techniques for producing solid relational and dimensional data models. This seminar and workshop is designed to give you a practical understanding of data modelling that can be applied to your current projects. Delegates will receive a copy of Steve Hoberman’s book, Data Modelling Made Simple.

Learning Objectives

Explain data modelling building blocks and identify these constructs by following a question-driven approach to ensure model precision
Describe relational and dimensional conceptual, logical, and physical data models
Build a relational conceptual data model and a dimensional logical data model
Demonstrate reading a data model of any size and complexity with the same confidence as reading a book
Validate any data model with key “settings” (scope, abstraction, timeframe, function, and format)

Delegates will learn:
• Data modelling concepts and terminology
• How to read a data model
• Steps to building a subject area model
• Logical data modelling techniques of normalization, abstraction, and dimensionality
• Physical data modelling techniques of denormalization, partitioning, views, and indexing