• Online, Self-Paced
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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.