Advanced MySQL for Marketing & Web Analytics

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal.

In this course, you'll learn advanced MySQL techniques and apply them to real-world marketing and ecommerce business cases using a unique, custom-built database.

We'll start by introducing the course project, installing the tools we'll need to access our database, and reviewing the core SQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins.

From there we'll work through a number of analytics deep dives, including traffic analysis & optimization, website measurement & testing, channel mix, product performance, user analysis, and more. For each topic, we'll introduce the business concept, review the SQL tools that we'll be applying, and then jump straight into hands-on exercises and course projects.

If you're looking for a unique and highly engaging way to develop advanced-level SQL skills, this is the course for you.

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Aspiring Marketing or Ecommerce Analysts looking to build advanced SQL skills
• SQL users who want to master one of the world's most popular and powerful database programming languages
• Anyone looking for a hands-on, practical, and highly engaging way to master MySQL for data analysis

WHAT ARE THE COURSE REQUIREMENTS?

• MySQL Workbench and Community Server (we'll walk you through the install process)
• If you are new to MySQL, please complete the basic MySQL Data Analysis course first!