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.
Overview
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.
Syllabus
- Course Overview 1min
- Importing Data from the FTP 10mins
- Segmenting Data with SQL 23mins
- Querying Data Views with SQL 6mins
- Automating Data Segmentation 9mins
Taught by
Baneen Qazi