Database

Now a days most of the software uses the database to stored the data. software retrieves or modify this data on the request of the end user or administrator of the application or website. we can stored any kind of data like banking data, user information, transactions, logs and many more in to the database. database is used […]

Continue Reading

In this post we will look into the different data types of MySQL. it is very important to understand the data types in database testing. we can writing server test cases around it also can verify that proper data types are applied on certain fields or not. MYSQL Data Types: Text Data Type: Data type […]

Continue Reading

Here Top 15 most used and asked SELECT sql queries in interview. I have consolidated in one post. 1) Find the Employee who get the second highest Salary. Answer:  SELECT emp_name from emp WHERE emp_salary =(SELECT max(emp_salary) FROM emp WHERE emp_salary<(SELECT max(emp_salary) FROM emp); OR SELECT MAX(emp_name) FROM  emp WHERE  emp_name <(SELECT MAX(emp_name) FROM emp);   2) […]

Continue Reading

During Interview many interviewers asked different database or query related questions as there could be the requirement that QA should know the basic SQL queries.

Continue Reading

there are Large variety of SQL commands and these commands divided into three basic groups as per the use of the commands, Data Definition Language, Date Manipulation Language and Data Control Language.

Continue Reading