Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Project on Data Warehouse / ETL Testing
Rating: 4.0 out of 5(31 ratings)
223 students

Project on Data Warehouse / ETL Testing

Data Warehouse/ ETL Testing
Created byBlismos Academy
Last updated 4/2024
English
English [Auto],

What you'll 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

Course content

3 sections • 46 lectures • 5h 43m total length

  • Introduction to Project5:44
  • Pre Requisites Project2:55
  • What is SQL Server ?4:43
  • Branch Table Preparation Source and Target10:13
  • Branch Table with User Interface7:44

    Learn to create database, schema, and table in SQL Server using the graphical user interface, including import wizard steps, data type mapping, and setting a primary key.

  • Loading all the Tables Preparation11:41

    Load eight tables source and target schemas in sql server, creating and populating customer, account, and payment tables with staging data, enforce referential integrity via foreign keys for etl testing.

  • Branch Table Testing Approach5:20

    Explore branch table testing in an ETL project by validating metadata, counts, nulls, duplicates, and transformations between source and target tables using the mapping document and SQL Server stored procedures.

  • Branch Table - Meta Data Check8:34

    Learn to perform a metadata check for a branch table by validating column names, data types, and lengths against the mapping document using sp_help and information_schema.

  • Branch Table - Count Null Duplicate Hands-On7:19

    Practice count, null, and duplicate checks on branch tables from source staging to data warehouse to verify record preservation and primary key integrity in an ETL workflow.

  • Branch Table - Transformation Validation Hands-On15:03

    Apply branch table transformation validation by executing one-to-one mappings, such as removing spaces, and compare transformed source data with the data warehouse target to detect defects.

  • Branch Table - Columns with Asis Mapping Hand-On8:59

    Validate one-to-one as-is mapping from source to target in data warehouse ETL testing by comparing address and city columns using A minus B and join methods to detect defects.

  • Customer Table - Metadata Check Hands-On7:29
  • Customer Table - Count Null and Duplicate Check Hands-On3:53

    Verifies ETL quality by performing count checks, null checks, and duplicate checks on the customer table, ensuring source and target records align and primary key integrity remains intact.

  • Customer Table Transformation1 Hands-on16:29
  • Customer Table Transformation2 Hands-on8:44
  • Customer Table Transformation3 Hands-on5:47
  • Customer Table Validation for Columns without Transformation5:03
  • Accounts Table - Meta Data Check5:45

    Perform metadata validation for the accounts table in etl testing by comparing source and target metadata to the mapping document, covering column counts, data types, lengths, and constraints.

  • Count Null Duplicate Check Hands-On4:02
  • Accounts Table Transformation111:10

    Validate accounts table transformations by left padding to ten digits using replicate and write functions, then compare source and target results to identify defects.

  • Accounts Table Transformation211:29
  • Accounts Table Transformation36:22

    Validate the account type transformation by mapping yes to savings and c to current, using source and target comparisons and case statements to ensure correct ETL results.

  • Accounts Validation for the Non transformed columns3:47
  • Payments Table Transformation Validation for both the columns16:37
  • Payments Table Validation for Non Transformed Columns4:12

    Validate non transformed columns in the payments table by comparing source and target values for one-to-one mappings, and use target minus source to spot missing or extra records.

Requirements

  • You need to have knowledge in SQL Server and MySQL

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

Who this course is for:

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

Report abuse