QTP – Accessing SQL Server for automation test needs

Here’s the script that will enable you to connect to SQL Server Database and carry out basic functional tests.

Enhance the script as you may deem fit to cater to your testing needs. All the best.

Database Testing – Need and How to?

Why Database testing is required?

It is important to test the DATA ACCESS layer, since it is the interface between the front end and the DB.

The traditional testing always focused on the FRONT END/ GUI and the DATA ACCESS layer was ignored.

SQL Query Optimization Techniques and Tips

SQL Query Optimization Tips

The most important part and parcel of a Database management system is the SQL. It will differ from product to product. Given below are some tips on how to write a well optimized query and avoid performance bottlenecks.

Primary verification of the SQL.

1)       The SQL query will need to be verified by two parameters

1. The SQL returns the appropriate results.
2. The SQL adequately addresses the issues of optimization and efficiency.

A very effective routine to maintain your fitness levels

Try the following to effectively enhance your stamina, strength and maintain general fitness.

1) Jog 100 metres

Jog 100 metres

Structured Query Language (SQL) – Understanding Table JOINS

Structured Query Language (SQL) – Understanding Table JOINS

1)      INNER JOIN

The inner join is given as

SELECT d.Dept_name, e.emp_name

FROM Department  d

INNER JOIN employee e

ON d.dept_id = e.dept_id

Structured Query Language (SQL) – Using the UNION / UNION ALL

Structured Query Language (SQL) – Using the UNION / UNION ALL

In this case, let’s consider the tables such that it will be easier to understand the intricacies of the Union.

Table DEPARTMENT contains the Dept_ID and the Dept_name.

Table EMPLOYEE contains the Emp_ID, emp_name, incentives, deductions  and contains the details for the permanent employees.

Table TEMP_EMPLOYEE contains the EMP_ID, emp_name and contains the details for temporary employees. The tables have been segregated to understand the UNION query.

Structured Query Language (SQL) – Using GROUP BY/ HAVING

Structured Query Language – Using Group By/ Having

The GROUP BY query is typically used with aggregates.

SELECT d.dept_name, d.location, count(e.emp_ID)

FROM department d, employee e

WHERE d.dept_id = e.dept_id

GROUP BY d.dept_name, d.location

Creating a Keyword Driven Test Automation Framework

Test Automation Framework.

Automation:
With increased effort being directed to automation; it is equally important to know that to be successful and efficient necessiates for some basic infrastructure in place. The importance of an automation framework gets prime focus if you are planning to embark on a full-fledged automation effort. However creating an automation framework does not come on a platter. A huge effort does goes in to identify the scenarios and the reusability nature of the various components within the framework model.

It is equally important to know the specific operations that could synergically combine and work together to generate the final result.