The Simple SQL
for SFMC Program
Learn SQL the way it’s used in SFMC: to build journeys, automate campaigns, segment audiences, and create custom reporting.
Program Syllabus
Week 1 - Intro to SQL
Introduction to SQL
Data Extensions and Key Concepts
Fundamentals of SQL: Structure and Syntax
Mastering Query Activities in Automation Studio
SQL Functions: Part 1
Conditional Logic with CASE Statements
Debugging SQL - Tips and Techniques
2 x Brief Assignments + Solution Breakdown
Week 2 - Audience Creation
Understanding Keys and Data Extension Relationships
Creating Targeted Audiences: Using EXISTS and NOT EXISTS
Advanced Audience Segmentation with SQL JOINS
Unlocking the Potential of Sub-Queries in SQL
SQL Techniques for Effective Record Deduplication
SQL Functions: Part 2
2 x Brief Assignments + Solution Breakdown
Week 3 - Reporting
Getting Started with Data Views in SFMC
Using Data Views for Advanced Targeting
Data Analysis with SQL Aggregate Functions
Leveraging Staging Data Extensions
SQL Functions: Part 3
Creating Customized Reports Using Data Views and SQL
2 x Brief Assignments + Solution Breakdown
Week 4 - Automation Design
Journey Builder Overview
Automated Journeys: Workflow and Data Design
Event Promotion Automation Build
Welcome Series Automation Build
Reactivation Automation Build
Anniversary Automation Build
Data View SQL Templates