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.
Course info
Rating
(13)
Level
Beginner
Updated
Oct 2, 2020
Duration
50m
Table of contents
Description
Course info
Rating
(13)
Level
Beginner
Updated
Oct 2, 2020
Duration
50m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
Description

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 FAQ
Course FAQ
What are the prerequisites for taking this course?

Before beginning the course, you should have a basic understanding of Marketing Cloud and its contact model.

What is a query in SQL?

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.

What is SalesForce Marketing Cloud?

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.

What is marketing segmentation and targeting?

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.

Why is it important to learn SQL?

SQL is the default way to manage data in the databases, and it does not matter which platform you use.

About the author
About the author

Baneen is a marketing automation consultant with years of Salesforce experience. She is passionate about helping businesses deliver the right message at the right time by the right channel.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Baneen Qazi, and welcome to my course, SQL Fundamentals in Salesforce Marketing Cloud. I am the lead marketing automation consultant for Be Intelligent in New Zealand. I've been working in the Salesforce ecosystem for about five years. In this course, we're going to cover the fundamentals of writing and automating SQL queries in Salesforce Marketing Cloud. This knowledge will empower you to send the right message at the right time to the right people. Some of the major topics that we will cover include importing data from the FTP, writing SQL queries to segment your own data, as well a system data, and automating the process from start to finish. By the end of this course, you'll know how to create highly targeted segments of data that will help you better understand your customers and personalize their experience of your brand. Before beginning the course, you should have a basic understanding of Marketing Cloud and its contact model. I hope you'll join me on this journey to learn about automating your data segmentation with the SQL Fundamentals in Salesforce Marketing Cloud course, at Pluralsight.