Marketing Analytics

Technical marketers are in high demand and low supply. Being able to dive into data on your own, with no help from analysts, makes you a much better marketer.

This is why Structured Query Language (SQL) is so powerful - it allows you to see all your customers’ data and make decisions based on accurate analysis. Knowing how to use SQL is literally a marketing superpower, and that’s exactly what this course will teach you!

The concepts and queries in this course are used every day by the marketing teams at successful companies like eBay, Moz and HubSpot.

Highlights -

Six key components of every SQL query
How to identify your most profitable users, and how to attract more like them
How to run a cohort analysis
How to discover the "aha" moment that turns one-off customers into loyal clients
Five key metrics to measure right away after learning SQL
Over 1.5 hours of video content
Downloadable databases and other resources
Case studies
Certificate of Attainment

Syllabus

Section 1: Introduction

Unit 1.1 - Introducing the Course

Section 2: What is SQL?

Unit 2.1 - Introduction
Unit 2.2 - What, Why and How
Unit 2.3 - Marketing and SQL

Section 3: Writing SQL Queries

Unit 3.1 - Preparing to Write a Query
Unit 3.2 - SQL vs. Excel?
Unit 3.3 - Writing Queries

Section 4: Using SQL

Unit 4.1 - Querying Databases
Unit 4.2 - Exercises
Unit 4.3 - SQL Scripting and Reporting
Unit 4.4 - Course Conclusion

Section 5: Bonus Content

Unit 5.1 - Chartio for Data Analysis
Unit 5.2 - Google Query Creator