Loading Data Driven Insights
Preparing your learning content.
Preparing your learning content.
A beginner-friendly guide to SQL keywords, what they do, and how SELECT, FROM, and WHERE are used to build simple SQL Server queries.
On this page
Jump to a lesson section
SQL keywords are special words used to write database instructions.
They tell the database what action you want to perform, which table you want to use, and how the result should be returned.
Keywords give SQL its meaning.
Without keywords, the database would not understand whether you want to read data, filter rows, sort results, group records, or change existing values.
SELECTChoose columnsFROMChoose a tableWHEREFilter rowsORDER BYSort resultsGROUP BYGroup dataHAVINGFilter grouped dataThe SELECT keyword chooses the columns you want to return.
The FROM keyword chooses the table where the data comes from.
SELECT
employee_name,
department
FROM Employees;
The WHERE keyword filters rows and returns only the records that match a condition.
In this example, the query returns only employees from the Sales department.
SELECT
employee_name,
department,
salary
FROM Employees
WHERE department = 'Sales';
Common SQL keywords can be grouped by what they do.
This makes it easier to understand why each keyword is used in a query.
Each keyword has a clear purpose and helps build meaningful database queries. Once you understand keywords like
SELECT,
FROM, and
WHERE, basic SQL queries become much easier to read and write.
SQL Roadmap Progress
Topic 4 of 111
4% complete
Next in SQL Roadmap
Continue with the next SQL topic in the recommended roadmap order.
Continue learning →