Product SQL

Downloadable Code Files

Getting Started with Code Files

Getting Started

Introduction

Experiment Goals

Key Members

Product KPI

The North Star Metric

Driver Metric

Guardrail Metrics

Secondary Metrics

Segmentation Metrics

Launch Criteria

Experiment Data

Amazon AB Testing Case - Question

Amazon AB Testing Case - Solution

Code Walkthrough

Understand the Business Problem

State the Experiment Hypothesis

Hypothesis Statement

Significance Level

Statistical Power

Minimum Detectable Effect (MDE)

Design the Experiment

Randomization Unit

Sample Size Calculation

Experiment Duration

Run the Experiment

Experiment Platform

Peeking at P-Values

Assess Validity Threats

Stable Unit Treatment Value Assumption

Survivorship Bias

Sample Ratio Mismatch

Primacy Effect

Novelty Effect

Holiday Effect

Other Effects to Consider

AA Test

Conduct Statistical Inference

Chi-Squared Test of Independence

Z-Test for Proportions

T-Test for Means

Decide Whether to Launch

Interpret Test Results (Relative vs Absolute Difference)

Launch Decisions

Decision Rule

Decision Rule with Confidence Interval

Holdout Set

[Google] An experiment is statistically significant, but the sample is low. Should you change?

[Amazon] An AB test on "frequently bought together" showed improve in test, but not after launch. What happened?

[Amazon] New UI and algorithm are tested on product search. How would you design an experiment?

[Facebook] An experiment on News Feed showed increase in CTR, but the p-value is 0.06. Should you launch the change?

[Instacart] What are important statistical parameters in AB testing?

Interview Cases

[Amazon] Testing Recommender Systems

[Uber] Improving Driver Enrollment Rate

Mock Interviews

Master the art of SQL for product analytics by working with real-world datasets from leading tech companies like Meta, Amazon, Netflix, Google, OpenAI. This course is designed to help you build a strong foundation in data querying, product metrics, and performance analysis through hands-on SQL exercises and industry-relevant case studies. Whether you're a beginner or looking to refine your SQL skills, this course covers essential topics such as user behavior tracking, A/B testing analysis, retention metrics, and feature adoption, commonly used in data-driven product teams. With in-depth SQL challenges and 25+ curated lessons, this course provides an invaluable resource for anyone aspiring to leverage SQL for product analytics and land data roles at top tech companies.

Master SQL LAG and LEAD functions to compare rows within partitions. Learn how to access previous and next row values in SQL queries.

LAG and LEAD

Learn how to use SQL FIRST_VALUE, LAST_VALUE, and Nth_VALUE to retrieve specific row values in a partition. Perfect for advanced queries.

FIRST_VALUE, LAST_VALUE, Nth_VALUE

Understand SQL PARTITION BY to segment data within window functions. Learn how to group and analyze data efficiently in SQL queries.

PARTITION BY

Master SQL BETWEEN and PRECEDING for defining window frames. Learn how to control data range selection for advanced SQL analytics.

SQL BETWEEN and PRECEDING

Learn SQL ranking functions like ROW_NUMBER(), RANK(), and DENSE_RANK(). Master sorting and ranking data efficiently for analytics.

Ranking - ROW_NUMBER(), RANK(), DENSE_RANK()

Discover how to calculate running totals in SQL using window functions. Learn cumulative sums and moving averages for advanced analytics.

Running Totals

Analytical SQL

Learn how to use SQL GROUP BY to aggregate data and generate summary reports. Master counting, averaging, and grouping techniques in SQL queries.

GROUP BY

Filter aggregated results in SQL using the HAVING clause. Learn how to apply conditions to grouped data for precise query results.

HAVING

Aggregations

Eliminate duplicate rows in SQL queries with the DISTINCT keyword. Learn when and how to use it effectively in database queries.

DISTINCT

Optimize your SQL queries using the LIMIT clause to control the number of rows returned. Perfect for pagination and performance tuning.

LIMIT

Sort your SQL query results with the ORDER BY clause. Learn how to arrange data in ascending or descending order for better analysis.

ORDER BY

Learn how to use the SQL SELECT statement to retrieve data from databases efficiently. Master the foundation of SQL queries with practical examples.

SQL SELECT

SQL Basics

Retrieve data within a specific range using the SQL BETWEEN operator. Master how to filter numeric, date, and text values in your queries.

BETWEEN

Simplify multiple OR conditions in SQL using the IN operator. Learn how to filter records efficiently with a predefined list of values.

Use the SQL LIKE operator to perform pattern matching in text searches. Learn how to find partial matches in your database queries.

LIKE

Filter your SQL queries with the WHERE clause. Learn how to retrieve specific data based on conditions and improve database efficiency.

WHERE

Data Filtering

Learn how to use the SQL CASE statement for conditional logic in queries. Master dynamic column values and complex decision-making in SQL.

CASE

Use SQL COALESCE to handle NULL values effectively. Learn how to replace missing data and ensure accurate query results in SQL databases.

COALESCE

Master SQL date functions for handling timestamps and date calculations. Learn how to extract, format, and compare dates in SQL queries.

Date Manipulation

Learn SQL math functions to perform calculations on numerical data. Master arithmetic, rounding, and aggregate functions for data analysis.

Math Operations

Explore SQL string functions to manipulate text data. Learn how to concatenate, trim, replace, and format strings efficiently in SQL queries.

String

Data Transformation

Learn how SQL FULL OUTER JOIN returns all records from both tables, including unmatched rows. Ideal for comprehensive dataset merging.

FULL OUTER JOIN

Master SQL INNER JOIN to combine data from multiple tables based on matching values. Learn how to retrieve related records efficiently.

INNER JOIN

Learn SQL INTERSECT and EXCEPT operators to compare query results. Find common records or exclude unmatched data efficiently.

INTERSECT & EXCEPT

Understand SQL LEFT JOIN and RIGHT JOIN to merge data while preserving unmatched records. Learn key differences and practical use cases.

LEFT & RIGHT JOIN

Explore SQL SELF JOIN, a technique for joining a table to itself. Learn when to use it for hierarchical data and advanced queries.

SELF JOIN

Multiple Tables

Understand SQL Common Table Expressions (CTE) to simplify complex queries. Learn how to improve readability and performance in SQL.

Common Table Expressions (CTE)

Learn how to use SQL subqueries to nest queries inside other queries. Master filtering, aggregating, and optimizing complex SQL operations.