Training Course

Data Integrity Specialist

Prerequisites & Requirements

The following are prerequisites, and are required on the machine used for training to be able to complete this course.

  • MS SQL Server (2014+)
  • Adventure Works 2014 Database
  • DB Browser for SQLite and SQLite Driver (32 and 64 bit)
  • MS SQL Server Management Studio
  • Basic knowledge of SQL (to generate SQL/SQLite queries) is also required to successfully complete the course

Core Training

The Data Integrity Specialist training will equip specialists with the necessary practical knowledge to test at all key stages of the BI process.

  • Prerequisites: General IT knowledge and basic knowledge of SQL
  • Learn how to use Tosca to quickly test your BI process
  • Instructor-led training
  • Practical experience with Tricentis Tosca

What is Data Integrity Specialist?

Data Integrity Specialist is an introduction to the principles of data warehouse (DWH) / Business intelligence (BI) testing using Tricentis Tosca DI.

As well as core BI functionalities such as Database queries, File tests and using the Vital Checks Wizard, you will also learn the basics of test automation within Tricentis Tosca, allowing you to create basic automated TestCases as well as expand your knowledge to fully test the BI process.

By the end of the course, you will have the understanding to test at all the key stages of the BI process.

What skills will you have upon completing the course?

By the end of the course you will be able to automate a basic HTML TestCase, execute database queries, run pre-screening file tests, use the Wizard for both Vital Checks and Field Tests, run dataset comparisons and use the parallel execution functions.

Instructor-led Training

The Instructor-Led Training is especially suitable for groups whose main focus is to become highly proficient users of Tricentis Tosca and Business Intelligence in very short time period.

Delivery method

  • Instructor-led classroom training
  • Learning material is provided online
  • 2 days of classroom training*
    * Classroom training is limited to a group size of max. 10 students

Prerequisites

  • General IT knowledge

Language

  • Instructor-led training delivery: English or German
  • Courseware: English