SQL Habit – practical SQL course for Product Managers, Marketers, Designers etc

The SQL Habit course is based on the story of a fictional startup called Bindle. You’ll solve challenges in business, marketing, and product using data and SQL.
You’ll access the actual data warehouse of Bindle and run SQL queries. No additional tools needed – you’ll have everything needed in the SQL Habit account.
Each exercise is designed to be 15-20 minutes long, so you can easily fit it into your day!

Marketing + Data + SQL = ❤. We’ll calculate a variety of marketing metrics (ROI, CPC, CPS, CPA and more). You will learn how to build attribution models, analyze campaigns and run cohort analyses.

You will learn how to analyze web and mobile products using AARRR metrics (Acquisition, Activation, Retention, Revenue, Revenue), cohort analysis, segmentation, AB-tests and more.

You will learn how to analyze business growth and profitability by looking at unit economics. We’ll learn how to determine customer churn rate, estimate LTV, and measure organic and paid growth.

You will learn the fundamental principles of data analysis: how to calculate conversion rates, run cohort and funnel analysis, analyze trends and monitor your business health.

You will learn how data is collected, recorded and stored for mobile and web platforms, by working with a real data warehouse.

The course will teach you every aspect of SQL. You will be able to use SQL for all possible situations. Previous knowledge not required.

The course has all the necessary resources to make you an advanced SQL user. With SQL Habit, you can back up any decision with data. No previous experience required.
You’ll learn how SQLHabit works and how to get the most out of the course. A quick chapter to set you up for an efficient and effective learning 🚀
Together with Bindle’s founders you’ll learn SQL basics and how it helps to segment users (by country, time etc), work with basic timelines 📈
This chapter focuses on SQL for marketing: what data can help us measure an effectiveness of our campaigns, how to group data, work with time lines and cohorts 📊
In this chapter we’ll dive into all things revenue: calculating gross revenue, revenue per country/time period. We’ll see how we can join marketing and revenue data to calculate ROI and business unit economics (revenue per user etc) 💸
Bindle launches a mobile app to allow users read books on the go. In this chapter we’ll learn funnel analysis for product flows (onboarding, purchase), retention metrics and more 💻
Second part of Product Analytics focuses on analytics for mobile apps, retention rate, churn rate and LTV 📱
NPS (Net Promoter Score) score is an industry default standard for measuring customer happiness and loyalty, great way to customers feedback and new ideas for features. In this chapter we’ll focus on analyzing raw NPS score data ⭐
It’s time for the new chapter at Bindle – running AB-tests. Just shipping features is not enough, AB-tests allow learning how and why changes in the product affect users behavior and happiness. This chapter talks about AB-tests analysis with SQL 💊
At this moment Bindle has thousands of books available. This chapter focuses on content: analyzing search and recommendations 📚
At this stage Bindle has many thousands of users and big team working on the product. It’s inevitable that some mistakes slipped in and only data could reveal them. In this chapter we’ll dive into using SQL for monitoring and setting up alarms 🚨
Bindle’s mission is to build the best place to find and read books. This chapter will focus on content analytics based on user engagement and star rating 🔎
In this chapter we’ll deep dive into Bindle’s email communication: newsletter and promotion email metrics, web funnels and more 📧
In this chapter we’ll focus on analyzing business as a whole and try to answer questions like “Are we profitable?”, “When are we going to be profitable?”, “What’s our run rate?” etc 💰
So far we’ve been reading (SELECT-ing) data from Bindle’s database. To be fully ready for using SQL in real life we’ll learn how to create/update/delete data in the database and more. We’ll also define next steps for you to continue maintaining and developing your SQL Habit further ❤
Show all 14 chapters
200+ lessons and exercises (eBook is coming in Dec, 2019)
Unlimited access to SQL Habit, forever
Verified LinkedIn certificate
Buy now
200+ lessons and exercises (eBook is coming in Dec, 2019)
Unlimited access to SQL Habit, forever
Verified LinkedIn certificate
A private Telegram group with the author and your fellow course participants
Biweekly Live Q&A sessions with the author and recordings of previous sessions
Group calls to discuss questions about SQL & data. If calls ever be stopped: you are guaranteed to participate in at least 6 calls ☎
Buy now

Can I try the course for free?

Absolutely. The first 25 lessons and exercises are free. Just signup with your email, no credit card info required.

Do you accept PayPal purchases?

SQL Habit uses Gumroad to accept payment and Gumroad supports PayPal.

Absolutely! Right after purchasing you’ll get a receipt which includes a link to generate an invoice with any extra information you need to add for your own accounting purposes.

Do you have monthly subscription?

Nope, one time purchase allows you to access it forever. Honestly, I believe it’ll take you 1-2 months to really develop this strong SQL Habit. 💪

What if I realize it’s not for me?

No problem! Ping me at support@sqlhabit.com and you’ll be refunded in full, no questions asked (except feedback).