What am I
I'm used to return all records in a table
What's an asterick or wildcard?
What is a database?
WHERE appears after this clause
What is the FROM clause?
Order by
What is sort?
People often forget to use the punctuation at the end of a SQL statement
What is a semi-colon
What is an entity relationship diagram?
This number of SQL clauses
What is 6?
Use this in the if you want to filter missing values
What is "IS NULL"?
Where clause
What is filter?
This data type is the equivalent of a text or string
What is VARCHAR?
I'm used to count unique values
What is count(Distinct)?
This is short name for a column or table
What is an alias?
This can be used instead of an OR operator when searching a single column
What is IN()?
Case When
What is the if function?
This constraint prevents missing values in the column
What is NOT NULL?
If my column has this designation, I can be used to connect to a column in another
What is primary or foreign key?
You can only use this in the HAVING clause
What are aggregate functions?
This type of function is not allowed in the Where clause
What is an aggregate function?
Group By Clause
What is the pivot table, group, or group by in Power Pivot?
To add values to a table you need this
What is Insert Into?
I can be used to delete a table or column
What is the DROP command?
This type of JOIN is used to find missing data
What is left, right, or full-outer join?
Use this to return top or bottom 5 rows
What is a LIMIT 5 ?
Like Operator
What is Contain?
Create, Read, Update and Delete
What are CRUD commands?