Udemy

Data Warehouse ( ETL Test ) for Beginners and perform tests.

Learn the essentials of ETL Data Warehouse Testing and Data Quality Management through this step-by-step tutorial.
Free tutorial
Rating: 3.4 out of 5 (10 ratings)
352 students
30min of on-demand video
English
English [Auto]

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

Requirements

  • Some basic knowledge of SQL
  • Some basic knowledge Microsoft Excel

Description

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.

Who this course is for:

  • 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

Instructor

Nada Hassan Ahmed Sharafuddin
  • 3.7 Instructor Rating
  • 14 Reviews
  • 791 Students
  • 2 Courses

Experienced information system analyst, software and robot process automation developer with a demonstrated history of working in ICT sector. Worked with multiple information technology project teams and business partners  with a Master of Science ( Distinction grade by UK grade rate) focused in TECHNOLOGY MANAGEMENT from Staffordshire University. Good development/coding skill with Good understanding of business processes and Strong analytical and problem-solving skills.

Experienced information system analyst, software and robot process automation developer with a demonstrated history of working in ICT sector. Worked with multiple information technology project teams and business partners  with a Master of Science ( Distinction grade by UK grade rate) focused in TECHNOLOGY MANAGEMENT from Staffordshire University. Good development/coding skill with Good understanding of business processes and Strong analytical and problem-solving skills.

Top companies trust Udemy

Get your team access to Udemy's top 19,000+ courses