What is Data Warehousing?

What is Data Warehousing? A  Data Warehousing  (DW) is process for collecting and managing data from varied sources to provide meaningful business …

SCD Type 2 implementation (Without Merge Statement)

Slowly changing dimensions or SCD are the  ALTER PROCEDURE Sp_Data_Updation_History ( @Brand_ID INT , @Brand_Name VARCHAR ( 30 ) ) AS BEGI…

LEFT Join In SQL

In this post, we are going to learn about the LEFT JOIN clause in SQL and how we can use LEFT JOIN to query the data. LEFT JOIN in SQL The LEFT JOIN …

Correlated Subquery in SQL

Common Table Expression (CTE ) IN SQL

In this post, we are going to learn about what is Common Table Expression or CTE, its functions, and its usability. Common Table Expression or CTE al…

ORDER BY in SQL

In this tutorial we are going to learn about what is Order By in SQL and how we are going to use the order by as well as what are the conditions whe…

What is a LookUp Table in SQL

What Is a Lookup Table? A lookup table or lookup file holds static data and is used to look up a secondary value based on a primary value. It can be …