Simple Guide to Install MySQL Database And Workbench

In this tutorial, we are going to learn about how to install MySQL Database and workbench Installation. Install MySQL Database Steps: STEP 1: Download MySQL installer from below link and install it into your system. http://dev.mysql.com/downloads/mysql/ After loading the above URL, you will see a web page as shown below. From this page click on the download link button to download MySQL installer.     STEP 2: Once download gets completed, you will observe a file with the below file name. It will be of around 320 MB. Double click…

Continue Reading

Understand SQL Injection Better with the SQL Injection Cheat Sheet

Today we are going to learn What is SQL injection and cheat sheet to better understand of it. On the web page when SQL is used to display data, then most of the time it allow user to enter the search criteria. The SQL queries on written in text format and easy to change in the code based on the entered search criteria by user. SQL injection is a technique used to inject malicious SQL statements to data-driven application for execution. It SQL injection must exploit a security vulnerability in an application's software The SQL Injection vulnerability is…

Continue Reading

SQL Functions

In previous articles we have seen about different SQL commands to get store and retrieve the data from database. We have also learned about how to manipulate the data before saving or getting the data. The SQL supports number of useful functions and in this article we concentrating on those SQL functions with detailed description with Sql function examples & how to write function in sql.   What are Functions? The SQL Functions are different built in special type of commands in SQL. Functions are one-word command set which return…

Continue Reading

SQL GROUP BY Clause

What is the SQL Group by Clause? The SQL GROUP BY clause is used to group the result set based on common value present in the result set. The grouping of result set is done after all records are retrieved from tables. The GROUP BY clause can be used with the conjunction of SELECT query to make a group of rows based on the values of a specific column or expression. The SQL AGGREGATE function can be used to get summary information for every group and these are applied to…

Continue Reading

SQL UNION

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 SQL UNION query is both the SQL SELECT queries must having the same number of columns…

Continue Reading

SQL JOIN’s

SQL JOIN’s
sql join queries - learn database testing

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 basics of JOIN’s.   What is SQL JOIN’s? In the expert level JOIN’S are more common…

Continue Reading
Close Menu