Data Quality Services (DQS) & Master Data Services (MDS)

SQL Server 2014    |    Intermediate
  • 11 videos | 1h 10m 56s
  • Includes Assessment
  • Earns a Badge
Likes 12 Likes 12
DQS can help identify duplicate or invalid data entries while automatically correcting them. MDS enables data validation and rules to ensure consistency in your data. Discover how to install and use both of these technologies.

WHAT YOU WILL LEARN

  • list installation prerequisites
    install DQS
    add users to DQ roles
    describe identity analysis
    install MDS
    implement MDS
  • create models, entities, attributes, collections, groups
    define security roles
    import and export data in MDS
    create subscription views in MDS
    implement DQS and MDS in SQL Server 2014

IN THIS COURSE

  • 3m 12s
    After completing this video, you will be able to list the installation prerequisites. FREE ACCESS
  • 8m 9s
    In this video, you will learn how to install DQS. FREE ACCESS
  • Locked
    3.  DQ Roles
    5m 49s
    In this video, you will learn how to add users to DQ roles. FREE ACCESS
  • Locked
    4.  Identity Analysis
    4m 19s
    After completing this video, you will be able to describe identity theft. FREE ACCESS
  • Locked
    5.  Installing Master Data Services
    6m 10s
    During this video, you will learn how to install Microsoft Data Sharing. FREE ACCESS
  • Locked
    6.  Implementing Master Data Services
    9m 21s
    In this video, you will learn how to implement MDS. FREE ACCESS
  • Locked
    7.  Models
    10m 37s
    During this video, you will learn how to create models, entities, attributes, collections, and groups. FREE ACCESS
  • Locked
    8.  Security Roles
    4m 44s
    Find out how to define security roles. FREE ACCESS
  • Locked
    9.  Importing and Exporting
    8m 24s
    Find out how to import and export data in Microsoft Data Sharing. FREE ACCESS
  • Locked
    10.  Subscriptions
    3m 58s
    In this video, learn how to create subscription views in Microsoft Data Server. FREE ACCESS
  • Locked
    11.  Exercise: Implement DQS and MDS in SQL Server 2014
    6m 14s
    Learn how to implement Data Quality Services (DQS) and Master Data Services (MDS) in SQL Server 2014. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Microsoft Certified: Azure Data Engineer Associate
Likes 260 Likes 260  
Book Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads
Course Microsoft Azure Fundamentals: Databases & Data Analytics
Likes 229 Likes 229  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Cleaning & Analyzing Data in Tableau Prep Builder
Likes 54 Likes 54  
Course Top 10 List Items
Likes 2025 Likes 2025  
Course Expert Insights on Adapting to Change
Likes 1331 Likes 1331