There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
Description
Course Content
Description:
QuerySurge is a comprehensive course designed to teach students how to effectively use QuerySurge, a leading data
testing solution. This course covers all the essential concepts and techniques required to perform database and ETL testing using
QuerySurge. Students will learn how to create and execute tests, analyze test results, and troubleshoot common issues.
By the end of this course, participants will have the skills to confidently validate data quality and ensure the
accuracy of their data integration processes.
Key Highlights:
- Learn to use QuerySurge for data testing
- Perform comprehensive database and ETL testing
- Create and execute tests using QuerySurge
- Analyze test results and troubleshoot issues
- Ensure data quality and accuracy in data integration processes
What you will learn:
- Learning Outcome 1
Gain a solid understanding of QuerySurge and its features - Learning Outcome 2
Learn how to create and configure tests in QuerySurge - Learning Outcome 3
Perform data testing using QuerySurge and analyze test results - Learning Outcome 4
Troubleshoot issues and optimize data testing processes - Learning Outcome 5
Ensure data quality and accuracy in ETL processes
Session-1: About QuerySurge & Environment Setup
| 1. What is QuerySurge? |
| 2. Why we use QuerySurge? |
| 3. What we can achieve with QuerySurge? |
| 4. Download QuerySurge |
| 5. Install QuerySurge |
| QuerySurge Software |
| Class Notes |
| Assignment |
Session-2: QuerySurge Architecture & QuerySurge Component
| 1. QuerySurge Architecture |
2. QuerySurge Component:
|
| Class Notes |
| Assignment |
Session-3: Admin Application
| 1. Overview of Global Admin Application |
| 2. Create Project |
| 3. Create User |
| 4. Create Agent |
| 5. Assign User to Project |
| 6. Assign Agent to Project |
| 7. Manage Project |
| 8. Manage User |
| 9. Manage Agent |
| Class Notes |
| Assignment |
Session-4: Web Application
| 1. Component of Web Application |
| 2. Design Library |
| 3. Scheduling |
| 4. Run Dashboard |
| 5. Reporting |
| 6. Administration |
| Class Notes |
| Assignment |
Session-5: Design Library
1. QueryPairs
|
2. Reusable Query Snippets
|
3. Staging Queries
|
| Class Notes |
| Assignment |
Session-6: Scheduling
| 1. Create Test Suite |
| 2. Add Test Cases to Test Suite |
| 3. Schedule Test Suite |
| Class Notes |
| Assignment |
Session-7: Run Dashboard
| 1. Monitor Run Time Test Execution |
| 2. Copy Existing Test Suite and Execute |
| 3. Troubleshoot Failures |
| Class Notes |
| Assignment |
Session-8: Administration
| 1. Users & Agents |
| 2. Data Storage |
| 3. Configuration |
| 4. Artificial Intelligence |
| 5. Email Notifications |
| Class Notes |
| Assignment |
Session-9: End to End Automate ETL DWH Project
| 1. Create Source Connection |
| 2. Create Target Connection |
3. Create Test Cases [QueryPairs]
|
| 4. Create Metadata Testing Test Case |
| 5. Create Count Check Test Case |
| 6. Create Duplicate Check Test Case |
| 7. Create Null Check Test Case |
| 8. Create Direct Move Test Case |
| 9. Create Transformation Test Case |
| 10. Create All business Logic Test Cases |
| 11. Create Test Suite |
| 12. Schedule Test Suite |
| 13. Monitor Test Execution at Run Dashboard |
| 14. Generate Test Report |
| Class Notes |
| Assignment |
With 18 years of experience in the IT industry, our team of experts has established itself as a trusted authority in trending technologies.
Important Links
Packages - Live Sessions
Copyright © 2025