Learn Intermediate SQL for Marketers and Product Managers

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.

• 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