Introduction to SQL in Salesforce Marketing Cloud: Lesson 4 - SQL Aggregate and Group By

Cameron Robert follows on from Lesson 3 to summarise the customer data using SQL Aggregate functions and Group By statements to produce Count, Sum, Min, Max and Avg. 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:38 - Demonstrating the problem from Lesson 3
3:33 - The use case for SQL Aggregation
4:30 - SUM() function in SQL
6:00 - Group By in SQL
7:22 - Testing the SUM() Query
8:29 - Overview for Aggregation functions
10:45 - Testing the Aggregation functions
14:12 - Subqueries in SQL
20:20 - Subquery Scenario
29:33 - Simplifying Subquery Aggregation
32:40 - Summary

Course Resources:

Salesforce Documentation & Learning:

Contact:

[Donyadideha]

Hi Cam, thanks a lot for the great videos. I don’t have access to SFMC instance. Is there a way to get access to SMC tool for training? If yes will you be able to create a video of that? Thanks.