Learn Intermediate SQL for Marketers and Product Managers
StartWhy 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.
Codecademy courses have been taken by employees at
- 1Analyze Warby Parker’s marketing funnel from Quiz → Home Try-On → Purchase in order to calculate conversion rates.
- 2Analyze churn for two groups of Codeflix users and recommend which segment represents a better long-term user base.
- 3Help CoolTShirts, an innovative apparel shop, improve their marketing campaigns.
What you'll create
Portfolio projects that showcase your new skills
Usage Funnels with Warby Parker
Analyze Warby Parker’s marketing funnel from Quiz → Home Try-On → Purchase in order to calculate conversion rates.
Calculating Churn Rates
Practice calculating churn rates using SQL.
Attribution Queries
CoolTShirts.com, an innovative apparel shop, is running a bunch of marketing campaigns. Which ones drive traffic to their site? Which ones leads to more sales?
— Madelyn, Pinterest“I know from first-hand experience that you can go in knowing zero, nothing, and just get a grasp on everything as you go and start building right away.”