Description:
ETL Automation Testing course is designed to provide a comprehensive understanding of testing techniques in Extract,
Transform, Load (ETL) processes. This course focuses on automating the testing process for ETL systems, ensuring their
accuracy and reliability. Participants will learn various testing methodologies, tools, and best practices specific to
ETL testing.
Key Highlights:
- Introduction to ETL processes and testing
- Automating ETL testing using industry-leading tools
- Creating robust test cases and scenarios
- Performing data validation and integrity checks
- Implementing ETL testing strategies
What you will learn:
- Introduction to ETL Testing
This module provides an overview of ETL processes, their importance, and the challenges associated with testing ETL systems.
- ETL Testing Techniques and Tools
Participants will learn various testing techniques and tools used for automating ETL testing, including data comparison,
data profiling, and data quality analysis.
- Test Case Design and Execution
In this module, you will understand the process of designing and executing effective test cases and
scenarios for ETL systems.
- Data Quality and Integrity Checks
Participants will learn how to ensure data accuracy and integrity in ETL processes by performing data
validation, data cleansing, and error handling techniques.
- ETL Testing Best Practices
This module covers best practices and strategies for ETL testing, including performance optimization,
error reporting, and test environment management.
Session#1: About QuerySurge
What is QuerySurge |
QuerySurge Architecture |
Session#2: Download & Install QuerySurge
Download QuerySurge |
Install QuerySurge |
Login to QuerySurge |
Session#3: Components of QuerySurge
Web-Application [Global Admin & Web Application] |
MySQL Database |
Agents |
Session#4: Explanation of QuerySurge Components:
Global Admin - Web Application |
Application |
Agents |
Database [MySQL] |
Session#5: Global Admin
Create new Project |
Assign Users to Project |
Assign Agent to Project |
Session#6: Roles in Global Admin For Users
Session#7: Modules in QuerySurge-Web Application
Design Library |
Run Dashboard |
Administration |
Reports |
Session#8: About Design Library:
Query Pair |
Reusable Query Snippets |
Staging Queries |
Session#9: Scheduling:
Test Suite |
Schedule-Onetime |
Schedule-Recuring |
Session#10: Run Dashboard
Session#11: Administration
Users |
Agents |
Data Storage |
Connections |
Session#12: Reports
Session#13: Administration:
Create Excel File Connections |
Create SQL Server Connection |
Session#14: Design Library:
Create Query Pairs |
Execute Query Pairs |
Analyse Failures |
All Options in Query Pair |
Session#15: Reusable Query Snippets:
Create Reusable Query Snippets |
Use Reusable Query Snippets |
Session#16: Staging Queries:
Create Staging Tables |
Use Staging Tables in Query Pairs |
Session#17: Scheduler:
Create Test Suite |
Add Test Cases in Test Suite |
Run Test Suite from Scheduler |
Schedule Test Suite |
Session#18: Run Dashboard:
Analyze Realtime Test Suite Execution |
Copy and Run Test Suite from Run Dashboard |
Session#19: Reports:
Test Report - Scenario Detail Report |
Session#20: PROJECT [End to End Automation Testing] - Requirements:
Requirement Gathering |
Mapping Document |
Architecture Document |
Session#21: PROJECT [End to End Automation Testing] - Test Development:
Query Pair: Create All Test Cases |
Reusable Query Snippets: Create All Required Reusable Components |
Staging Queries: Create All Required Staging Queries |
Session#22: PROJECT [End to End Automation Testing] - Test Suite Schedule:
Create Test Suite |
Add All Test Cases to Test Suite |
Schedule Test Suite |
Session#23: PROJECT [End to End Automation Testing] - Real-Time Execution:
Watch Realtime Test Suite Execution |
Analyze Failures |
Session#24: PROJECT [End to End Automation Testing] - Test Report:
Generate Test Report - Scenario Detail Report |
After successful purchase, this item would be added to your Library.
You can access the library in the following ways :
- From Computer, you can access your library after successful login
- For other devices, you can access your library using this web app through browser of your device.
Review
me
star
star
star
star
star