SQL for Data Analytics · Answering a business question
Answering a business question
So far you've learned the tools for getting information out of a database, like SELECT, WHERE, GROUP BY, and HAVING. This unit is about what you use them for. Real data analytics isn't somebody handing you a list of queries to write. It's a problem you work through. Somebody has a question, and you work out what they actually need, what the data can and can't tell you, and whether what you found is true. The queries are how you get at the data along the way.
The lessons:
- An example analysis (28 min). A video where I take a vague request from start to finish.
- What is one row? (15 min). A game studio's request that the rest of the unit works through. Introducing the video game table, what a row in it means, and COUNT(DISTINCT).
- Checking your answer (30 min). A worked example of a correct query with a misleading result, and what it takes to notice. Then sanity checks and drilling down, two ways to verify results yourself.
When you've finished the lessons, do the Practice. It's fifteen questions. Part 1 gets you familiar with the video game table. Part 2 is practice with publishers, and Part 3 works through the rest of the game studio's request. This is what you turn in on Canvas.