Netsparker Web Application Security Scanner

What is database and why do we need them?

(adsbygoogle = window.adsbygoogle || []).push({});

Welcome to next post related to Database. Everyone know about the database, it is used to store the data. However the data can be stored in the excel file or in flat files.

Have you think about “What is actually meaning of database and why do we need them?”

If you want to understand database then don’t start with the features of database first, rather you should go with other way round. Database are

Continue reading…

SQL UNION

(adsbygoogle = window.adsbygoogle || []).push({});

In previous article we have learned about SQL JOINS. In this section of Software Testing Class we are concentrating on “SQL UNION”. In this post we are covering what is SQL UNION, examples of UNION, why use SQL UNION & difference between SQL JOIN and UNION.

 

What is a SQL UNION?

The SQL UNION operator allows you to combine the result of two or more SQL SELECT queries.

The only requirement to work

Continue reading…

SQL JOIN's

(adsbygoogle = window.adsbygoogle || []).push({});

The JOIN is very much misunderstood term for beginners while learning the SQL commands. In the interview at least one question is ask about the SQL JOIN’s. So in this article I am trying to simplify the things for new SQL learners & make it easy to understand the SQL JOIN’s. At the end of this post you should in a position to write your SQL JOIN query independently. So first start from the

Continue reading…