Shield image course 5268 20170901 209 1a9f5st?1504275306

SQL Tutorial for Marketers

20 Exercises 1 hour 105 Participants 1,470 XP

Open Course Description

The best marketers and growth hackers are data-driven. They quickly pull data about marketing campaigns, customers, ... from databases on their own and use this information to run more profitable campaigns. In this interactive tutorial by DataCamp, you will learn through fun interactive exercises how you can use the powerful Structured Query Language or SQL to communicate with a relational database. Step-by-step, you will learn how to retrieve and filter data from a database that contains data on bank clients and direct marketing campaigns.

Chapter 1: Retrieving Data From The Database

This chapter provides a brief introduction to working with relational databases in a marketing context. You'll learn about their structure, how to talk about them using database lingo, and how to begin an analysis by using simple SQL commands to select and summarize columns from database tables.

Chapter 2: Filter Data And Limit Your Output

In this chapter, you'll learn how to filter tables for rows that satisfy your criteria of interest with the help of basic comparison operators and combinations of multiple criteria.

Chapter 3: What's Next?

Besides selecting columns and filtering rows, there is much more that you can do with SQL! This chapter will present you with some examples that will motivate you to continue to develop this newly gained skill!

Author image course 5268 20170901 209 lkavqb?1504275306
Karlijn Willems
Karlijn is a data science journalist at DataCamp. She is passionate about data science education, and the latest news and the hottest trends in the data science industry. She holds degrees in Literature and Linguistics and Information Management.