Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Codecademy

Learn Intermediate SQL for Marketers and Product Managers

via Codecademy

Overview

Perform data analysis on funnels, churn, and attribution. This course contains advanced SQL content for new Marketers and Product Managers.

## Why Learn Intermediate SQL for Marketers and Product Managers?

Once you have the SQL foundation you need, it’s time to apply those skills on-the-job. Designed for Marketers, Product Managers, Consultants, and Data Analysts, this course will teach you advanced techniques to work with data and frameworks specific to your career.

## Take-Away Skills:
You’ll investigate user churn metrics, interpret usage funnels, and analyze first- and last-touch marketing attribution methodologies — all leading up to a Warby Parker capstone project.

Syllabus

  • Usage Funnels: Analyze Warby Parker’s marketing funnel from Quiz → Home Try-On → Purchase in order to calculate conversion rates.
    • Lesson: Usage Funnels
    • Informational: Project Assignment: Usage Funnels
    • Project: Usage Funnels with Warby Parker
  • User Churn: Analyze churn for two groups of Codeflix users and recommend which segment represents a better long-term user base.

    • Lesson: Calculating Churn
    • Informational: Project Assignment: User Churn
    • Project: Calculating Churn Rates
  • Marketing Attribution: Help CoolTShirts, an innovative apparel shop, improve their marketing campaigns.
    • Lesson: First- and Last-Touch Attribution
    • Informational: Project Assignment: Marketing Attribution
    • Project: Attribution Queries
    • Informational: Peer Project Feedback

Reviews

4.4 rating at Codecademy based on 93 ratings

Start your review of Learn Intermediate SQL for Marketers and Product Managers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.