Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
DQS Training
Rating: 4.4 out of 5(61 ratings)
289 students

DQS Training

Microsoft SQL Server Data Quality Services for Data Cleansing & Data Deduplication with Data Quality Client & SSIS tools
Created byVikas Munjal
Last updated 12/2024
English

What you'll learn

  • Creating Domains
  • Creating Knowledgebase
  • Data Cleansing
  • Data Deduplication
  • DQS Adminstration

Course content

4 sections20 lectures2h 52m total length
  • Introduction5:47
  • DQS Introduction8:56
  • DQS Terminologies7:31
  • DQS Architechture7:27
  • SQL Server and DQS Installation15:24

Requirements

  • Yes basic knowledge of Microsoft SQL Server and SQL Server Management Studio (SSMS)

Description

The topics which are covered in this online video training course on DQS are


DQS Introduction

DQS Terminologies

DQS Architechture

DQS Installation


Data Cleansing

Data Source used for Demonstration

Domains and Knowledge Base

Cleansing Project

SSIS Package for Data Cleansing


Data Deduplication

Matching Policies

Deduplication Project


Advanced DQS

Term Based Relations

Composite Domains

Creating Regular Expressions Rules in a domain

Domain DataTypes

Import Knowledge Base & Domains

Export Knowledge Base & Domains

Open Delete Rename Unlock Knowledge Base & Projects

Purpose of each DQS Databases

Backup and Restore DQS Databases

DQS Configurations

DQS Activity Monitor

Who this course is for:

  • Beginners who want to learn Microsoft Data Quality Services
  • It will be value addition skill for Microsoft BI developers
  • Consultants who want to take data cleansing tasks
  • IT Students who want to create one quick IT Project and submit to their college
  • One or two questions are asked about DQS in Microsoft SSIS Certification exams as well