Etl Testing: Essential Course For All Qa Professionals 2023

Get to know what is ETL Testing, Data Cleaning, Data Quality, Data Transformation Concepts with Examples.2023

What you’ll learn
ETL Testing: Essential course for all software testing professionals 2023
Understand the concepts of Business Intelligence Data warehousing.
Understand the concepts of Business Intelligence Data Analytics
Understand the concepts of Data Cleaning and Data Quality
Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Business Rules Testing, Negative Scenarios, Dependency Testing

Requirements
basics of software testing

Description
DW/BI/ETL Testing Training Course is designed for both entry-level and advanced software Manual testers. The course includes topics related to the foundation of Data Warehouse with the concepts, Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow, How to perform ETL Testing, ETL Testing Basic Concepts, Data Checks using SQL, Scope of BI/ETL testing and as an extra, you will also get the steps to run SQL Queries, ETL tools Scope specified in details for data manipulation, data cleaning, Data Transformation industry best practices.In this course you will learn the complete RoadMap what you need to learn to become a ETL Tester. Lots of People perform ETL Data validations with the help of Mapping sheets or simply perform data migration testing. But in ETL you can now perform without manual testing effort if you knows about Ms. Excel Advance features like conditional formatting, Power Query, Power BI, SQL Advance level. Then ETL Field is waiting for you.In this course following below topics covered with Real time examples:1. Introduction to Data warehouse2. Introduction to Power Query3. RoadMap how to become a ETL Testers4. How much time requires to become a ETL Tester5. Tools & Techniques how to become a ETL Tester

Overview
Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is ETL Testing

Lecture 3 ETL Testing Basics

Lecture 4 ETL Testing Process

Lecture 5 What is Data

Section 2: ETL Testing Concepts

Lecture 6 Types of ETL Testing

Lecture 7 How to create ETL Test Cases

Lecture 8 Types of ETL Bugs

Section 3: What is Data Quality

Lecture 9 What is data quality

Lecture 10 What is Data Transformation

Lecture 11 knowledge is Power

Lecture 12 Example of Data Transformations

Section 4: How to Become a ETL Tester

Lecture 13 How to become a ETL Tester

Lecture 14 Time framework to become ETL Tester

Section 5: Introduction to Power Query

Lecture 15 What is Power Query

Lecture 16 What is Data Transformation

Lecture 17 Data Types Hands on Transformation

Lecture 18 Custom Column Creation Transformation

Lecture 19 How to Apply if condition

Lecture 20 How to Fill Series

Lecture 21 How to Remove Delimeters

Section 6: How to Perform Descriptive Data Analysis

Lecture 22 Descriptive Data Analysis

Section 7: Final Hands-on ETL Assignments

Lecture 23 Final Hands on ETL Assignments

Section 8: Introduction to Database

Lecture 24 Introduction to SQL

Lecture 25 SQL Hands on Tasks

Anyone who wants to learn advance software testing services.