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

Advanced SQL Techniques for QuerySurge

Course Code

DW107

Length

1 day

Price

$495 now only $375*

*Extended: Price valid until 05/31

Course Summary

This one day course of lectures and hands-on training is designed to provide students with advanced techniques necessary for testing data warehouses using QuerySurge. The course covers advanced SQL transformations and the challenges these issues cause in testing a data warehouse.

Intended Audience
  • Data Quality Teams
  • Data Warehouse Analysts
  • Automation Engineers
  • Quality Assurance Analysts
  • Project Managers
  • anyone involved with providing software quality for data warehouses
Course Objectives

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

  • understand data warehouse structures and architectures
  • implement a successful process for data warehouse testing
  • create and execute more sophisticated transforation tests
  • 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
Prerequisites
  • Understanding of basic ETL testing processes
  • Basic SQL knowledge or have taken Introduction to Data Warehouse Testing using SQL
Course Outline

Data Warehouse Overview

  • Understanding Data Warehouse Architecture
  • Understand the challenges of Data Warehouse Testing
  • Understanding ETL Mapping Documents
  • Overview of Transformation Types
  • Data Warehouse Testing Comparison Methods

Calculated Fields Transformation Test

  • Aggregate Functions with Group By statement
  • Compare Calculated Source fields with grouping to target field.

Derived Fields Transformation Test

  • Discuss the differences between calculated and derived fields
  • Implement variations of SubQueries (Nested, Scalar, Correlated, Non-Correlated, Inline)
  • Compare a target field from a derived field from the source data.

Field Length Limits Transformation Test

  • Discuss DATA_LENGTH field from the ALL_TABS_COLUMN table.
  • Calculate maximum size of Field Mergers
  • Calculate maximum size of Field Splits
  • Validate maximum size of source data split into separate fields into the target database

Field Padding Transformation Test

  • String Padding Functions
  • SQL Regular Expression Functions
  • Verify erroneous source data has been padded correctly in target table

XML Transformation Test

  • Usage of the Extract function
  • Discuss relevance of XPATH
  • Database specific casting functions
  • Utilizing XMLSequence to form result set from XML content
  • Compare source tables to XML content in a target table

Transpose Transformation Test

  • Utilization of Self Joins
  • Compare transposed source data to a target table

Match and Merge Transformation Test

  • Utilization of Unions
  • Discuss differences between Union and Union ALL and how they are used for matching
  • Compare multiple source records

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

Upcoming Course Schedule

Start Date: Jun 07th, 2019
Time: 9:30AM - 5:00PM Eastern
Location: In The Cloud, Web

Register

Start Date: Aug 23rd, 2019
Time: 9:30AM - 5:00PM Eastern
Location: New York, NY

Register

Start Date: Oct 04th, 2019
Time: 9:30AM - 5:00PM Eastern
Location: In The Cloud, Web

Register

Start Date: Dec 19th, 2019
Time: 9:30AM - 5:00PM Eastern
Location: New York, NY

Register

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

=