The SQL Data Lakehouse
Intro Data lake. Data mesh. Data fabric. So many terms have popped up in recent years to describe the way organizations should work with modern dat…
Showing posts with the label SQLShow all
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…
.png)
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 …
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 …
