4.15 out of 5
4.15
117 reviews on Udemy

SQL Server Master Data Services for Master Data Management

MDM, SQL Server, Data Modeling, Data Integration, Data Quality, Data Management, Business Intelligence, Data Architect
Instructor:
Siddharth Mehta
1,714 students enrolled
Download three complete sample master data models with model as well as data.
Integrate enterprise data with Master Data Services for Master Data Management
Implement, Model, Develop, and Administer Master Data Services independently with confidence
Use web based as well as office based tools to work with Master Data Management
Learn SQL Server Master Data Services using latest version of SQL Server 2016

*** Top 2 Reasons to take this course ***

1) You get to learn a niche skill and ask questions directly to a Published Author, Microsoft MVP Alumni and a Senior Technology Architect with more than 14 years of experience who practices Business Intelligence, Data Analytics including Master Data Management for clients in real-world projects internationally.

2) After learning this course, you can add Master Data Services to your skills and attract recruiters to consider you for the job of a Data Modeler / Data Architect.

Course Description

SQL Server Master Data Services for Master Data Management is a comprehensive course on Master Data Management concepts as well implementation using Master Data Services.  The course includes samples data models with sample data for practice exercises and demonstrations presented in the course.

Anyone interested in establishing himself / herself in a specialized niche area like MDM, should consider pursuing this course. This course is seen as a big advantage skills by Database Development / Database Administration / Business Intelligence Professionals.

The course covers the below mentioned aspects of Master Data Management and Master Data Services.

  1. Master Data Management Concepts and Hub Architecture
  2. Master Data Services Installation and Configuration
  3. Concept development
  4. Implementation of all MDM constructs
  5. Enterprise Integration of Master Data Services with external systems
  6. Data Publishing and Deployment
  7. Security
  8. Best Practices.

Basics of Master Data Management

1
Course and Author Introduction

This lecture covers course as well as author introduction.

2
Master Data Management - Basics and Architecture

This lecture covers basics of Master Data Management as well as Master Data Management - Hub Architecture

3
Master Data Services - Basics

This lecture covers the introduction to basics of Master Data Services

4
Master Data Services - Architecture

This lecture explains architecture of Master Data Services with functionality.

Installing and Configuring Master Data Services

1
Installing Master Data Services

This lecture explains complete installation of Master Data Services

2
Configuring Master Data Services

This lecture explains different configurations options of Master Data Services

3
Installing Sample Packages

This lecture explains the installation process of three different sample models on Master Data Services

4
Resources for Master Data Services Installation and Configuration

This lectures lists different resources and links to references for installation of Master Data Services

Master Data Services - Terminologies and Concepts

1
Introduction to Master Data Manager and Master Data Services Concepts

This lecture covers introduction to the Master Data Manager web portal as well as terminologies and concepts of Master Data Services

2
Master Data Services - Terminology and Resources

This lecture provides links to reference material as well as definition of terminologies used within Master Data Services. Link to different functional areas of Master Data Manager web application is also provided in this lecture.

Data Modeling and Data Integration using Master Data Services

1
Developing a model in Master Data Services

This lecture explains the process of developing a new model in Master Data Services.

2
Developing Entities and Attributes in Master Data Services

This lecture explains the process of developing new entities and attributes in Master Data Services.

3
Adding members in Master Data Services

This lecture explains the process of developing new members in Master Data Services.

4
Developing Domain-based Attributes in Master Data Services

This lecture explains the process of developing new domain based attributes in Master Data Services.

5
Attribute Groups and Entity Dependencies in Master Data Services

This lecture explains the process of developing a new attribute groups as well as analyzing dependencies using Entity Dependencies in Master Data Services.

6
Data Integration with Master Data Services Model

This lecture explains the process of sourcing data from staging tables in Master Data Services.

7
Resources for Data Modeling and Integration with Master Data Services

This lecture contains links to reference material related to the chapters covered in this section for working with Master Data Services.

Data Management with Master Data Services

1
Hierarchies and Collections in Master Data Services

This lecture covers Hierarchies and Collections in Master Data Services.

2
Business Rules, Data Validation and Notifications in Master Data Services

This lecture explains development of Business Rules, configuring email Notifications, and Data Validation using Business Rules in Master Data Services.

3
Master Data Services - Excel Add-In

This lecture explains the approach of interacting with Master Data Services using Microsoft Excel Add-In for Master Data Services

4
Security in Master Data Services

This lecture explain the security framework in Master Data Manager web application

5
Publishing data from Master Data Services

This lecture explains the process of publishing data using Master Data Services

6
Model Deployment in Master Data Services

This lecture explains the process of creating as well as deploying model packages in Master Data Services.

Summary

1
Master Data Services Best Practices

This lecture explains some of the best practices or recommendations while working with Master Data Services

2
Summary

This lecture covers a brief summary of the different topics learned throughout the course.

3
BONUS Lecture - Discounts

Discount coupon of my other courses

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.2
4.2 out of 5
117 Ratings

Detailed Rating

Stars 5
30
Stars 4
40
Stars 3
36
Stars 2
9
Stars 1
2
c37f7b196f462ddb2a5374d862dcb0cc
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
4 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion