Practical SQL course for Marketers, Product Managers and Data Analysts

7 min read Original article ↗

“no fuss, just things you actually need”

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

More than SQL course

More than SQL course

The SQL Habit is based on a story of a fictional startup called Bindle. You’ll solve real-life challenges from business, marketing, and product management. You’ll learn how to work with data, specifics of Data Analysis for web and mobile apps. And, of course, SQL.

Actionable

Actionable

SQL Habit teaches practical, actionable skills. You’ll write queries in the actual data warehouse of a company named Bindle. From the very first lesson, everything you learn could be applied in the real context.

Bite-sized

Bite-sized

Each lesson and exercise are designed to be 15-30 minutes long, so you can easily fit it into your day!

Mock Interviews

Mock Interviews

Prepare for an interview with Mock Interviews – 2 real-life challenges that you’ll have to solve in 45 minutes. Improve your skill since all Mock Interviews come with detailed explanations.

60+ hours of materials

375 lessons and exercises inspired by the story of a growing startup. You’ll learn SQL from zero to Data Analyst level and, most importantly, how data works on the web and for mobile apps.

11711 students

Join a great company – 11711 Marketers, Product Managers, Software Engineers, and Entrepreneurs practice using data with SQL Habit.

Anatoli Makarevich, author of SQL Habit

Hi, my name is Anatoli or @makaroni4! 👋 For the last 10 years I’ve been typing SQL queries as a Software Engineer, CEO, Marketer, and Data Analyst. I’ve been working as a Lead Engineer in the Growth Team at Blinkist, helping it to grow to 16 million users.

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

Anatoli Makarevich, author of SQL Habit

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 converstion rates, measure organic and paid growth.

Data Analysis

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.

Mock Interviews

SQL Habit offers Mock Interviews – a special format dedicated to get you ready for an upcoming interview. 2 real-life challenges, 45 minutes, time is on!

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 SQL Habit 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 💊

Text analysis with SQL

In this chapter we’ll be learning about getting useful insights from text data using Pattern Matching, Regular Expressions; we’ll go over all String functions in 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 13 CHAPTERS

Reviews

IMO, SQL Habit is a MUST for every (aspiring) growth marketer! Other courses are usually very theory-driven, without any real-world applications. It's very likely that you discontinue, once your initial motivation spike drops. SQL Habit is very different because of its unique storytelling! You'll imagine yourself as an entrepreneur, founding and scaling your own startup. Because of this and despite...

Fabian, Data Analyst @1KOMMA5

Hi! I'm Yaroslav, and I'm pleased to share my experience using the SQL Habit resource. Over the past three months, I've become really interested in the field of analytics and data analysis. I started exploring various websites, videos, and courses. Finally, I discovered SQL Habit—and I immediately realized that it was exactly what I had been looking for: a well-structured theoretical foundation covering all the...

Yaroslav

After my experience as a Junior Product Manager, I felt I had only scratched the surface of a role I wanted to explore further — one that could represent an exciting career path. Following advice from trusted people, I decided to enroll in this SQL course. In the past, I had started a similar course but couldn’t complete it. This time was different: I completed all the lessons and took full advantage of the...

Carmine

Pick the plan that fits your needs

Employees of these companies study on SQL Habit

Empower your Marketing, Product, Data or Growth team to effectively make data-infromed decisions with SQL Habit. Explore Team Pricing

Frequently Asked Questions

How easy is it to cancel my subscription?

You’ll receive an email 72 hours before your next subscription cycle. You can also cancel your subscription from the profile page.

Can I try SQL Habit for free?

Absolutely. There’re 37 free course lessons and 23 practice exercises. Just signup with your email, no credit card info required.

Do you accept PayPal purchases?

Of course! 💯

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.

Can I purchase SQL Habit for my team/company?

What if I realize it’s not for me?

No problem! There’s a 14-day money back guarantee on all purchases. Ping me at support@sqlhabit.com and you’ll be refunded in full, no questions asked.