SFMC SQL | Mateusz Dąbrowski

📄️ SQL Basics

SELECT your data FROM Salesforce Marketing Cloud WHERE drag-and-drop Filters are not enough.

Selected information on the SELECT statement in SFMC SQL.

Tell the SQL query FROM where you need the data.

Data Extensions. System Data Views. With the JOIN statement, use one query to rule them all.

Use WHERE to make your query lean and to the point. Less is more.

Empower your Marketing Cloud queries with conditional SQL CASE logic.

Get a LIKE and build more flexible SQL queries.

Take control over strings with built-in SQL functions. Let the query do the job.

Take control over dates with built-in SQL functions. Let the query do the job.

Take control over numbers with built-in SQL functions. Let the query do the job.

Break from the limits of Data Extension data types. Use full power of SQL to control your values.

Group rows and apply aggregate functions to see the big picture in your data extensions.

IS NULL, or IS NOT NULL, that is the question. Ways of working with NULL values in SFMC SQL.

Query with style. Readable, bug-free code is a few shifts & spaces away.