Introduction to SQL in Salesforce Marketing Cloud: Lesson 2 - Syntax and Basic SELECT Queries
Cameron Robert builds on the topics covered in Lesson 1 to show how to write SQL inside Salesforce Marketing Cloud. In this lesson, Cam steps through the key syntax of SQL by writing a series of simple SQL queries to achieve some example scenarios.
After watching this video you should have a good understanding of how to write some basic SQL queries to select and filter your data. Check the Resource links below for additional learning resources.
0:00 - Introduction
0:48 - Getting Started in Automation Studio
3:10 - Copy data from one DE into another
5:04 - Writing your first SQL Statement
12:22 - Writing a WHERE clause
15:26 - Checking your SQL results by using a Data Extension Filter
16:20 - Using AND in the WHERE clause
20:18 - Order your results with ORDER BY
25:06 - Summary
Playlist SQL In Salesforce Marketing Cloud: • SQL in Salesforce Marketing Cloud
Course Resources:
• GitHub: https://github.com/camrobert/Salesfor...
• Database Diagram: https://dbdiagram.io/d/624c3313d04319...
• Marketing Cloud Data Views: https://dbdiagram.io/d/5ff259ed80d742...
Salesforce Documentation & Learning:
• Trailhead: https://trailhead.salesforce.com/cont...
• SQL Reference in Marketing Cloud: https://help.salesforce.com/s/article...
• W3Schools SQL reference: https://www.w3schools.com/sql/sql_int...
Contact:
/ camrobert
https://www.cameronrobert.com.au/
/ auscamrobert
Music: https://www.bensound.com