Practical SQL course for Marketers, Product Managers and Data Analysts

“emulates real business”

“no fuss, just things you actually need”

“well worth the money”

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

Mariia, Performance Marketing Lead @ CareerFoundry

Anatoli and SQL Habit have given a kickstart to a whole new approach to marketing analytics at CareerFoundry. We have a much clearer vision of how to connect the data from different sources. We now have a group of SQL enthusiasts from across the marketing team finding the answers to their questions in data and automating reports, that’s already saving a ridiculous amount of time.

Merlin, Data Science & Engineering Lead @ Phiture

The SQL Habit course is unique in terms of the holistic approach to mobile marketing. It covers everything from SQL basics to mobile attribution and A/B testing. What I find most impressive is the deep understanding one gains on how marketing data really works. I, therefore, recommend the course as a learning goal for consultants within our company.

Holger, CEO @ Blinkist

One of the most important practical skills I've learned in the early years of Blinkist has been SQL. It helped me to dig into our Marketing & Product data and quickly explore certain hypotheses I had. It has empowered me to take smarter decisions, avoid costly mistakes and has nurtured my intuition re: what works and what doesn't. I wish this course had existed 5 years ago and highly recommend you take a look - you'll learn from the best!

Rob, CEO @ Feather

It's amazing how an awareness for data is impacting every part of our business. SQL Habit has allowed me to dive into our data, and get a great feel for how things are working both in product and marketing. Going forward it allows us to set a very high bar for data collection and making use of it to inform decisions.

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!

20+ hours of materials

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

941 students

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

Meet the author

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. For the past 5 years, I’ve been working as a Lead Engineer in the Growth Team at Blinkist and helping it to grow to 14 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.

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 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 26 reviews

I am so excited that I have finally learnt SQL and realised how much I can gain from it in my daily work! The course gave me a better understanding of Marketing and Product Analytics — how data is tracked, stored and interpreted — on web and for mobile apps. I can't wait to put my new skills into practice! I have tested few SQL courses and I would highly recommend SQL Habit without a doubt! Thank you very...

Artur, Marketing Analyst @ Babbel

SQL was something I never touched before starting this course. But being a Product Designer, I often asked my colleagues about how many users saw a specific landing page, where did they come from, how many people signed up, etc. It made me want to learn more about the data behind those magic numbers I got from them all the time. This course was an incredible help to understand exactly that and it made me way more...

Franziska, Product Designer

Excellent course with in-depth coverage of various concepts. But not just that, the course compels you to dig deeper into the available data to understand where it comes from. The exercises along the way are challenging and fun. I thoroughly enjoyed it!

Chandricka, Junior UA Manger @ Phiture

Buy unlimited access to SQL Habit

FUNDAMENTALS

25 free lessons and exercises, no credit card required

Free

COMPLETE PACKAGE

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

$179

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 34 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