| A | B |
|---|
| SELECT | Keyword in SQL that selects all or some of the columns in a table |
| WHERE | Keyword that restricts the rows coming back in a SQL query |
| FROM | Keyword that tells the database which table to pull the data out of for query |
| Asterisk (*) | Symbol used to select all columns for a table |
| SUM | Aggregate function that give the sum of that particular column |
| AS | Keyword that allows the user to alias a column name |
| COUNT | Aggregate function that allows the user to count all the rows in a particular column or table |
| Database | A collection of tables |
| LIKE | Wildcard string operator for the WHERE clause (allows users to search by a certain letter, number or part of a word) |
| GROUP BY | Groups rows together for aggregate functions (Count, SUM, AVG) |
| HAVING | Keyword that filters group by statements like WHERE does for SELECT |
| DML | Data Manipulation Language, (insert, update, delete) |
| DDL | Data Definition Language (Alter, Create, Drop) |
| DCL | Data Control Language (Grant, Revoke) |
| INSERT | Adds a new record to the table |
| UPDATE | Modifies a record in a table |
| = | Single operator, needs to equal the data exactly in order to bring back information |
| IN | Used in the where clause, can ask for multiple values to be brought back from table |
| AND | Logical operator where both conditions need to be true |
| OR | Logical operator where only ONE of the conditions needs to be true |
