BUS 421 ch. 4 Accessing market data using SQL

___ JOIN = Only displays data that has matching records/rows in both tables. ___ JOIN = Displays all data from the left table, and matching records from the right table. ___ JOIN = Use all records from the right table and the matched records from the left table ___ JOIN = Displays all data from both tables, together.

INNER LEFT RIGHT FULL

THE 4 types of JOINS?

INNER JOIN FULL JOIN LEFT JOIN RIGHT JOIN

The 2 biggest language categories of SQL: ____ functions and ____functions.

table query

Combining conditions involves:

AND OR NOT -> reverses the meaning NOT TRUE = FALSE NOT FALSE = TRUE

SQL Query Functions -> SQL Queries have functions that allow us to analyze pulled information. ___ = Reveals the number of rows (respondents/products/etc.) that fit the stated criteria. ___ = returns the average value of a numeric column. ___ = returns the total sum of a numeric column. ___ = returns the largest value that matches a specified criteria. ___ = returns the smallest value that matches a specified criteria.

COUNT () AVG () - EX: avg. age of all employees at the company SUM () MAX () MIN () - EX: determine the employee who made the least or most sales during the first quarter of 2016.

___ = This command shows the unique rows from the selected table without any duplicates. For example, to display the price of the products without duplicates, the command is: SELECT DISTINCT price FROM product ____ = This command orders the rows based on a column of interest. Columns can be sorted in either ascending or descending order. (Note: The order of the columns is *ascending* by default.) For example, to display product information and sort by price in descending order, the command is: SELECT productid, type, price, name, color, inventory FROM product WHERE price > 10 ORDER BY price DESC

DISTINCT ORDER BY

The command "___" labels which two tables to be joined.

ON

__ = are SQL commands that ask questions of the data. __ = are commands that manage and change tables within the database.

Query functions table functions

___ = This command will pull specific data from the table being accessed on a relational database, such as customer names or emails. ____ = This command determines which table the data is pulled from. ____ = This command specifies a certain condition desired in the outcome. ____ = This function tells SQL how to segment the data that is selected. ____ = This command temporarily combines two tables of data. EX: SELECT CustomerID, CustomerName FROM CustomerDemo WHERE Age=25 JOIN GROUP BY State

SELECT FROM WHERE GROUP BY JOIN

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

SQL