Cameron Robert shows how to use the Case Expression in SQL by stepping through a few demo use cases.
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:30 - Example Case Statement 1 - Numbers
2:14 - Numeric SQL Case Statement Example
8:24 - Example Case Statement 2 - Dates
9:21 - Date SQL Case Statement Example
13:31 - Creating Segments using a Case Statement
16:06 - Segmentation SQL Case Statement Example
22:44 - Summary
Playlist SQL In Salesforce Marketing Cloud: [ Ссылка ]
Course Resources:
• GitHub: [ Ссылка ]
• Database Diagram: [ Ссылка ]
• Marketing Cloud Data Views: [ Ссылка ]
Salesforce Documentation & Learning:
• Trailhead: [ Ссылка ]
• SQL Reference in Marketing Cloud: [ Ссылка ]
• W3Schools SQL reference: [ Ссылка ]
Contact:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Music: [ Ссылка ]
