SQL Fundamentals in Salesforce Marketing Cloud

Structured Query Language (SQL) is used in Salesforce Marketing Cloud to manage and manipulate Data Extensions. This course will teach you the basics of writing SQL queries, structuring data extensions and automating data imports.

Salesforce Marketing Cloud is a powerful tool that allows you to understand your customers better and personalize their experience of your brand. Knowledge of SQL is essential in automating segmentation so you can send the right message at the right time, to the right people. In this course, SQL Fundamentals in Salesforce Marketing Cloud, you’ll learn to segment your data to create a highly targeted subset of data. First, you’ll explore how to import your data from the secure FTP. Next, you’ll discover writing SQL queries. Then, you’ll learn about the different joins and what they do, how to write a case statement, as well as what data views that are available in Salesforce Marketing Cloud. Finally, you’ll learn how to automate your SQL queries so you don’t have to run them manually. When you’re finished with this course, you’ll have the skills and knowledge of SQL Fundamentals in Salesforce Marketing Cloud needed to manage customer data and create highly targeted segments.

• Course Overview 1min
• Importing Data from the FTP 10mins
• Segmenting Data with SQL 23mins
• Querying Data Views with SQL 6mins
• Automating Data Segmentation 9mins