Learn the essentials of ETL Data Warehouse Testing and Data Quality Management through this step-by-step tutorial. This course takes you through the basics of ETL testing, frequently used Data Quality queries.

• In the end of the this section I am glad to inform you that you are aware now about:

•What is ETL

•What is ETL test

•What is ETL test tools

•How to create a test case

•When to test by eyeballing

•When to test by SQL query

•How to make a formula that can help you test faster

•How to test records counts by SQL query

•How to test null values by SQL query

•How to test duplicate values by SQL query

•How to test completeness for huge amount of data

Who should follow this course?

Students that want to learn the basics of ETL/ELT testing and Data Quality Management

Business Analysts and Data Analysts that would like to learn more about ETL/ELT testing, frequently used queries and practical examples

Software test Engineers and Managers considering to apply data quality standards within their organization

Requirements

Some basic knowledge of SQL

Database setup (PostgreSQL, Oracle, SQL Server etc.) is recommended.

The course consists of the following modules:

Introduction

What is ETL/ELT Testing and Data Quality Management?

Understand the Mapping document

frame the source and target queries

Perform the data validation.