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 Mark...
Course Resources:
• GitHub: github.com/camrobert/Salesfor...
• Database Diagram: dbdiagram.io/d/624c3313d04319...
• Marketing Cloud Data Views: dbdiagram.io/d/5ff259ed80d742...
Salesforce Documentation & Learning:
• Trailhead: trailhead.salesforce.com/cont...
• SQL Reference in Marketing Cloud: help.salesforce.com/s/article...
• W3Schools SQL reference: www.w3schools.com/sql/sql_int...
Contact:
/ camrobert
www.cameronrobert.com.au/
/ auscamrobert
Music: www.bensound.com
4 июл 2024