SQL for Product Managers
Where PMs Actually Sit Between Dashboards and Raw Data
You are not trying to become a data engineer. You are trying to become fluent enough to not need one for the questions that are genuinely yours to answer.
There is a real, useful division of labor here, and knowing where the line sits will save you from two opposite failure modes: PMs who refuse to touch SQL and become bottlenecked on every small question, and PMs who write increasingly complex queries on production databases without understanding the blast radius of what they're doing.
Task | Yours to do | Better left to a data engineer or analyst |
|---|---|---|
A quick filtered count or breakdown for a decision this week | Yes | |
Exploring a hypothesis before committing engineering time to build a dashboard | Yes | |
Sanity-checking a number that looks surprising | Yes | |
Building a query that will run in production on a schedule, powering a live dashboard | Yes, for performance and reliability reasons | |
A query joining a dozen tables with business logic nobody has fully documented | Yes, at least the first time, with you learning from how they built it | |
Defining what a metric should mean (what counts as "active," what counts as "churned") | Yes, this is a product decision expressed in SQL, not an engineering one | |
Optimizing a slow query running against billions of rows | Yes |
The pattern in that table: anything that's fundamentally a product question, expressed through data, is yours. Anything that's fundamentally an infrastructure or engineering concern belongs to the people whose job that is. SQL fluency doesn't erase that line. It just means you're a much better collaborator on the right side of it and fully self-sufficient on the left.
FIELD NOTE
A useful test: can you personally answer "how many new users signed up last week" without asking anyone? If not, that's not a data problem, that's a fluency gap, and it's the first one this course closes.
YOUR MOVE THIS WEEK
Write down one recurring question you ask your data team more than once a month. That's your first candidate for "should learn to answer myself."