SQL Fundamentals for Marketing, Digital and Web Analytics

Preview this course

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.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
30 on-demand videos & exercises
Level: All Levels
English
1hrs 32mins
Access on mobile, web and TV

What to know about this course

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

Who's this course for?

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.

What you'll learn

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

Key Features

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

Course Curriculum

About the Author

Anil Batra

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