SQL for QA: Tutorial#9 – JOIN Clause
JOIN clause is used to combine data from two or more tables, after joining it comes as a single set of data and we can call it Result set. Tables are combined using JOIN clause by using
supriyak Archive
SQL for QA: Tutorial#8 – UNION Clause
QAs also use UNION clause frequently if need to do through testing of application functionalities with data. By using the UNION operator, we can combine the results of 2 or more SELECT statements and at the same
SQL for QA: Tutorial#7 – GROUP BY Clause
The GROUP BY clause is used to organize identical data into groups often with the help of 5 Aggregate functions ie. COUNT, MIN, MAX, AVG, SUM. GROUP BY clause is used with SELECT statement and it group
SQL for QA: Tutorial#6 – ORDER BY Clause
In SQL, ORDER BY clause is used to sort the records of the table. It is used with SELECT statement. Using this clause, we can sort the data by Ascending or Descending order. By default, ORDER BY
SQL for QA: Tutorial#5 – DELETE Statement
DELETE Statement is used to permanently removes existing records from a given table. Most of the time QAs won’t have permission to perform this command on Development or Production environment. But they can do it on their
SQL for QA: Tutorial#4 – UPDATE Statement
UPDATE Statement is also frequently used by Testers and QAs. UPDATE is used to modify already existing records from the database table. In this article we will see how we can modify single as well as multiple
SQL for QA: Tutorial#3 – INSERT INTO Statement
Many times, QAs don’t find sufficient data in QA environment for testing. So they need to create some dummy data specific to their test cases. They also need to add some negative data to verify negative conditions.
SQL For QA : Tutorial#2 – Where Clause
I believe WHERE clause is the most frequently used clause with SELECT statement by QAs. WHERE clause is not a compulsory clause in a SQL query, but a optional one to apply filter on the given table.
SQL For QA : Tutorial#1 – Select Query
The use of SQL is not limited to developers only. If you are a Tester or QA professional, you also need to run some tests against databases, verify data using some tool. In short, database testing is
Java Creational Design Patterns – Abstract Factory Pattern
The Abstract Factory Pattern is one of the creational design patterns. We can say Abstract Factory patterns acts as a super-factory which produces other factories. The role of the Abstract Factory is to provide an interface for creating families
Java Behavioral Design Patterns – Null Object Pattern
The Null Object Pattern is one of the behavioral design patterns, it is an object with clear neutral or null behavior. It is called as Null object because by default it does nothing and only it helps to avoid
Java Structural Design Patterns – Facade Pattern
Facade Pattern provides the ease of usability for a system by hiding its complexity. It comes under a Structural design pattern. In this pattern client code can access the system but it hides the working of the system by