ETL Testing- Basic course for all QA professionals 2024

ETL Testing: Basic course for all QA professionals 2024, available at $49.99, has an average rating of 3.86, with 47 lectures, 2 quizzes, based on 135 reviews, and has 300 subscribers.

You will learn about ETL Testing: Essential course for all software testing professionals 2024 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 This course is ideal for individuals who are Anyone who wants to learn advance software testing services. It is particularly useful for Anyone who wants to learn advance software testing services.

Enroll now: ETL Testing: Basic course for all QA professionals 2024

Summary

Title: ETL Testing: Basic course for all QA professionals 2024

Price: $49.99

Average Rating: 3.86

Number of Lectures: 47

Number of Quizzes: 2

Number of Published Lectures: 44

Number of Published Quizzes: 2

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 46

Original Price: $27.99

Quality Status: approved

Status: Live

What You Will Learn

ETL Testing: Essential course for all software testing professionals 2024

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

Who Should Attend

Anyone who wants to learn advance software testing services.

Target Audiences

Anyone who wants to learn advance software testing services.

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 warehouse

2. Introduction to Power Query

3. RoadMap how to become a ETL Testers

4. How much time requires to become a ETL Tester

5. Tools & Techniques how to become a ETL Tester

Course Curriculum

Chapter 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

Chapter 2: How to Become a ETL Tester

Lecture 1: How to become a ETL Tester

Lecture 2: Time framework to become ETL Tester

Chapter 3: ETL With Python Hands on Transformation

Lecture 1: what is data transformation

Lecture 2: Introduction to Python Libraries

Lecture 3: How to install Python for ETL

Lecture 4: Introduction to Pandas library

Lecture 5: How to Load Dataset in Python ( Jupyter NoteBook)

Lecture 6: How to Identify Null Values in Source System

Lecture 7: How to Merge 2 Different Datasets

Lecture 8: How to Apply Filters on Datasets

Lecture 9: Pandas Library Cheat Sheet

Lecture 10: How to Delete the columns

Lecture 11: What is Data Frame

Lecture 12: How to select multiple columns

Chapter 4: Data Visualization after ETL Transformation

Lecture 1: How to Draw Plots after ETL Transformation

Lecture 2: How to Create Histogram Plot

Lecture 3: How to create Scatter Plot

Lecture 4: How to Create Box Plot

Chapter 5: Final Assignment ETL

Lecture 1: Google PlayStore Dataset Analysis

Chapter 6: Real Time ETL Testing Scenario

Lecture 1: ETL Testing Real Scenario

Chapter 7: ETL With Power Query Hands On Transformation

Lecture 1: What is Power Query

Lecture 2: What is Data Transformation

Lecture 3: Data Types Hands on Transformation

Lecture 4: Custom Column Creation Transformation

Lecture 5: How to Apply if condition

Lecture 6: How to Fill Series

Lecture 7: How to Remove Delimeters

Lecture 8: How to Append Multiple Sheets in One Excel Master Sheet

Chapter 8: Final Hands-on ETL Assignments

Lecture 1: Final Hands on ETL Assignments

Chapter 9: How to Perform Descriptive Data Analysis

Lecture 1: Descriptive Data Analysis

Chapter 10: Introduction to Database

Lecture 1: Introduction to SQL

Lecture 2: SQL Hands on Tasks

Chapter 11: What is Data Quality

Lecture 1: What is data quality

Lecture 2: What is Data Transformation

Chapter 12: ETL Testing Basic Concepts

Lecture 1: Types of ETL Testing

Lecture 2: How to create ETL Test Cases

Lecture 3: Types of ETL Bugs

Lecture 4: ETL Mapping Sheet Concepts

Chapter 13: Introduction to Functional Automation Tools

Lecture 1: Functional Automation Tools

Instructors

Asim Noaman Lodhi
Certified Google Partner, Digital Marketer, QA Consultant

Rating Distribution

1 stars: 5 votes

2 stars: 5 votes

3 stars: 10 votes

4 stars: 32 votes

5 stars: 83 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!