Cameron Robert continues the SQL Learning to cover String, Math and Date Functions.
After watching this video you should have a good understanding of how to combine SQL functions with JOINs and Sub-Queries to create advanced queries to solve specific business needs. Check the Resource links below for additional learning resources.
0:00 - Introduction
0:42 - Recap of Lesson 4
2:35 - Solve the problem using SQL Functions and Sub-Queries
7:53 - Checking the Results
8:45 - Introduction to SQL Functions
12:45 - Overview of SQL Functions using W3Schools
17:47 - SQL Functions summary
19:32 - 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