Nidhi Gupta – Medium

5 days ago

DELETE DUPLICATE RECORDS FROM THE TABLE WHEN ALL DUPLICATE ROWS HAVE THE SAME VALUE

DELETE DUPLICATE RECORDS FROM THE TABLE WHEN ALL DUPLICATE ROWS HAVE THE SAME VALUE This is one of the questions asked in an SQL interview. Problem Statement: Write an SQL to identify and delete duplicate records from the table when all duplicate rows have the same value. Solution: Let’s consider we have a table named dup_nae with duplicate data. Solution: delete from dup_nae a using dup_nae b where a=b and a.ctid>b.ctid;

Sql

1 min read

DELETE DUPLICATE RECORDS FROM THE TABLE WHEN ALL DUPLICATE ROWS HAVE THE SAME VALUE

Sql

1 min read

Mar 18

Reuse the ADF pipeline from one ADF account to another ADF account in Azure

Reuse the ADF pipeline from one ADF account to another ADF account in Azure In this article, we will see how we can reuse the already-created pipeline. This is one of the questions asked in the interview. Step 1: From the extreme left select the option actions and from the download check the option Export template. Step 2: Click on the Export option and download the created activity pipeline template.

Azure

2 min read

Azure

2 min read

Mar 18

SQL Interview Questions

SQL Interview Questions In this article, I will be sharing a few SQL interview questions which are commonly asked in SQL interview. Script for table creation TABLE:- CREATE TABLE Employee (ID INT PRIMARY KEY, Name VARCHAR(50) NULL, RoleName VARCHAR(10) NULL, Salary NUMERIC(18,2) NULL ); DATA:- INSERT INTO Employee(name,rolename,salary)VALUES ( ‘Alex’, ‘SuperAdmin’, 90000 ), ( ‘Thomas’, ‘Admin’…

Sql

3 min read

Sql

3 min read

Mar 8

ForEach, GetMetadata And Copy Activity in ADF(Azure Data Factory)

ForEach, GetMetadata And Copy Activity in ADF(Azure Data Factory) In this article, we will see how to use Foreach, GetMetadata, and Copy Activity in one pipeline. Problem Statement: We have multiple CSV in Azure Data Lake Storage so we need to move these files from ADL to the Azure SQL…

Azure

3 min read

Azure

3 min read

Mar 5

CTE vs Temp Tables

CTE vs Temp Tables CTE and Temp Tables play an important role when we need to store intermediate data. This is one of the important questions usually asked in an interview. So in this article let's understand the difference between the two. CTE(Common Table Expression)[also called disposable view] The scope of CTE is till…

Data

1 min read

Data

1 min read

Feb 26

COPY MULTIPLE FILES ADF(Azure Data Factory)

COPY MULTIPLE FILES ADF(Azure Data Factory) In this article, we will see how we can copy multiple files from the azure data lake gen2 input folder to the azure data lake gen2 output folder. If you are new to azure then follow my previous articles to learn about ADF and how we can create important components…

Azure

2 min read

Azure

2 min read

Feb 14

Load Data From Azure Data Lake Gen2 Storage to Azure Synapse Analytics Workspace Dedicated SQL Pool…

Load Data From Azure Data Lake Gen2 Storage to Azure Synapse Analytics Workspace Dedicated SQL Pool Table. Steps at the source end Create an azure data lake gen2 account with a container named raw and upload a filename.csv (Refer to below link from the previous articles to create a storage account and linked service) Note: https://medium.com/@nidhig631/azure-data-factory-2921bb999177 Steps at the destination end

Azure

3 min read

Azure

3 min read

Feb 4

DATABRICKS vs SPARK

DATABRICKS vs SPARK Comparison between two different big data tools used for solving complex big data problems. SPARK Open source framework for data analysis and data processing. Spark has replaced MapReduce by providing advantages in terms of memory and fast processing of data. Spark code can be written in Java, Python, R, and…

Data

1 min read

Data

1 min read

Jan 23

Python Useful Tricks

Python Useful Tricks In this article, we will go through useful tricks used in python which can help us to reduce manual tasks. F Strings In Python F strings are the formatted strings in python that helps us in combining different data type values to single string expressions. …

Python Programming

1 min read

Python Programming

1 min read

Dec 4, 2022

CSV To JSON Using Copy Activity in ADF

CSV To JSON Using Copy Activity in ADF Copy Activity in ADF helps us to copy data from one format to another format. In the article, we will see how we can convert CSV data to JSON data in ADF. Step 1: Get an Azure subscription. For students to get a free subscription by using a free student…

Azure

2 min read

Azure

2 min read