SQL Habit | Practical SQL course for Product Managers, Marketers,

Master SQL through the story of how a startup succeeded through data.

Practical

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.

Actionable

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.

Bite-sized

Each exercise is designed to be 15-20 minutes long, so you can easily fit it into your day!

Meet the author

Hi, my name is Anatoli or @makaroni4! For the last 10 years I’ve been typing SQL queries as a physicist, software engineer, CEO, marketer, and data analyst. For the past 4 years, I’ve been working as a Lead Engineer in the Growth Team at Blinkist and saw it grow to 12 million users. I’ve worked for others, and I’ve also founded and sold my own company.

All these experiences have taught me one thing - you should know how to use your data. This inspired me to create SQL Habit, so you can make more data-informed decisions.

What will you learn?

How to use data in Marketing

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.

How to use data in Product

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.

How to make business decisions

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.

How to master Data Analytics

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.

How to model data

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

How to master SQL

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

How SQL Habit works

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.

Course Chapters

Introduction

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

Fundamentals of Data Analysis

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

Running marketing

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

Revenue analytics and unit economics

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)

Product Analytics. Part 1

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

Product Analytics. Part 2

Second part of Product Analytics focuses on analytics for mobile apps, retention rate, churn rate and LTV

Launching NPS survey

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

Running AB-tests

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

Analyzing search & recommendations

At this moment Bindle has thousands of books available. This chapter focuses on content: analyzing search and recommendations

Monitoring and alarms

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

Analyzing content interactions

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

Email communication

In this chapter we’ll deep dive into Bindle’s email communication: newsletter and promotion email metrics, web funnels and more

Analyzing business as a whole

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

Appendix & further reading

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

Reviews

5.0 7 reviews

It's one of the best ways to learn SQL, and to learn it in an extremely effective manner — by using a live, real world use case database. It's fun, and as a founder myself, the skills learned here will be extremely valuable. Not only for SQL, but for growth and for analytics in general. Thank you!

Stephen Lizcano, Founder @ SwyftMD

I've been wanting to learn SQL for ages and even started a course a while ago, but even though the topic is highly relevant and interesting to me, I haven't even finished that one course. With SQLhabit its all different as it is based on a fictional, yet much more realistic example, and the tasks solve actual problems I face at work - in my case marketing ones like funnel analysis. Not sure an SQL course can get any more relevant.

Mariia, Performance Marketing Team Lead @ CareerFoundry

I used to think databases were these mythical beings that a lowly designer could never touch. I wouldn’t want to mess things up in there, now would I?! But I was wrong — so wrong. Thanks to SQL Habit I now understand that SQL is not just for the select few — it’s for everybody. I love how SQL Habit uses stories to teach, and how it keeps the level of difficulty just right. I need to make data-informed decisions all the time. Now I can access a database and get all the answers I need myself!

Andy, Freelance App Designer

Buy unlimited access to SQL Habit

FUNDAMENTALS

25 free lessons and exercises, no credit card required

Free

UNLIMITED ACCESS

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

$149

$109

Buy now

Want your team to learn with SQL Habit? Check out team pricing options.

Employees of these companies study on SQL Habit

Frequently Asked Questions

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.

Can I get an invoice?

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.

Can I purchase SQL Habit for my team/company?

Sure thing! Check out team options here or shoot me an email with how many licenses do you want at hello@sqlhabit.com and I’ll send you an invoice and license keys.

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).

Level up your career or business by becoming 100% data informed