Learn SQL fundamentals to extract data from the backend, analyze it, and make well-informed marketing decisions

About This Video

• 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

In Detail

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.