Detailed Course Contents:
​
-
What is Data Ware House?
-
What is ETL?
-
Difference between OLTP and Data Warehousing
-
Data Extraction
-
Data Transformation
-
Data Loading
-
Data Marts
-
Introduction to ETL testing, life cycle of ETL Testing, database concepts, ETL in Business Intelligence, understanding the difference between OLTP and OLAP, data warehousing.
-
Introduction to RDBMS, Relational database concepts, distinction between database and data warehousing testing, integrity constraint
-
ETL Testing Scenarios (Hands-on)
-
Bug Identification
-
Usage of Sql for automating the process
-
Auditing count of records
-
Validation of data and identifying issues
-
Meta Data
-
Performance Testing (ETL, Query)
-
Volume Testing
-
Reports and Cube Testing, scope of Business Intelligence Testing.
-
The data warehouse workflow, ETL Testing scenarios, ETL Mapping, Data Warehouse Testing, Data Mismatch & Data Loss Testing.
-
Introduction to various testing scenarios, structure validation, constraint validation, data correctness, completeness, quality, data validation, negative testing.
-
Using SQL for checking data, understanding database structure, working with SQL Script
-
Detailed Project handson(end to end testing demo)
​