SQL glossary: Novice level
23 SQL terms at the Novice level, each with a short definition and a link to its full page.
Updated
- ASC
- An ORDER BY direction that sorts from lower values to higher values.
- BETWEEN Condition
- The BETWEEN condition is used in a WHERE clause to determine if a value is in a given…
- CHECK Constraint
- A constraint requiring inserted or updated rows to satisfy a search condition.
- Column Alias
- A temporary output name assigned to a selected expression or column.
- Comparison Predicate
- A condition comparing values with operators such as =, <>, <, or >=.
- DEFAULT Clause
- A clause providing a value when an INSERT omits the column.
- DESC
- An ORDER BY direction that sorts from higher values to lower values.
- DISTINCT
- A SELECT option that removes duplicate rows from a result.
- FROM
- A query clause identifying the source tables, views, or derived tables.
- Logical Predicate
- A condition that combines or reverses other conditions with AND, OR, or NOT.
- NOT NULL Constraint
- A constraint requiring a column to contain a non-NULL value.
- NULL
- A marker indicating that a value is missing or unknown, rather than zero or an empty string.
- Numeric Literal
- A number written directly in a SQL statement.
- ORDER BY
- A clause that sorts a query result by one or more expressions.
- Query
- A request for data or another result from a database.
- Result Set
- The rows and columns produced by a query.
- SELECT
- A statement or query clause that chooses expressions and columns for a result.
- Snake Case
- All letters are lower case, each word is separated by an underscore.
- SQL Statement
- A complete SQL instruction sent to a database management system.
- String Literal
- Text written between single quotation marks in SQL.
- Structured Query Language (SQL)
- The standardized language for defining, querying, and changing relational data.
- UNIQUE Constraint
- A constraint preventing duplicate values or value combinations in specified columns.
- WHERE
- A query clause keeping only rows for which its condition is true.