ADO Data Suite

QTP0401

Overview

This core course provides a comprehensive understanding of using QTP as an automated functional testing tool for testing and manipulates databases.

You will use QTP l to automate applications that use database information.

Understand relational databases, databases terms and types.

Understand and use ADO, ODBC and ADO objects like connection, recordset and command.

Use common actions on databases as testers by searching, filtering and sorting recordset.

Using disconnected recordset to increase the performance and avoid locks.

Perform data base checkpoints to static and dynamic data.

Note: All topics are supported by hands-on exercises based on real-life examples.

Duration

2 days

Also
Recommended

XML Data Suite QTP0400

Intended
Audience

QTP Programmers that need to automate web or windows environments that use databases and considered as high risk testing.

Also QTP users that want to experience the world of testing databases

Professional
Prerequisites

First Steps Web QTP0200 or First Steps Windows QTP0100

Scripting QTP - Basic QTP0101 or

Basic VBScript Knowledge.

Technical
Prerequisites

Valid QTP license and Internet access.

Valid database ( Access, MSSQL or Oracle )

Career Track
Relevancy

QTP Java Programmer

QTP Web Programmer

QTP .NET/.NET Web Programmer

QTP SAP/SAP Web Programmer

Topics

a    Introduction to Relational Databases

a    Connection strings, Tables, Stored procedures, primary key, foreign key, relationships.

a    ODBC

a    Disconnected Recordset ( ADOR )

a    introduction to ADO.NET

a    ADODB object

o       Connection object.

o       Recordset object.

o       Command object.

a    Database actions

o       Sorting, Filtering, Searching

o       Efficient Queries.

a    Checking databases using custom checkpoints

a    Checking databases using database checkpoints