1/17
A set of vocabulary flashcards covering SQL sublanguages, constraints, clauses, functions, subqueries, and table join types from the lecture review questions.
DDL (Data Definition Language)
The SQL sublanguage used to create and modify database structures.
DML (Data Manipulation Language)
The SQL sublanguage primarily used for querying and updating data.
Foreign Key
A database feature whose main purpose is to link related tables.
Referential Integrity
A constraint requiring that a foreign key value must match a primary key value or be NULL.
CREATE VIEW
The CREATE statement that defines a logical table based on one or more tables.
DISTINCT
The SQL clause that removes duplicate rows from query results.
OR
The logical operator that returns rows when at least one condition is true.
GROUP BY
The SQL clause that groups rows for aggregate calculations.
HAVING
The SQL clause that filters groups after grouping has occurred.
COUNT(column_name)
An aggregate function that counts only rows containing non-NULL values in the specified column.
COUNT(*)
An aggregate function that counts all rows.
Natural/Inner Join
A type of join that returns only matching rows from both tables.
Self-Join
A join most commonly used when a table relates to itself through a unary relationship.
Correlated Subquery
A subquery that executes once for each row processed by the outer query.
ALTER TABLE … ADD
A SQL statement used to add a new column to an existing table.
IN Operator
A SQL operator used in a WHERE clause to filter rows matching any value in a specified list (such as 'CA' or 'TX').
Join Condition
A condition in a query whose primary purpose is to match related records across tables.
Left Outer Join
A join that returns all rows from the left table, including those that have no matching records in the joined table.