Blog

Science behind Inner and Outer Join in SQL

SQL – Structured query language is one among the most easily picked up RDBMS languages and widely used across industries to store and retrieve data for transactional and reporting purposes. When moderately large amount of data needs to be handled SQL comes into picture and is considered most efficient, manageable. DML is the way of…
Read more


May 17, 2019 0

SQL Joins: Inner Join Vs Outer Join

In Relational Database, more often than not, related data is distributed along multiple tables. So when we need to retrieve a set of data stored along multiple tables, we have to retrieve the data from all the related tables and combine them, and we do this by using the common factor in those tables. It…
Read more


May 17, 2019 0

JOINS: A powerful skill to have in your kitty!

Inner Join Vs Outer Join: Before we understand different types of joins, I think it’s important to understand the purpose behind using it. As we know, JOINs is one the most powerful features of SQL used for gathering and manipulating data from across different tables. Without this feature, we would have to store all the…
Read more


May 16, 2019 0

Difference between an INNER JOIN and an OUTER JOIN in SQL

JOINS are the most commonly used commands that we come across in any SQL query or script. There are different types of JOINS defined in SQL to get varied outputs. The purpose of joining tables is to understand the relationship between the data present in the tables and how they change based on the conditional…
Read more


May 15, 2019 0

Joins : A difference in extracting the data

Joins are used to combine tuples (rows) from multiple tables. There can be multiple numbers of joins in the query statement. The tables are interlinked by joins using Primary Key and Foreign Key. Joins can be of two types: Inner joins Outer joins Inner joins are used to extract the common records where the keys…
Read more


May 11, 2019 0