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 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
8 июл 2024