This seminar and workshop contains a complete explanation of data modelling concepts and terminology, along with techniques for producing solid relational and dimensional data models. This course is designed to give you a practical understanding of data modelling that can be applied to your current projects. It is for anyone who needs formal data modelling training. This includes those new to data modelling or in need of a refresher who need to be able to understand, build, or implement data models as part of their job.
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