SQL Fundamentals for Marketing, Digital and Web Analytics

Description

This video course will teach you the basics of Structured Query Language (SQL), such as writing SQL queries, creating and updating tables, and importing and exporting data from comma separated values (CSV) and Excel files. You'll also learn about the SQL and database skills you need to become a self-sufficient digital analyst or marketer who can extract marketing data from the backend without assistance.

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

Write and understand SQL to pull data for marketing analysis
Discover how data is structured and stored in databases
Master common SQL commands used by marketing analysts
Import data into MySQL from CSV and Excel files
Export data from MySQL into Excel files
Connect MySQL with Tableau for data visualization

If you are a beginner to marketing, an experienced marketer, or a digital analyst looking to learn SQL to pull out data for marketing purposes, then this video course is for you. Basic computer skills are needed to get started with this course.

With a practical approach using simple explanations, this video course helps you develop the SQL and database skills you need to manipulate data for achieving your marketing goals.

Familiarize yourself with SQL and database fundamentals * Write flawless SQL queries to draw insights from marketing data * Explore some common use cases for marketing, web, and digital analytics

https://github.com/PacktPublishing/SQL-Fundamentals-for-Marketing-Digital-and-Web-Analytics

Anil Batra, founder of Global Analytics Academy and Optizent - a digital marketing and analytics consulting company, is a seasoned digital marketing and analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to various start-ups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He has taught and trained several marketing and analytics professionals in the past 9 years of teaching at UBC, University of Washington, and Bellevue College. Anil also teaches digital marketing, digital analytics, Google Analytics, Tableau, and social media courses.

1. Introduction

2. Installation and Overview of SQL Environment (MySQL)

3. Database Fundamentals

4. Selecting the Data

5. Other Key SQL Statements

6. Some advanced Select Statements

7. Marketing Use Cases

8. Using data from the database in other programs

9. Database Manipulation