THE CORE AIM OF VOCABULARY MASTERY · SQL VOCABULARY · SELECT → FILTER → JOIN → GROUP → TRANSACT
SQL vocabulary is the language used to describe how relational data is queried, filtered, combined, aggregated and modified. Terms such as SELECT, WHERE, JOIN, GROUP BY, HAVING, subquery, CTE, transaction and index matter because SQL is both a programming language and a precise vocabulary for asking questions of structured data.
The core aim of vocabulary mastery for SQL vocabulary is query clarity. Learners should be able to describe what rows are being selected, what condition filters them, how tables relate, what is being grouped and what aggregation or transaction is being performed.
This page is the SQL Vocabulary owner inside the eduKateSG Vocabulary hub. For relational structure, use Database Vocabulary. For analytical work, use Data Science Vocabulary.
Central proposition: SQL vocabulary is mastered when the learner can translate a data question into relational operations and explain why each clause is present.
The 60-Second SQL Vocabulary Router
- Retrieve: SELECT, FROM, column, alias.
- Filter: WHERE, condition, predicate, NULL.
- Combine: JOIN, INNER, LEFT, key, relationship.
- Aggregate: GROUP BY, COUNT, SUM, AVG, HAVING.
- Compose: subquery, CTE, window function.
- Change: INSERT, UPDATE, DELETE, transaction.
The SQL Vocabulary Architecture
| Operation | Core terms | Core question |
|---|---|---|
| Select | SELECT, column, alias | What fields should be returned? |
| Filter | WHERE, predicate | Which rows qualify? |
| Join | INNER, LEFT, key | How do tables connect? |
| Aggregate | GROUP BY, COUNT, SUM | How are rows summarised? |
| Order | ORDER BY, LIMIT | How are results arranged or restricted? |
| Modify | INSERT, UPDATE, DELETE | How is stored data changed? |
WHERE and HAVING Are Different
WHERE filters rows before aggregation. HAVING filters groups after aggregation. A useful memory rule is: WHERE decides which rows enter the grouping; HAVING decides which grouped results remain.
A Worked Example: INNER JOIN vs LEFT JOIN
An INNER JOIN returns rows with matching relationships on both sides. A LEFT JOIN keeps all rows from the left table and includes matching rows from the right where available. The vocabulary determines whether missing matches disappear or remain visible.
A Worked Example: GROUP BY
GROUP BY forms groups of rows that share selected values so aggregate functions such as COUNT, SUM or AVG can be calculated per group. The term is about changing the level of analysis from individual rows to grouped summaries.
CTEs and Subqueries
A subquery is a query nested inside another query. A common table expression, or CTE, gives a temporary result set a name for use within the statement. Both can decompose complex logic, but CTEs often improve readability in multi-step analysis.
Window Functions
Window functions calculate values across related rows without collapsing them into one row per group. Terms such as PARTITION BY, ORDER BY, ROW_NUMBER and running total are central to analytical SQL.
How to Learn SQL Vocabulary
- Write the data question in plain English first.
- Identify tables and keys.
- Build SELECT and WHERE before adding joins.
- Compare INNER and LEFT joins on the same data.
- Practise aggregation and HAVING.
- Use EXPLAIN or query plans to connect SQL with performance.
- Read the result after every clause change.
Common SQL Vocabulary Mistakes
Confusing WHERE and HAVING
Repair: separate row filtering from group filtering.
Joining without understanding keys
Repair: draw the table relationship before writing the JOIN.
Using SELECT * everywhere
Repair: name the fields required by the question.
Treating NULL as zero or empty string
Repair: understand NULL as missing or unknown according to SQL semantics.
Frequently Asked Questions
What is SQL vocabulary?
It is the specialised language used to query, join, aggregate and modify relational data.
What SQL terms should beginners learn first?
Start with SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, INSERT, UPDATE and DELETE.
What is the difference between WHERE and HAVING?
WHERE filters rows before grouping; HAVING filters grouped results after aggregation.
What is a CTE?
It is a named temporary result set defined within a SQL statement for use by the main query.
How can I learn SQL vocabulary?
Work with a small relational database and translate real questions into queries clause by clause.
Where This Article Fits in the eduKateSG Vocabulary Ecosystem
- Vocabulary Hub — the broad route.
- Database Vocabulary — relational structure.
- Data Science Vocabulary — analysis.
- Data Engineering Vocabulary — pipelines.
- Programming Vocabulary — general coding concepts.
The SQL Vocabulary Standard
SQL vocabulary reaches its core aim when the learner can explain what each clause does to the data and why the resulting rows answer the intended question.
That is the standard: query language tied directly to relational reasoning.