Course 50595A: Master Data Services with SQL 2008 R2

Audience(s):IT Professionals
Technology:Microsoft SQL Server
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:3 days

First published:

02 March 2012
About this course
Organizations need to work from reliable information. Ensure that the integrity of information and consistency of data is constant across different applications with help from Microsoft SQL Server 2008 R2 Master Data Services. Master Data Services is a new and powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable.
Audience profile
This course is intended for SQL Professionals, Business Intelligence Developers, Data Analysts and Data Stewarts and project managers that need to learn how to utilize Master Data Services.
At course completion
In the parlance of my beloved Marine Corp, you will go from raw recruit to Marine Rifleman. (God bless the Marines!) Or in the business world you will be at a mid-level of competence in MDS. You should be able with practice to get to expert on your own with experience. Yes Bunkie you have to work!
Course details
Course OutlineModule 1: Master Data Management
This module walks through an overview of the concepts involved in Master Data Management, the challenges involved and proposed solutions.
  • What is Master Data Management?
  • The Need for Master Data Management
  • Data Quality
  • Operational and Analytical Master Data Management
  • Master Data Management Architectural Patterns
  • Master Data Management Team
What you will get out of this module:
  • An overview of the Master data Management
  • An understanding of challenges
  • The benefits of implementing a solution
  • An examination of the various competing architectures.
  • Guidelines on the team roles
Module 2: Microsoft Master Data Services Overview
In this module you will gain the knowledge that is key to working within MDS. A clear understanding of the terms such as Entity, Member and Attribute etc. and how they relate to each other will allow you to develop a MDS system.
  • Master Data Services Architecture
  • Master Data Services Key Terms
  • Master Data Services Web Interface
  • Master Data Services SQL Data Base
  • Installing Master Data Services
  • Creating the Master Data Services Database
  • Initial Configuration
Lab : Microsoft Master Data Services Overview
What you will get out of this module:
  • An appreciation of the Architecture
  • An understanding of the key terms
  • The relationships between the objects
  • The installation requirements
  • Familiarization of the MDS Web Interface
Module 3: Understanding Data Models
The Model of the data is the key to success. In this module you will learn to design your data model then how to implement that design.
  • Modeling Concepts
  • Modeling Guidelines
  • Building a Model
  • Deploying a Model
  • How to Step by Step
Lab : Understanding Data Models
What you will get out of this module:
  • Working knowledge of Data Models
  • Model Development Guidelines
  • Model Development Major Steps
  • Implementation of a Module
Module 4: Importing Data
In this module we will review the considerations for loading data into the models. We will examine the staging tables and stored procedures that may be utilized for loading data.
  • MDS Staging Tables
  • Creating New Members
  • Creating New Collections
  • Adding Members to Collections
  • Updating Member Attributes
  • Importing the Data
  • Validating the Model
  • Error Conditions
Lab : Importing Data
What you will get out of this module:
  • How to manually load data into modules
  • How to created new Members and attributes with SQL
  • Loading data via the staging databases
  • An understanding of the functionality of the staging tables
  • The error conditions that may occur
Module 5: Version ManagementLessons
  • Understanding Versions
  • Version Statuses
  • Version Validation
  • Version Flags
  • Ancestry
  • Validating Versions
  • Locking, Unlocking and Committing Versions
Lab : Version Management
What you will get out of this module:
  • The need for Versions
  • Knowledge of a Version Status
  • How to use a Version Flag
  • Viewing A Version’s Ancestry
  • How to Lock, Unlock and Commit a Version
Module 6: Business RulesLessons
  • Business Rules Overview
  • How to Create A Business Rule
  • Business Rules Interface
  • Rule Expressions
  • Conditions and Actions
  • Using SharePoint Workflows
Lab : Business Rules
What you will get out of this module:
  • Understanding of Business Rules
  • How to code a Business Rule
  • Work with the Web Interface
  • How to create an Expression
  • Integrate SharePoint into the path of the workflow
  • Invoking complicated workflows through the use of SharePoint
Module 7: Master Data Services SecurityLessons
  • Master Data Services Security Overview
  • Users and Groups
  • Administrators
  • Permission Levels
  • Best Practices
Lab : Master Data Services Security
What you will get out of this module:
  • This module will demonstrate the security of Master Data Services
Module 8: Publishing DataLessons
  • Subscribing Systems
  • Subscription Views
  • Formats
  • Creating Views
  • How Subscribing Systems can Extract Data
Lab : Publishing Data
What you will get out of this module:
  • How to use Publish Data
  • How to Create a Subscription View
  • An understanding of Formats
  • How a subscribing system can extract data.
Module 9: Master Data Services and Web ServicesLessons
  • Using Web Services to Interface with Master Data Services
  • Creating the Web Service
  • Errors in the Web Service
Lab : PerformancePoint Services
What you will get out of this module:
  • How to use Web Services to Interface with Master Data Services
Additional Reading
To help you prepare for this class, review the following resources:
  • Master Data Management and Governess ISBN 978-0-07-174458-4
  • Enterprise Master Data Management A SOA Approach to Managing Core Information
Before attending this course, students should have:
  • A good idea of what direction their organization wants to go with Master data Services
  • A working knowledge of Microsoft SQL

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you