ETL/Data-warehousing Testing – Full Course

ETL/Data-warehousing Testing – Full Course

ETL Testing, Data-warehousing testing, SQL basics ,Data-ware concepts, validations

Dataware house concepts:

Datawarehouse vs Data marts

Facts

Dimensions

SCD(Slowly Chaging Dimensions)

Schema

OLAP vs OLTP

SQL Concepts:

Basic SQL(DDL DML)

Constraints

Operators

Joins

Aggregate Functions

Analytical Functions

ETL/Data-warehousing Testing

ETL Testing vs Manual Testing

Similarities and differences

Advantages of ETL Testing

Requirement of ETL Tester

Responsibility of ETL Tester

Testing Process

Test Artefacts

Test Management tool (JIRA)

Test Methodology(Agile)

Real time project

Project Architecture

Validations perform