# What is SQL?

> SQL is the language for asking a database questions. What it is, why office teams use it for reports, and a free first report you can type in a browser.

Source: https://learn.ynteractive.com/content/glossary/sql · Updated 2026-10-24 · Free from Stepthrough (https://learn.ynteractive.com)

[Data, Sheets and Gmail](https://learn.ynteractive.com/content/glossary#topic-data-sheets-and-gmail) · [AI glossary](https://learn.ynteractive.com/content/glossary)

Quick answer

SQL (Structured Query Language) is the standard language for asking questions of a database: show these rows, add up that column, group the results by month. Almost every business database understands it, from accounting and order systems to data warehouses.

Last updated October 24, 2026

[Take the free module →](https://learn.ynteractive.com/courses/sql-for-business-reports/1)Module 1 of the free [SQL for Business Reports Jump Start](https://learn.ynteractive.com/courses/sql-for-business-reports) course, about 12 minutes. No account needed.

Updated October 24, 2026 · By [Robert Breen](https://learn.ynteractive.com/content/about)

## Why it matters for a small business

Most reports start as an export pasted into a spreadsheet and added up by hand. That takes time every month, and one missed row makes the report wrong. A SQL query asks the database directly, gives the same answer every time and can simply be run again next month.

You do not need to be a developer. A handful of words (SELECT, FROM, WHERE, GROUP BY, ORDER BY) cover most office reports, and free browser tools such as DB Fiddle let you practise with no install and no account.

## In a real lesson: SQL: Build a Monthly Revenue Report from an Orders Table

In the free [SQL monthly revenue lesson](https://learn.ynteractive.com/content/sql-monthly-revenue-report), Priya (made up), the office manager at Lakeside Office Supply, types eight Q3 orders into DB Fiddle and asks four questions: every order, September only, the quarter's total and revenue by month.

The last query, SELECT DATE_FORMAT(order_date, '%Y-%m') AS month, SUM(amount) AS revenue FROM orders GROUP BY month ORDER BY month, returns July $4,250, August $3,930 and September $3,160 in a fraction of a second.

[Try this lesson free](https://learn.ynteractive.com/modules/sql-monthly-revenue-report) or [read the step-by-step guide](https://learn.ynteractive.com/content/sql-monthly-revenue-report).

## Common confusions

### SQL vs a spreadsheet

A spreadsheet mixes data and calculations in cells. In SQL the data sits in tables and the question is a separate piece of text, so the same question works on next month's data unchanged.

### SQL vs MySQL or PostgreSQL

SQL is the language. MySQL, PostgreSQL, SQL Server and SQLite are databases that speak it, each with small differences, mostly in date functions.

## Tips

- Start every new question with SELECT * FROM orders LIMIT 10 (with your own table name) to see what the columns are called.
- Ask for read-only access at work: you can run reports without any risk of changing the data.

## Related terms

[GROUP BY (SQL)](https://learn.ynteractive.com/content/glossary/group-by) · [LEFT JOIN (SQL)](https://learn.ynteractive.com/content/glossary/left-join) · [Pivot table](https://learn.ynteractive.com/content/glossary/pivot-table) · [CSV](https://learn.ynteractive.com/content/glossary/csv)

## More Data, Sheets and Gmail terms

[SUMIF](https://learn.ynteractive.com/content/glossary/sumif) · Unstructured data · [Upsert](https://learn.ynteractive.com/content/glossary/upsert) · Web scraping

## Where you use it: free lessons

- [SQL: Build a Monthly Revenue Report from an Orders Table](https://learn.ynteractive.com/content/sql-monthly-revenue-report) (DB Fiddle, 12 min)
- [SQL: Top Customers and Key Accounts with GROUP BY and HAVING](https://learn.ynteractive.com/content/sql-top-customers) (DB Fiddle, 12 min)
- [SQL: Find Customers Who Have Gone Quiet with a LEFT JOIN](https://learn.ynteractive.com/content/sql-quiet-customers) (DB Fiddle, 15 min)
- [Build a Private Dashboard from Your Data in Lovable](https://learn.ynteractive.com/content/lovable-dashboard-with-login) (Lovable, 9 min)

## Frequently asked questions

**Is SQL hard to learn?**

The basics are not. SELECT, FROM, WHERE, GROUP BY and ORDER BY cover most business reports, and you can practise them free in a browser tool such as DB Fiddle.

**Do I need to install anything to practise SQL?**

No. DB Fiddle (db-fiddle.com) runs a real MySQL or PostgreSQL database in your browser with no account.

**Can SQL change or delete my data?**

Commands such as UPDATE and DELETE can. Reports only need SELECT, so ask for a read-only login and you cannot change anything by accident.

[All AI glossary terms, A to Z](https://learn.ynteractive.com/content/glossary) · [Free prompt templates](https://learn.ynteractive.com/content/prompts)