BA Toolkit / Data & analytics

SQL

The language for asking questions of a database.

What it is

SQL (Structured Query Language) is used to read and change data in relational databases. With SELECT, JOIN, GROUP BY and WHERE you can answer most questions straight from the source.

How a Business Analyst uses it

  • Check what the data actually says before writing a requirement
  • Validate that a new feature stores and returns the right data
  • Profile data quality ahead of a migration
  • Pull the numbers for a business case without waiting on a data team

Practical tip

Learning joins and GROUP BY covers most BA questions. You don’t need to be a developer.

Where I've used it

I’ve used SQL from my BSc onwards: analysis at Host My Code, reviewing queries with developers at AseUp Consultancy, and during my MSc at the University of Bristol.

Related tools

← Back to the full toolkit

Need a Business Analyst who knows these tools?

I use these tools to turn business problems into clear requirements and measurable results.

Scroll to Top