Academy

Why we still teach business analysts SQL by hand.

A short defence of fundamentals in a world of dashboards and AI-generated queries.

With modern reporting tools and AI that can write queries on request, students sometimes ask why we still make them write SQL by hand. Our answer is simple: you can't check what you don't understand.

Data questions are business questions

"How many customers dropped out at the payment step last month?" is a business question. Answering it means knowing where the data lives, how the tables join and what the edge cases are. A BA who can do that answers in minutes instead of waiting days for someone else.

Generated queries still need checking

AI tools are useful, and we teach students to use them. But a query that runs isn't the same as a query that's right. Duplicate rows from a bad join, a filter on the wrong date field, test data left in: these mistakes look fine until a decision is made on the wrong number.

What we actually teach

  • SELECT, WHERE and ORDER BY on real-looking business data
  • Joins, and how they go wrong
  • GROUP BY and simple aggregates for reporting
  • Reading a query someone else wrote and explaining it in plain English
  • Sense-checking results against what you expect

The payoff

Graduates who are comfortable with data are more confident in requirements sessions, better at spotting gaps, and more useful from their first week. Explore our courses at TemTed Academy.

Keep reading

More from TemTed.