SQL for Beginners: What Aspiring Data Analysts Need First

SQL is the language used to ask questions of databases, and it appears in almost every data analyst job advert. The good news is that the basics are learnable in weeks, not years.

What SQL does

It lets you select, filter, combine and summarise data stored in tables.

The commands to learn first

  • SELECT to choose columns.
  • WHERE to filter rows.
  • ORDER BY to sort results.
  • GROUP BY with SUM, COUNT and AVG to summarise.
  • JOIN to combine tables.

How to practise

Use free online practice databases and set yourself real questions: which product sold most last month, which customers have not ordered in a year.

Show it to employers

Keep a few example queries and the questions they answer. Talking through them in an interview is powerful evidence.