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

SQL Server 2014    |    Intermediate
  • 11 videos | 1h 10m 56s
  • Includes Assessment
  • Earns a Badge
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

Book Practitioner's Guide to Data Science: Streamlining Data Science Solutions using Python, Scikit-Learn, and Azure ML Service Platform
Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
Book Oracle 19c AutoUpgrade Best Practices

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Mail & Alerts
Course Data Access & Permissions
Course Data Quality Projects