PinnedManpreetsingh·Jun 30, 2024Spotify API’s using Azure Data FactoryIn this article I am going to show you how to write an ADF pipeline to access data from Spotify API and later on you can play around or…
PinnedManpreetsingh·Dec 4, 2023Real SQL Interview Question for the Data Analyst positionData Analyst Interview Question on Self JoinA response icon1A response icon1
PinnedManpreetsingh·Apr 28, 2023SQL LEAD Window FunctionWe will see how we can use the LEAD function for creating a condition to get the desired results.
PinnedManpreetsingh·Apr 24, 2023Use CASE statement to PIVOT data in SQLIn this simple query we would see how to create a PIVOT output (converting a row to column). We will be using the case statement depending…
Manpreetsingh·Dec 28, 2023Real SQL Interview Question for the Data Engineer positionThis question was asked by the interviewer to solve it live on tCoderbyte platform.A response icon2A response icon2