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…
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…
Slowly changing dimensions or SCD are the ALTER PROCEDURE Sp_Data_Updation_History ( @Brand_ID INT , @Brand_Name VARCHAR ( 30 ) ) AS BEGI…
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 …
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…
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? 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 …