1/6
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
---|
No study sessions yet.
attribute
a characteristic or quality of data used to label a column in a table
observation
all the attributes for something contained in a row of a data table
query
request for data or information from a database
What is the basic structure of an SQL query?
select, from, where
What is a good rule of thumb when writing an SQL query?
start big (data table) and go small (specific conditions)
What comes first, the dataset name or table name?
dataset name
like clause
tells database to look for a certain pattern