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

Mobile attribution

You’ll learn about mobile attribution. How it works technically and how mixed attribution model works on web and mobile

Product Analytics. Part 2

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

AB-tests analysis

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

Dashboards and alarms

This chapters talks about using SQL in BI tools, analytics dashboards and typical SQL queries behind them. We’ll also discuss automatic error detection using data and SQL.

SQL at work

This chapter is a collection of tips and tricks from Marketers, Product Managers and Data Analysts that will give you a head start on using SQL at work

Manipulating data

In this chapter we’ll talk about everything we haven’t been talking yet – modifying data in the database. Inserting new rows, updating and deleting

Appendix

This is SQL Habit’s storage room. It covers the aspects of SQL databases we haven’t discussed yet: rare JOIN types, set theory, lists of scalar, aggregate and window functions

Show all 12 chapters

Reviews

5.0 8 reviews

It's quite hard to find the right SQL course to not only practice the code itself but apply it to the real marketing challenges. After completing Part 1 I convinced that SQL Habit is the best course I've tried so far because it gives you an idea of performance marketing structure including all the steps; explains a big variety of commands you can practice using realistic company's data; helps you to make all those mistakes and find all those nuances. Great job and looking forward to completing Part 2!

Andrii, Performance Marketer & Sales

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

Buy unlimited access to SQL Habit

FUNDAMENTALS

25 free lessons and exercises, no credit card required

Free

UNLIMITED ACCESS

200+ lessons and exercises

Unlimited access to SQL Habit, forever

Verified LinkedIn certificate

A private Telegram group with the author and your fellow course participants

$149

$89

Buy now

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

EARLY BIRD
40% OFF

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