Data Warehouse Testing Training

Available at our training facilities, in the cloud, or on-site at your location.

What makes our training special
  • 3 Delivery Options (in our NY office, in the Cloud, or Private class) more>>
  • All courses have Live Instructors more>>
  • Valuable reference books (course & lab books)
  • Certificate of Completion click to view>>

Course Title

QuerySurge Immersion

Course Code



4 days


$1,782 now only $1,495*

*Extended: Price valid until 02/29

Course Summary

This 4-day class combines all of RTTS' QuerySurge courses into an intensive session designed to accelerate your learning in this product.

The Data Warehouse and ETL Testing Fundamentals course is designed to familiarize business professionals in the Data warehouse and ETL space with the basics of testing and validating.  This course focuses on getting professionals the knowledge required in order to successfully test and validate data warehouses and ETL processes.

The Fundamentals of QuerySurge course is designed to provide a firm foundation in basic usage of QuerySurge. The course will cover creation and execution of data warehouse test scenarios.

The Introduction to Data Warehouse Testing using SQL course is designed to provide students with the foundation necessary for testing data warehouses. The course covers a basic testing methodology for data warehouses as well as SQL commands and syntax and how these apply to data warehouse tests.

The Advanced Data Warehouse Testing using SQL course is designed to provide students with advanced techniques necessary for testing data warehouses. The course covers advanced SQL transformations and the challenges these issues cause in testing a data warehouse.

Intended Audience
  • Manual Testers
  • Automation Engineers
  • Quality Assurance Analysts
  • Developers
  • Project Managers
  • anyone involved with providing software quality for data warehouses 
Course Objectives

At the end of the course, you will be able to:

  • Describe the purpose of a data warehouse and the ETL process
  • Determine an appropriate testing strategy
  • Understand a source-target mapping document
  • Describe an approach to test each business rule
  • Recognize the different testing methods
  • Determine appropriate sample sizes and data permutations
  • Explain the different data error types
    • Star Schema
    • Snowflake schema
    • Galaxy schema
  • Have knowledge of the different testing tools
  • Understand the importance automated testing
  • understand basic QuerySurge concepts
  • create and use query pairs
  • implement query snippets
  • setup and configure test schedules
  • understanding dashboard statistics
  • create and execute QuerySurge reports
  • understand data warehouse structures and architectures
  • implement a successful process for data warehouse testing
  • create basic queries to return data from a database
  • create queries to join data from multiple tables
  • utilize different filtering commands to narrow data results
  • make use of different aggregate SQL functions
  • manipulate and format data returned from queries
  • manipulate and format data returned from queries
  • convert data types for comparisons
  • utilize regular expressions for data comparisons
  • create and utilize subqueries
  • work with derived tables and inlined views
  • take advantage of advanced techniques for data warehouse testing
Course Outline

Registering 3+ people? Receive 10% off!
(No promo code needed)

Upcoming Course Schedule

Start Date: Apr 20th, 2020
Time: 9:30AM - 5:00PM Eastern
Location: New York, NY


Start Date: Jun 01st, 2020
Time: 9:30AM - 5:00PM Eastern
Location: In The Cloud, Web


Are you interested in learning more or have additional questions?
Please fill out the form below and we will gladly assist you.