Table of Contents

SQL Habit has 2 main parts – course aka "business simulator" and practice exercises. Practice exercises are standalone and based on various datasets, where the course is based on a story of a fictional startup company called Bindle.

Bindle is a subscription service for reading books online. The course starts with a launch of Bindle's website and together with the founders will learn how to analyze website performance, marketing performace, dive into analytics of web and mobile apps and much more.

The course covers the first year of Bindle. Each chapters covers one month focused on a specific topic. During each chapter we'll see many real life example in the life of Bindle, learn how data helps to take decisions and solve them. The most important – we'll learn all nuances of how data is recorded and stored in Bindle's data warehouse.

The course requires no prio knowledge of SQL. It'll take you from absolute 0 to Advanced with real life examples, lessons and exercises.

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 💻