SQL Concepts and Statement Evaluation Flashcards

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/17

flashcard set

Earn XP

Description and Tags

A set of vocabulary flashcards covering SQL sublanguages, constraints, clauses, functions, subqueries, and table join types from the lecture review questions.

18 Terms

1
New cards

DDL (Data Definition Language)

The SQL sublanguage used to create and modify database structures.

2
New cards

DML (Data Manipulation Language)

The SQL sublanguage primarily used for querying and updating data.

3
New cards

Foreign Key

A database feature whose main purpose is to link related tables.

4
New cards

Referential Integrity

A constraint requiring that a foreign key value must match a primary key value or be NULL.

5
New cards

CREATE VIEW

The CREATE statement that defines a logical table based on one or more tables.

6
New cards

DISTINCT

The SQL clause that removes duplicate rows from query results.

7
New cards

OR

The logical operator that returns rows when at least one condition is true.

8
New cards

GROUP BY

The SQL clause that groups rows for aggregate calculations.

9
New cards

HAVING

The SQL clause that filters groups after grouping has occurred.

10
New cards

COUNT(column_name)

An aggregate function that counts only rows containing non-NULL values in the specified column.

11
New cards

COUNT(*)

An aggregate function that counts all rows.

12
New cards

Natural/Inner Join

A type of join that returns only matching rows from both tables.

13
New cards

Self-Join

A join most commonly used when a table relates to itself through a unary relationship.

14
New cards

Correlated Subquery

A subquery that executes once for each row processed by the outer query.

15
New cards

ALTER TABLE … ADD

A SQL statement used to add a new column to an existing table.

16
New cards

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').

17
New cards

Join Condition

A condition in a query whose primary purpose is to match related records across tables.

18
New cards

Left Outer Join

A join that returns all rows from the left table, including those that have no matching records in the joined table.