SQL Midterm

Relational Database

Logically related data

What does SQL stand for?

Structured Query Language

DDL

DML

What are different words for Table?

Relation, File

What are different words for Column?

Attribute, Field

What are different words for Row?

Tuple, Record, Observation

Schema

Primary Key

unique

Every attribute MUST have an _______

Atomic Datatype

DISTINCT removes what?

Duplicates

Default for ORDER BY

Ascending

What is a Wild Card?

The * symbol

WHERE Clause

Filters rows BEFORE any grouping or aggregation

%

represents zero, one, or multiple characters

GROUP BY

Groups rows that share a value (USED IN AGGREGATION)

HAVING Clause

Filters groups AFTER aggregation (used with GROUP BY).

AND

requires ALL conditions to be true

ORDER BY

Sorts the QUERY RESULT set by one or more columns