Introduction to SQL in Salesforce Marketing Cloud: Lesson 3 - JOINs in SQL
Cameron Robert builds on the topics covered in Lesson 1 & 2 to show how to write SQL inside Salesforce Marketing Cloud. In this lesson, Cam steps through the JOIN function in 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 JOIN statements to combine data from multiple Data Extensions. Check the Resource links below for additional learning resources.
0:00 - Introduction
0:51 - Learning JOINs in SQL
6:29 - LEFT JOIN Example
18:57 - LEFT JOIN Missing Records Example
21:29 - INNER JOIN Example
27:16 - Joining more Data Extensions
32:05 - Next Steps: Aggregating Data
33:00 - 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