👉 The course is 59% ready (157/264 lessons and exercises are published). The course will be finished in late November, 2019. Purchase it now with 40% Early Bird Discount 👈

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

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

Practical

Practical

The SQLhabit 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

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 SQLhabit account.
Bite-sized

Bite-sized

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

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 SQLhabit, so you can make more data-informed decisions. 🚀

Anatoli Makarevich, author of SQLhabit

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 SQLhabit works

The course has all the necessary resources to make you an advanced SQL user. With SQLhabit, 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 6 reviews
Mariia, Performance Marketing Team Lead @ CareerFoundry
Andy, Freelance App Designer
Clément, Head of Paid Social @ Blinkist

Buy with 40% Early Bird discount

Currently, 59% of the course is available. New material is added every week. Purchase an early bird access today! 🚀

THE ESSENTIALS
200+ lessons and exercises (eBook is coming in Dec, 2019)
Unlimited access to SQLhabit, forever
Verified LinkedIn certificate
$149
$89
Buy now
Want your team to learn with SQLhabit? Check out team pricing options.
THE COMPLETE PACKAGE
200+ lessons and exercises (eBook is coming in Dec, 2019)
Unlimited access to SQLhabit, 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 ☎
$399
$239
Buy now
Want your team to learn with SQLhabit? Check out team pricing options.

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?

SQLhabit 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 SQLhabit 💪

Can I purchase SQLhabit 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)