| Course Code: |
MQ 557 |
| Course Abstract: |
This course will be available in Quarter 2 of 2009
This core course provides a comprehensive understanding of using QTP as an automated functional testing tool for testing and manipulates databases. Participants will use QTP l to automate applications that use database information. They will 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. Attendees will also use disconnected recordset to increase the performance and avoid locks, and perform database checkpoints to static and dynamic data.
Note: All topics are supported by hands-on exercises based on real-life examples. |
| Audience: |
This course is designed for individuals who are 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. |
| Duration: |
2 days |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> Automate applications that use database information using QTP I
> Know relational databases (terms and types)
> Use ADO, ODBC, and ADO objects
> Use common actions as testers
> Perform database checkpoints |
| Course Topics: |
Introduction to Relational Databases
Connection strings, Tables, Stored procedures, primary key, foreign key, relationships
ODBC
Disconnected Recordset (ADOR)
Introduction to ADO.NET
ADODB object
Connection object
Recordset object
Command object
Database actions
Sorting, Filtering, Searching
Efficient Queries
Checking databases using custom checkpoints
Checking databases using database checkpoints |
| Prerequisites: |
First Steps Web Course or First Steps Windows Course; Scripting QTP Basic Course or basic VBScript knowledge is required. |