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.
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.
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.
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!