• Home
  • Microsoft SQL Server 2012
    • Latest Release Info
  • Microsoft SQL Server 2008 R2
    • Latest Release Info
    • Collection Weights
  • Resources
    • General Resources
    • Feature Resources
  • Master Data University
  • Contact
Picture
Profisee MDM Education Series
Profisee is proud to sponsor this site and offer their Microsoft SQL Server 2012 online training courses for FREE to MDS User.com users. Registration is open to everyone, but corporate MDS customers and prospective MDS customers can fill out the following form to request a coupon for 100% off of each of the two Master Data University courses (regularly $549.95 each) described below.

MDS1001: End-user Training

 
 
Online Course Availability   6 Months (180 days) course availability with an expected completion time of about 7 hours.
 
Prerequisites   Basic proficiency with PCs and corporate master data.
 
Who Should Register   Financial Analysts, Functional Managers and IT Professionals
 
Content   Through a combination of online video lecture, demonstration, and self-paced practice, MDS1001 students learn the basic functions of the Microsoft MDS Explorer as well as how to work with Version Management. The Explorer allows end-users to maintain the members in a master model—entities, hierarchies, collections and related members and attributes.
 
Benefits   Students will attain the skills necessary to effortlessly manage master data models and hierarchies in one centralized location for all subscribing systems.
 
Course Tuition   $549.95 (corporate customers see discount form above)
 
MDS1001 is broken down into seven chapters. This allows the student to pace themselves as necessary, thus ensuring that they understand each concept as well as the functionality of the Explorer and Version Management areas within the Microsoft SQL Server 2012 product.

Chapter 0: Course Introduction

  • Course introduction
  • Objectives and expectations
  • MDS overview


Chapter 1: MDS Installation

  • Database & web application requirements
  • The objectives and expectations of the class
  • Product overview


Chapter 2: Explanation of the Environment

  • MDS architecture
  • Administrative overview
  • MDS terminology and concepts
  • MDS application basics


Chapter 3: Managing Entities

  • Entity member types
  • Attributes and types
  • Hands-on exercises managing entity members & attributes


Chapter 4: Managing Hierarchies

  • Hierarchy functionality and types
  • Hierarchy modeling
  • Hands-on exercises managing hierarchies 


Chapter 5: Creating Collections

  • The purpose and role of collections in MDS
  • How to use collections for ad-hoc analysis
  • Hands-on exercises managing collections 


Chapter 6: Version Management

  • Versions & the version control model
  • Hands-on exercises managing the version lifecycle
 

master data university Register for
Master Data University

 

MDS1002: Admin Training

microsoft mds  
 
Online Course Availability   6 Months (180 days) course availability with an expected completion time of about 10 hours.
 
Prerequisites   MDS1001 or demonstrated Microsoft MDS product skills and knowledge.
 
Who Should Register   System Administrators and Master Data Model Administrators
 
Content   Through a combination of online video lecture, demonstration, and self-paced practice, MDS1002 students will understand the concepts behind the application and gain an in-depth knowledge of all the administrative functions. MDS1002 students will also learn how to administer and maintain their product environment, including modeling guidelines, the initial data import, application security, and exporting data for subscribing systems.
 
Benefits   Students will attain the skills necessary to apply best-practice master data management principles to the product's centralized repository.
 
Course Tuition   $549.95 (corporate customers see discount form above)
 
MDS1002 is broken down into seven chapters. This allows the student to pace themselves as necessary, thus ensuring that they understand the structural concepts of System Administration, Integration Management, Business Rules, and Security within Microsoft SQL Server 2012.

Chapter 0: Course Introduction

  • Course introduction
  • Objectives and expectations
  • MDS overview


Chapter 1: MDS Installation

  • Database & web application requirements
  • The objectives and expectations of the class
  • Product overview


Chapter 7: Modeling Guidelines

  • Concept overview of model components
  • The recommended process for developing models
  • Model development best practices


Chapter 8: Model Building

  • The master data model and relationships
  • Using entities as attributes
  • Maintaining master data models and objects
  • Hands-on exercises and real-world scenarios creating a master data model from scratch


Chapter 9: Integration Management

  • Populating staging tables & importing data
  • Hands-on exercises importing data into MDS
  • Data export and subscriptions
  • Hands-on exercises building subscription views


Chapter 10: Business Rules

  • Using rules to define, validate and verify data
  • Business rule design and application
  • Validation issues and notifications
  • Hands-on exercises creating business rules


Chapter 11: Security & Permissions

  • Security model and inheritance
  • Effective permissions (resolving assignments)
  • Hands-on exercises assigning user and group permissions
 

master data university Register for
Master Data University

 

Powered by Create your own unique website with customizable templates.