After gaining some practical experience, data modelers encounter situations such as the enforcement of complex business rules, handling recurring patterns, dealing with existing databases or packaged applications, and other issues not covered in introductory data modelling classes. This intense, participative workshop provides approaches for many advanced data modelling situations, as well as techniques for improving communication between data modelers, business analysts, designer/developers, and subject matter experts.
There are experienced data modelers out there who somehow develop accurate and stable models that are actually used, often in non-typical or high-pressure situations. They get the job done without wasted effort, maintain the involvement and respect of the subject matter experts, and – worst of all! – make it look easy. Others modelers might have great technical skills, but fare poorly, maintaining tense relationships with content experts and developers who “just don’t get it,” and watching in dismay as their models are continually undone by “new” requirements.
What accounts for the difference? Magic? Luck? Better tools? No – it’s having a concrete set of frameworks, methods, techniques, scripts, heuristics, and other tools that they draw on to keep the process moving, with everyone engaged, even when complex, difficult situations are encountered. And that’s what we’ll cover in this full, but fun, two-day workshop – specific, repeatable techniques that you can use to drive your data modelling skills to the next level.
The Business-Oriented Data Modelling workshop by Alec Sharp is always evaluated by the attendees with an overall rating of 9 or better.
Three main themes will be explored:
Topics will be covered with a discussion of the issue, a review of techniques, guidelines and examples, a brief workshop exercise, and a group solution and debriefing. The emphasis is on maximizing the delivery of content while keeping everyone engaged – the workshop has recently been extensively redesigned to focus on the topics that data modelling professionals have continually rated as the most concrete and useful.
On workshop completion, participants will be able to spot various advanced situations (listed below in “Course Outline/Topics”) as they arise in their own modelling assignments, and deal with them efficiently and effectively.
Practical experience with data modelling, for instance, attending our Data Modelling workshop by Alec and/or six months or more of applying the techniques.
Specialist data modelers, data architects, and DBAs who wish to hone their skills. Also business analysts, application developers, and anyone else with substantial data modelling experience who needs additional skills.
At the top of this page you can download the PDF brochure of this workshop.
The seminars and workshops that we offer as In-house will take place right at your office. Well in advance we will discuss the room requirements, especially in the case of workshops. If your organisation has widely dispersed offices we can also decide to run the workshop in a venue of your choice that is centrally located.
“I learned a lot! Alec is a great teacher who knows how to keep his student on track. He backs up his training material with 'real life' stories. This helps a lot.”
“Great content to put data modelling on the map within your organization.”
“Very inspiring, based on experience, covering all aspects multidimensional.”
“High quality workshop, that combines a refreshing mix of education, inspiration and active involvement to get the message across. Alec is very approachable and makes a compelling case for the importance of data modelling as a critical skill & discipline in designing (or selecting) fit-for-purpose information systems, and provides numerous tips & tricks to help convince management of this fact. Highly recommended!”
“Great course, even for beginners such as me. I learned lots of new things during those 2 days, thanks to Alec's effective way of teaching.”
“Easily the best ER modelling course I've ever encountered or read.”
“Everything you always wanted to know about data modelling, but were afraid to ask.”
“I am leaving this workshop with much clearer view on my job and the possible issues I may expect, and with a basket of solutions and options already at hand.”
“Thanks Alec for inspiring us!”
Practically all of our seminars and workshops can be offered as an In-house course for your company exclusively. Sometimes as a shorter version or if need be as an extended version with more detail or exercises or with extra focus on specific topics that apply to your organization.