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.
Continue reading QTP – Accessing SQL Server for automation test needs
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.
Continue reading Database Testing – Need and How to?
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
The SQL returns the appropriate results.
The SQL adequately addresses the issues of optimization and efficiency.
Continue reading SQL Query Optimization Techniques and Tips
Try the following to effectively enhance your stamina, strength and maintain general fitness.
1) Jog 100 metres
Jog 100 metres
Continue reading A very effective routine to maintain your fitness levels
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
Continue reading Structured Query Language (SQL) – Understanding Table JOINS
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.
contains the Dept_ID and the Dept_name. DEPARTMENT
contains the Emp_ID, emp_name, incentives, deductions and contains the details for the permanent employees. EMPLOYEE
contains the EMP_ID, emp_name and contains the details for temporary employees. The tables have been segregated to understand the UNION query. TEMP_EMPLOYEE
Continue reading Structured Query Language (SQL) – Using the UNION / UNION ALL
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
Continue reading Structured Query Language (SQL) – Using GROUP BY/ HAVING