Posts

SQL -Task (SQL Use Cases Naveen Singh)

Image
SQL Use Cases:- Naveen Singh  Source DE:- NaveenSQL_Customer_Details Task-1. Find Gmail users Query:- Select * From  NaveenSQL_Customer_Details  Where Email Like '%@gmail.com' Target DE:-  Result:- There are 3 out of 10 records has been tested NaveenSQL_Customer_Details - 20260429_085257_Target_DE Task-2.  Users whose name starts with "A" Query:- Select * from  NaveenSQL_Customer_Details  WHERE Name LIKE 'A%' Target DE:- Task-3.  Users whose name ends with "Singh" Query:- Select * from  NaveenSQL_Customer_Details  WHERE Name LIKE '%Singh' Target DE:- Task-4.  Find users with "sale" in email (campaign filtering) Query:- Select * from  NaveenSQL_Customer_Details  Where  Email LIKE '%sale%' Target DE:- Task-5.  Find  customers from cities containing "pur" Query:- Select * from  NaveenSQL_Customer_Details  Where  City LIKE '%pur%' Target DE:- Task-6.  Target users with mobile numbers ends wit...

SQL Query in SFMC

Image
   SQL Query in SFMC https://elearningit24.atlassian.net/wiki/x/wIAOAg To run SQL in  Automation Studio in SFMC (Salesforce Marketing Cloud) , we use an  SQL Query  Activity  inside an automation.  Source DE:- SFMC > Journey Builder > Automation Studio SQL Query Activity: Select [ Email Address ],[ First Name ],[Last Name],[Gender],[ Subscription Status ]  FROM [ab testing DE Naveen] After Automation:- Target DE:- How to Set Up SQL Query Activity in SFMC ? Step 1: Create a New SQL Query Activity 1️⃣ Go to Automation Studio → Click "Activities" 2️⃣ Click "Create Activity" → Select "SQL Query" 3️⃣ Enter an Activity Name and Description Step 2: Write Your SQL Query SQL in SFMC is based on T-SQL (Transact-SQL) , but it has some limitations (e.g., no INSERT , UPDATE , or DELETE commands). The SELECT query pulls data from one or more Data Extensions and inserts it into a new Target Data Extension . Step 3: Select a Target Data Extension S...