SQL (Structured Query Language) is used to communicate with databases.
A database stores information.
A table contains:
- Rows (records)
- Columns (fields)
Example:
Students
| Name | Age | CGPA |
|---|---|---|
| Mary | 22 | 3.90 |
SELECT
FROM
WHERE
AND
- = all columns
= = greater than or equal to
<= = less than or equal to
= equals
- Selecting all columns
- Selecting specific columns
- Filtering data with WHERE
- Using AND
- Reading SQL syntax