Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Master Data Services for Master Data Management
Rating: 4.0 out of 5(289 ratings)
2,573 students

SQL Server Master Data Services for Master Data Management

MDM, SQL Server, Data Modeling, Data Integration, Data Quality, Data Management, Business Intelligence, Data Architect
Created bySiddharth Mehta
Last updated 3/2019
English

What you'll learn

  • 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

Course content

6 sections26 lectures2h 39m total length
  • Course and Author Introduction4:50

    This lecture covers course as well as author introduction.

  • Master Data Management - Basics and Architecture12:25

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

  • Master Data Services - Basics6:40

    This lecture covers the introduction to basics of Master Data Services

  • Master Data Services - Architecture9:30

    This lecture explains architecture of Master Data Services with functionality.

Requirements

  • Familiarlity of working with at least one RDBMS like SQL Server or Oracle or any other RDBMS
  • A setup of Microsoft SQL Server 2016. Installation will be covered in the course.

Description

*** 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.

Who this course is for:

  • Students who want to stand out from the crowd and word in a niche area like MDM instead regular SQL development should consider pursuing this course.
  • Data Quality Analysts who intend to learn the implementation of MDM should consider pursuing this course.
  • Data Modelers who are familiar with data modeling, and want to take their skills to the next level should consider taking this course.
  • Students who are interested in Data Quality or Master Data Management practice should take this course.
  • Students who have no idea about the world of Master Data Manager / Data Quality practice can take this course