Course Description
DQS can help identify duplicate or invalid data entries and values while automatically correcting them. MDS enables data validation and rules to ensure consistency in your data. In this course, you'll explore both of these technologies.
Learning Objectives
Data Quality Services
- start the course
- list installation prerequisites
- install DQS
- add users to DQ roles
- describe identity analysis
Master Data Services
- install MDS
- implement MDS
- create models, entities, attributes, collections, groups
- define security roles
- import and export data in MDS
- create subscription views in MDS
Practice: Implementing DQS and MDS
- implement DQS and MDS in SQL Server 2014