SQL Fundamentals for Marketing, Digital and Web Analytics

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.

30 on-demand videos & exercises

Level: All Levels

English

1hrs 32mins

Access on mobile, web and TV

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

Course Curriculum

About the Author

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.