ETL/Data-warehousing Testing
About This Course
ETL/Data-warehousing Testing
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
Learning Objectives
You can easily crack your interviews on ETL testing by keeping 3 to 4 years of experience
You can work on any project on ETL Testing
Student can learn complete overview on the tool
Requirements
- Basic idea on SQL
Curriculum
13 Lessons7h 33m