Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 4: Assessing marketing data using structured query language

memorize.ai (lvl 286)

(0)

28 cards

()

Section 1

Preview this deck

this summary query generates the largest value that fits a specified criteria while this query generates the smallest value that fits a specified criteria

Front

1 / 28

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (28)

Section 1

(28 cards)

this summary query generates the largest value that fits a specified criteria while this query generates the smallest value that fits a specified criteria

Front

MAX MIN

Back

this type of join displays all data from both tables, together

Front

full join

Back

_____ is needed in order to interact with a relational database for giving access to, combining and changing databases.

Front

SQL

Back

what are the two biggest language categories of SQL

Front

table functions query functions

Back

SQL commands that can answer questions of the data =

Front

summary queries

Back

list the five types of summary queries

Front

COUNT() AVG() SUM() MAX() MIN()

Back

the _ clause is used to filter records from a result. The filter occurs before any groupings are made. a clause is used to filter values from a group.

Front

WHERE HAVING

Back

this function gathers specific data from a table

Front

select

Back

this type of summary query generates the average value of a numeric column

Front

AVG

Back

this type of join displays all data from the right table and matching records from the left table

Front

right join

Back

this summary query generates the sum of a numeric column

Front

SUM

Back

this function establishes which table the data is gathered from

Front

FROM

Back

this function displays data that is a combination of two conditions i.e once can display the employees from the sales department between the ages of 18-25 and live in CA

Front

AND()

Back

the functions from SQL commands allow us to ____

Front

analyze pulled information

Back

list the types of query functions

Front

select from where join group by

Back

this function combines two tables of data. the command "ON" labels which two tables to be joined

Front

JOIN

Back

This function tells SQL how to segment the data that is selected

Front

GROUP BY

Back

this type of join only displays data that has matching records in both tables

Front

inner join

Back

this function defines a specific condition desired in the outcome

Front

WHERE

Back

placeholder for no data

Front

Is Null

Back

commands that manage and change tables within a database are known as

Front

query functions

Back

this query function displays data between a specific range of values i.e between the ages of 18-25

Front

BETWEEN

Back

4 variations of join

Front

inner join left join right join full join

Back

why is SQL important?

Front

because it is the language you use to interact with a database

Back

this type of join displays all data from the left table, and matching records from the right table

Front

left join

Back

this type of summary query reveals the number of rows that fit the stated criteria

Front

COUNT

Back

3 important aspects of SQL

Front

make data driven decisions, leverage valuable customer information, and understand metrics for marketing

Back

list the two other SQL query functions

Front

BETWEEN() and AND()

Back

Chapter 4: Assessing marketing data using structured query language

Preview this deck

this summary query generates the largest value that fits a specified criteria while this query generates the smallest value that fits a specified criteria

0.0

Cards (28)

this summary query generates the largest value that fits a specified criteria while this query generates the smallest value that fits a specified criteria

MAX MIN

this type of join displays all data from both tables, together

full join

_____ is needed in order to interact with a relational database for giving access to, combining and changing databases.

SQL

what are the two biggest language categories of SQL

table functions query functions

SQL commands that can answer questions of the data =

summary queries

list the five types of summary queries

COUNT() AVG() SUM() MAX() MIN()

the _____ clause is used to filter records from a result. The filter occurs before any groupings are made. a ____ clause is used to filter values from a group.

WHERE HAVING

this function gathers specific data from a table

select

this type of summary query generates the average value of a numeric column

AVG

this type of join displays all data from the right table and matching records from the left table

right join

this summary query generates the sum of a numeric column

SUM

this function establishes which table the data is gathered from

FROM

this function displays data that is a combination of two conditions i.e once can display the employees from the sales department between the ages of 18-25 and live in CA

AND()

the functions from SQL commands allow us to ____

analyze pulled information

list the types of query functions

select from where join group by

this function combines two tables of data. the command "ON" labels which two tables to be joined

JOIN

This function tells SQL how to segment the data that is selected

GROUP BY

this type of join only displays data that has matching records in both tables

inner join

this function defines a specific condition desired in the outcome

WHERE

placeholder for no data

Is Null

commands that manage and change tables within a database are known as

query functions

this query function displays data between a specific range of values i.e between the ages of 18-25

BETWEEN

4 variations of join

inner join left join right join full join

why is SQL important?

because it is the language you use to interact with a database

this type of join displays all data from the left table, and matching records from the right table

left join

this type of summary query reveals the number of rows that fit the stated criteria

COUNT

3 important aspects of SQL

make data driven decisions, leverage valuable customer information, and understand metrics for marketing

list the two other SQL query functions

BETWEEN() and AND()

the _ clause is used to filter records from a result. The filter occurs before any groupings are made. a clause is used to filter values from a group.