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

Introduction to SQL for QuerySurge

Course Code

DW106

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 the foundation necessary for testing data warehouses using QuerySurge.  The course covers several common transformation tests and the SQL sytnax required to retrieve the data in order to perform the test.

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 the most common transformation tests.
  • use ETL mapping documents to structure your tests.
  • understand the basic challenges to overcome when performing data warehouse testing.  
Prerequisites

Understanding of basic software testing processes

Course Outline

Data Warehouse Overview

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

One-to-One Mapping Transformation Test

  • SQL commands for returning data
  • Compare Source table to Target table

One-to-One Mapping with Filters Transformation Test

  • SQL commands for filtering data
  • Logical operators for data filtering
  • SQL commands for sorting data
  • Compare source table to a subset in target table

Join Mapping Transformation Test

  • SQL commands for joining data from different tables with matching records
  • SQL commands for joining data from different tables with matching record
  • Using an Alias
  • Compare records from a source in multiple target tables

Field Merging and Splitting Transformation Test

  • String concatenation
  • Utilization of SQL String functions
  • Compare multiple source columns to a single target column.

Type Casting with Formatting Transformation Test

  • Data Field Casting
  • String Type Conversion Functions
  • Date Math functions
  • Compare source columns to a target column where casting and formatting is required.

Translation and Lookup Transformation Test

  • Using Case statements
  • Utilizing Lookup tables
  • Decoding field values
  • Compare a source column where a transitioned target column

Statistical Tests

  • Aggregate Functions
  • Compare a target field that is comprised of an aggregation of a source field.
  • Data formatting SQL commands
  • Coalesce
  • Working with Patterns

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

Upcoming Course Schedule

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

Register

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

Register

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

Register

Start Date: Dec 18th, 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.

=