Project on Data Warehouse / ETL Testing

Data Warehouse/ ETL Testing

Ratings: 4.04 / 5.00




Description

In this course you will learn about the Real - Time Project scenario on Data Warehouse/ETL Testing. As a part of Data Warehouse/ETL Testing Course, you will be exposed to real-life industry scenarios which give you in-depth understanding of Data warehousing/ETL Testing and its concepts. Project on Data Warehouse/ETL testing course will help you to become a successful ETL Testing expert.

This course includes the ETL Testing in both SQL Server and MySQL so that you can understand how both RDBMS works and its differences


This course includes:

☞ 2+hours of on demand videos

☞ Right blend of concepts and hands-on

☞ Certificate of completion

☞ Interview Questions to peek up


Project on SQL Server

  • Introduction to Project

  • Pre Requisties of Project

  • What is SQL Server?

  • SQLServer Branch Table Preparation Source and TargetS

  • SQLServer Branch Table with User Interface

  • SQL Server Loading all the Tables Preparation

  • SQL Server Branch Table Testing Approach

  • SQL Server Meta Data Check Branch Table

  • Sql server Branch Table Count Null Duplicate Hands-On

  • SQL Server Branch Table Transformation Validation Hands-on

  • SQL Server Hands-on Branch Table Columns with Asis Mapping

  • SQL Server Customer Table Metadata Check Hands-On

  • SQL Server Customer table Count NUll and Duplicate Check Hands-On

  • SQL Server Customer Table Transformation1 Hands-On

  • SQL Server Customer Table Transformation2 Hands-On

  • SQL Server Transformation Validation for Customer table

  • SQL Server Customer Table Validation for columns without transformation

  • SQL Server Accounts Table Meta Data Check

  • SQL Server Count Null Duplicate Check Hands-On

  • SQL Server Accounts Table Transformation1

  • SQL Server Accounts Table Transformation2

  • SQL Server Accounts Table Transformation3

  • SQL Server Accounts Validation for the Non transformed columns

  • SQL Server Payments Table Transfromation Validation for both the columns

  • SQL Server Payments table validation for non transformed columns

Project on MySQL

  • Introduction to Project

  • Pre Requisties of Project

  • Branch Table Preparation Source and Targets

  • Hands-On Preparations

  • Branch Table Testing Approach

  • Branch Table Meta Data Check Hands-On

  • Branch Table Count Null Duplicate Hands-On

  • Branch Table Transformation Validation Hands-On

  • Branch Table Validating columns without Transformation Hands-On

  • Customer Table MetaData count duplicate Hands-On

  • Customer table Handson Count NUll and Duplicate Check

  • Customer table Transformation validation Hands-On1

  • CustomerTable Transformation Hands-On Final

  • Transformation Validation for Customer table Trans3

  • Accounts Table MetaData Check Hands-On1

  • Accounts Table Count Null Duplicate Check Hands-On2

  • Accounts Table Transformation Validation Hands-On3

  • Accounts Table Transformation Validation Left pad Hands-on4

  • Payments Table Hands-On Validation

  • Payment table count Null duplicate check Hands-On

  • Payments Table Transformation validation Hands-On Final

What You Will Learn!

  • In this course you will able to work on Real Time Project
  • You can learn how to do ETL Testing on the Banking database
  • You will be able to do End-End ETL Testing using RDBMS
  • You will learn Meta Data Test, Constraint Test, Validations etc

Who Should Attend!

  • For ETL testers
  • Professionals
  • Anyone who needs to learn ETL Testing real time projects