Module 3 Flashcards
Attribute
a characteristic or quality of data used to label a column in a table
Observation
All of the attributes for something contained in a row of a data table
Formula
A set of instructions that performs a specific action using the data in a spreadsheet
Query
A request for data or information from a database
Syntax
the predetermined structure of a language that includes all required words, symbols, and punctuation, as well as their proper placement.
What are the 3 most important keywords when it comes to SQL
Select, From, Where
Select
Specifies the columns from which to retrieve data
From
Specifies the table from which to retrieve data
Where
Specifies criteria that the data must meet
Like clause
allows you to tell the database to look for certain patterns
Alias
Assigning a new name
