Browse By

Category Archives: From Expert’s Desk

SQL - UDF and Trigger

Basic SQL for Testers : UDF & Triggers

1. User Defined Functions There are two types of User-Defined functions in SQL Server and they are Scalar, and Table-Valued. 1.1 Scalar Function A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These

SQL-StoreProcedure

Basic SQL for Testers : Store Procedures

1. Some Facts about Store Procedure If a repetitive T-SQL task has to be executed within an application, then the best repository for it is a program called a Stored procedure, stored in SQL Server. Storing the code inside the SQL Server object gives us

SQL Basics for Testers

Basic SQL for Testers : SET Operators

SET operators are mainly used to combine the same type of data from two or more tables. Although more than one select statement will then be present, only one result set is returned. Rules on Set Operations: 1. The result sets of all queries must

SQL Basics for Testers

Basic SQL for Testers : SQL JOIN

1. What is SQL Joins? An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. 2. SQL Inner Join The INNER JOIN keyword selects all rows from both tables as long as there is a match

KTL-UsabilityTesting

Usability Testing – Few points to look at

1. The mobile application layout should be rearranged for better user Experience, when the user changes the screen orientation to landscape or portrait. 2. Utilizing the display area in the device for the links, menus, images, etc. should be well distant from the edges of

No Thumbnail

Database Knowledge for Tester – Part 1

1. Database concepts 1.1 Codd’s Rule for RDBMS – 12 Rule Rule 1: The Information Rule All data should be presented in a table form Rule 2: Guaranteed Access Rule All data should be accessible without ambiguity. Rule 3: Systematic Treatment of Null Values Support for Null