Do you already know data modeling and want more? Take the Advanced Data Modelling Challenges Workshop! This two-day course will sharpen your data modeling skills by having you tackle over 20 data modeling exercises. The exercises are based on actual assignments, each containing essential data modeling tips and techniques.
This interactive workshop is for anyone who already knows modeling fundamentals and is seeking more advanced techniques. In this Masterclass, delegates will first apply a best practices approach to building and validating data models through the Data Model Scorecard™, a tool for verifying data model quality. Delegates will then focus on a collection of intermediate and advanced modeling techniques, including advanced normalization and enterprise data modeling. The final section contains guidelines used to gain consistency across data models in areas such as in abstraction and whether to star schema or snowflake.
Delegates will learn:
How to apply the Data Model Scorecard™
Advanced normalization rules and limitations of the logical data model
A value-driven approach to building the enterprise data model
Techniques for converting the logical into a physical design
Factors to consider in deciding whether to Star Schema or Snowflake
Three key questions to ask yourself before you abstract
When to use a surrogate key
Who should attend?
This course is for anyone who currently knows data modeling basics (or has previously attended the Data Modeling Master Class) and is seeking more advanced techniques. Roles include:
- Data Modeler
- Project Manager
- Team Lead
- Support Analyst
- Data Administrator
- Data Analyst
- Integration Specialist
Steve Hoberman taught his first data modeling class in 1992 and has trained more than 10,000 people since then, spanning every continent except Africa and Antarctica. Steve is the author of ten books on data modeling, including the bestseller Data Modeling Made Simple.
His latest book, Data Modeling for MongoDB, presents a streamlined approach to data modeling for NoSQL solutions. One of Steve’s frequent data modeling consulting assignments is to review data models using his Data Model Scorecard® technique.
He is the founder of the Design Challenges group, Conference Chair of the Data Modeling Zone Conference, recipient of the 2012 Data Administration Management Association (DAMA) International Professional Achievement Award, and highest rated workshop presenter at Enterprise Data World conferences in 2014 and 2015.
For more information on Steve, please see stevehoberman.com.
This course assumes no prior data modeling knowledge and, therefore, there are no prerequisites. This course is designed for anyone with one or more of these terms in their job title: “data”, “analyst”, “architect”, “developer”, “database”, and “modeler”.
Meals and refreshments
The cost of the workshop includes breakfast, morning tea, lunch, and afternoon tea. Please email firstname.lastname@example.org if you have dietary requirements.
A discount is available for bookings of three of more registrations. Please email email@example.com for more details.