Data Warehouse ( ETL Test ) for Beginners.

Data Warehouse ( ETL Test ) for Beginners., available at Free, has an average rating of 4.09, with 14 lectures, based on 131 reviews, and has 3106 subscribers.

Free Enroll Now

You will learn about Understand the basics of ETL/ELT testing The importance of Data Quality within the Data Lifecycle Perform database tests using queries Perform the data validation This course is ideal for individuals who are Students who want to learn Source-to-target mapping validation with SQL queries. or Business Analysts and Data Analysts that would like to learn more about Data reconciliation. or Software test Engineers and Managers considering to apply data quality standards within their organization It is particularly useful for Students who want to learn Source-to-target mapping validation with SQL queries. or Business Analysts and Data Analysts that would like to learn more about Data reconciliation. or Software test Engineers and Managers considering to apply data quality standards within their organization.

Enroll now: Data Warehouse ( ETL Test ) for Beginners.

Summary

Title: Data Warehouse ( ETL Test ) for Beginners.

Price: Free

Average Rating: 4.09

Number of Lectures: 14

Number of Published Lectures: 14

Number of Curriculum Items: 14

Number of Published Curriculum Objects: 14

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Understand the basics of ETL/ELT testing

The importance of Data Quality within the Data Lifecycle

Perform database tests using queries

Perform the data validation

Who Should Attend

Students who want to learn Source-to-target mapping validation with SQL queries.

Business Analysts and Data Analysts that would like to learn more about Data reconciliation.

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

Target Audiences

Students who want to learn Source-to-target mapping validation with SQL queries.

Business Analysts and Data Analysts that would like to learn more about Data reconciliation.

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

ETL (Extract, Transform, Load) testing is an essential part of data warehousing to ensure the accuracy, completeness, and consistency of data in the data warehouse. In this course you will learn Source-to-target mapping validation where you can compare the source data after applying the transformation rules with the target data after ETL processing and Data reconciliation to validate the completeness and accuracy of data after ETL processing.

By comparing the source data after applying the transformation rules with the target data, we can ensure that the transformation logic is applied correctly and there are no data loss or data truncation issues.

? 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 test transformation logic

?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 Source-to-target mapping validation.

Business Analysts and Data Analysts that would like to learn more about Data reconciliation.

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

Requirements

Basic knowledge of SQL ( This course use DBeaver as s a free and open-source SQL client and database management tool).

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction: what is ETL / ETL Test

Lecture 2: ETL test tools

Lecture 3: How to create a test case

Chapter 2: Data Validation

Lecture 1: eyeballing validation

Lecture 2: Transformation Logic Validation

Lecture 3: Count record validation

Lecture 4: SQL query for records count

Lecture 5: Null value validation

Lecture 6: SQL query for null value validation

Lecture 7: SQL null value validation part 2

Lecture 8: Duplicate Data Validation

Lecture 9: SQL Duplicate Validation

Lecture 10: final Note

Lecture 11: Conclusion

Instructors

Nada Sharafuddin
IT Consultant

Rating Distribution

1 stars: 5 votes

2 stars: 9 votes

3 stars: 28 votes

4 stars: 43 votes

5 stars: 46 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!