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.
What you'll learn
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.
Table of contents
Before beginning the course, you should have a basic understanding of Marketing Cloud and its contact model.
A query is a question or inquiry about a set of data. We use Structured Query Language (SQL) to retrieve meaningful and relevant information from databases. When building a structure, we pull data from tables and fields. The fields are columns in the database table, while the actual data makes up the rows.
Salesforce Marketing Cloud is a provider of digital marketing automation and analytics software and services. Salesforce Marketing Cloud is a customer relationship management (CRM) platform for marketers that allows them to create and manage marketing relationships and campaigns with customers.
Market segmentation is the process of splitting buyers into distinct, measurable groups that share similar wants and needs. Once different segments are identified, marketers determine which target segments to focus on to support corporate strategy and growth.
SQL is the default way to manage data in the databases, and it does not matter which platform you use.