Book Image

SQL Fundamentals for Marketing, Digital and Web Analytics [Video]

By : Anil Batra
Book Image

SQL Fundamentals for Marketing, Digital and Web Analytics [Video]

By: Anil Batra

Overview of this book

Marketers and digital analysts generally depend on tools or the IT department to help them pull data for marketing decisions. This video course will teach you how to extract data on your own, enabling you to use SQL confidently to pull data for conducting marketing analysis independently. The video course begins with an introduction to SQL, and then moves on to show you how to install MySQL on your machine and teaches you about database fundamentals. You’ll then use Select and Where clauses, apply numeric and date values to narrow down your database search results, and find exactly what you are looking for. As you advance, you’ll add new records, update existing records, and delete a few records using SQL commands. You’ll also discover how to aggregate the data to use sum and count functions and join multiple tables to get the desired result set. Next, you’ll use SQL commands and techniques on a database to find out your highest-paying customers. Toward the end, you’ll learn about table manipulation commands and find out how to export and import data from CSV and Excel files. By the end of this course, you’ll have learned how to manipulate marketing data on your own using SQL commands and techniques. All the codes and supporting files for this course will be available at- https://github.com/PacktPublishing/SQL-Fundamentals-for-Marketing-Digital-and-Web-Analytics
Table of Contents (9 chapters)
Chapter 4
Selecting the data
Content Locked
Section 2
Narrowing down your result set with WHERE clause
This video shows how to narrow down the result set with the WHERE clause.