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

SQL Server 2014    |    Intermediate
  • 11 videos | 1h 10m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
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

Course CRISC 2023: Data Classification
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Course Windows Administration: Windows Services, Devices, & Storage
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing & Implementing Dimensions
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
Course Establishing Quality Standards (2021 Update)
Rating 4.4 of 469 users Rating 4.4 of 469 users (469)
Course Data Literacy for Business Professionals
Rating 4.4 of 3271 users Rating 4.4 of 3271 users (3271)