SQL Server Master Data Services for Master Data Management
4.1 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,182 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Master Data Services for Master Data Management to your Wishlist.

Add to Wishlist

SQL Server Master Data Services for Master Data Management

MDM, SQL Server, Data Modeling, Data Integration, Data Quality, Data Management, Business Intelligence, Data Architect
4.1 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,182 students enrolled
Created by Siddharth Mehta
Last updated 5/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 4 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
02:40:01
+
Basics of Master Data Management
4 Lectures 33:25

This lecture covers course as well as author introduction.

Preview 04:50

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

Preview 12:25

This lecture covers the introduction to basics of Master Data Services

Master Data Services - Basics
06:40

This lecture explains architecture of Master Data Services with functionality.

Master Data Services - Architecture
09:30
+
Installing and Configuring Master Data Services
4 Lectures 19:03

This lecture explains complete installation of Master Data Services

Installing Master Data Services
05:12

This lecture explains different configurations options of Master Data Services

Configuring Master Data Services
09:09

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

Installing Sample Packages
04:26

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

Resources for Master Data Services Installation and Configuration
00:16
+
Master Data Services - Terminologies and Concepts
2 Lectures 18:19

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

Introduction to Master Data Manager and Master Data Services Concepts
13:32

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.

Master Data Services - Terminology and Resources
04:47
+
Data Modeling and Data Integration using Master Data Services
7 Lectures 39:13

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

Developing a model in Master Data Services
03:28

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

Developing Entities and Attributes in Master Data Services
09:23

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

Adding members in Master Data Services
05:30

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

Developing Domain-based Attributes in Master Data Services
05:13

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

Attribute Groups and Entity Dependencies in Master Data Services
05:39

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

Data Integration with Master Data Services Model
09:37

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

Resources for Data Modeling and Integration with Master Data Services
00:23
+
Data Management with Master Data Services
6 Lectures 40:24

This lecture covers Hierarchies and Collections in Master Data Services.

Hierarchies and Collections in Master Data Services
08:42

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

Business Rules, Data Validation and Notifications in Master Data Services
09:51

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

Master Data Services - Excel Add-In
04:47

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

Security in Master Data Services
06:14

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

Publishing data from Master Data Services
07:22

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

Model Deployment in Master Data Services
03:28
+
Summary
3 Lectures 10:29

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

Master Data Services Best Practices
06:25

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

Summary
03:03

Discount coupon of my other courses

BONUS Lecture - Discounts
01:01
About the Instructor
Siddharth Mehta
4.1 Average rating
451 Reviews
5,243 Students
7 Courses
Published Author, Microsoft MVP Alumni, Sr. Tech Arch

My name is Siddharth Mehta. I work in the role of a Senior Technology Architect with a multinational IT firm. I have career experience of more than 14 years in the IT industry working with multinational IT companies and Fortune 500 clients. 

Industry Experience

-|- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains

-|- I usually work as a lead architect for a portfolio of applications in web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other categories.

-|- In my present role, I remain responsible for Arch Design, Tech Stack selection, Infra design, 3rd party products evaluation and procurement, and Performance engineering. My primary specialty is Microsoft SQL Server and Microsoft Business Intelligence. I usually work with MS BI integration with cross technologies like Elasticsearch / Lucene, MongoDB, Sharepoint 2013 and 2010, jQuery based framework like Highcharts and GoJS, jQueryMobile, Bootstrap, iOS xCode framework, and many others.

Authoring Achievements

-|- I have authored more than 200 articles and tutorials collectively for online publications like mssqltips, sqlserverperformance, sqlservercental, techrepublic and others.

-|- I have authored / co-authored as well as reviewed books for print-media publication houses like Manning publication, Packt publication.

-|- I have also authored a whitepaper for MSDN Library titled: Bulk report generation using SSIS and SSRS 2008 R2.

Certifications

-|- TOGAF 9 Part I & II certified architect
-|- CITA-F certified architect
-|- HCAHD (Hortonworks Hadoop certified)
-|- MCSD.Net, and MCTS in SQL Server maintenance as well as Developing BI apps using SQL Server
-|- Certified Sr. Technology Architect as well as Digital Architect

Academics

Master of Science with major in Computer Applications and Information Technology