SQL For Software Testing, Requirement of SQL in Software Testing

Requirement of SQL in Software Testing

To confirm the backend changes or test the changes from database, SQL queries are required for Software Test Engineers. Software Test Engineer should aware about some basic queries which are given below:

Some SELECT Statement:

i.    SELECT * from web_liate(Table Name) – Simple SELECT Statement

ii.  SELECT * from web_liate where in_web= 420 - SELECT Statement with where Clause

iii. SELECT * from web_liate where in_web= 420 and in_web= 421  OR  

    SELECT * from web_liate where in_web in (420, 421)  - Where Clause with ‘And’ and ‘In’ Keyword.

iv. SELECT * from web_liate order by in_affiliate_id desc/asc – SELECT with Order By clause

v. SELECT Distinct in_web(Column name) from web_liate – Use of Distinct Keyword

vi. SELECT vc_web_dom,in_web_id, in_com from web where in_web<= All ( SELECT in_website_id, in_web_liate  from web_liate where in_affiliate_id >= 51) – Use of operators and Nested SELECT Query

vii. SELECT COUNT(in_website_id) from website ….  Use of Functions by SQL Quesries i.e. Max, Count, Floor, Year, Length, Current_Date, Hour, Case, Min, Rank etc

viii. SELECT affiliate_id from web_liate GROUP BY affiliate_id  -  Use Group By Keyword

ix. SELECT * from list_user where vc_email like 'abcde%' – Use of Like Keyword with Where Clause

x. SELECT * from tbl_messages where msgid between 162497 and 162706 and bt_force =1 – Use of Between Keyword using where clause

xi. SELECT a.in_website_id, b.in_affiliate from web a Inner Join web_liate b on a.in_web= b.in_web where b.in_affiliate > 101 – Inner Join SQL statement This statement is also very much required for Sopftware Test Engineer

UPDATE Statement:

           i. UPDATE web_liate set bt_active = 1 where affiliate_id =452

           ii. UPDATE web_liate set S_password = 'Salespss' where affiliate_id =452

DELETE Statement :

         DELETE from web where web_id = 420

Above are some basic sql queries which are required to learn by software test engineers

Software Testing Principle	Software Development Life Cycle	Unit Testing
Integration Testing	System Acceptance Testing	Sanity and Smoke Testing
Regression Testing	Non Functional Testing	Test Case
Test Scenario	Software Testing Rules	SQL For Software Testing
Test Case Design and Example	Test Base	Traceability Matrix
Boundary Value analysis	Decision Table in Software Testing	State Transition Definition
Use Case Testing	Testing Review	Techniques of Test Estimation
Test Plan Structure	Definition of Bug	Bug Life Cycle
Automation Testing Tools	Test Web Based Application	Software Testing Types
Software Testing Techniques	Techniques in Software Testing	Test Data
Software Testing Life Cycle	Black Box Testing	Difference between Black Box testing and White Box Testing
Smoke and Sanity Testing	Testing Methodology	Extreme Programming
White Box Testing	System Software Testing	Performance Testing
Usability Testing	User Acceptance Testing	Regression Testing
MANUAL SOFTWARE TESTING	Automation software Testing	Functional Testing

sql queries in software testing, all urgent sql queries from software testing development, database testing, select update and delete queries, use of inner join query in software testing

MOBILE APPS    QTP TESTING QUESTIONS  MANUAL TESTING  ANDROID APPS