Module 3 - The ins and outs of core data tools Flashcards
1
Q
Attribute
A
A characteristic or quality of data used to label a column
2
Q
Observation
A
All of the attributes for something contained in a row of a data table
3
Q
What databases use SQL?
A
Relational databases
1. MySQL
2. PostgresQL
3. Microsoft SQL Server
4. Oracle
4
Q
Query
A
A request for data or information from a database
5
Q
Syntax
A
The predetermined structure of a language that includes all required words, symbols, and punctuation, as well as their proper placement.
6
Q
SELECT
A
Specifies the columns from which to retrieve data
7
Q
FROM
A
Specifies the table from which to retrieve data
8
Q
WHERE
A
Specifies criteria that the data must meet
