Settin up data analytics tools

Question 1

In a table, an attribute is a characteristic or quality of data used for what purpose

Answer 1

to label a column

Question 2

a request for data or information from a database

Answer 2

query

Question 3

We use a SQL query to retrieve information from a database. They add a WHERE statement to ____ the data based on certain conditions

Answer 3

filter

Question 4

what is the Syntex for every SQL query ?

Answer 4

Select, From, Where

Question 5

Select

Answer 5

specifies the columns from which to retrieve data

Question 6

From

Answer 6

specifies the table from which to retrieve data

Question 7

Where

Answer 7

specifies criteria that the data must meet

Question 8

unique set of guideline that programming language follow

Answer 8

syntax

Question 9

what does SQL query use to specify the data to be returned from the query

Answer 9

The Big Three SELECT,FROM,WHERE

Question 10

; (semicolon)

Answer 10

is a statement terminator

Question 11

tell the database to look for certain patterns

Answer 11

like

Question 12

how would you select all column?

Answer 12

SELECT*

Question 13

a temporary name for columns or table

Answer 13

Alias

Question 14

Asterisk

Answer 14

*