TABLE BASICS
STATEMENTS
CONDITIONAL OPERATORS
FUNCTIONS
JOINS
100
A unique identifier(employee id, or SSN, etc..)
What is A PRIMARY KEY?
100
This statement is used to specify conditional search
What is the WHERE Statement?
100
This operator specifies a range to test in your WHERE Statement
What is the BETWEEN operator?
100
Used to select a portion of a character string
What is a SUBSTR?
100
It allows you to link data from two or more tables together into a single query result--from one single SELECT statement.
What is a Join?
200
It's a key field(Column) in a database table, which relates the table to another table where the key is a primary key.
What is A FOREIGN KEY?
200
COLUMN NAMES OR "*"
What is followed after writing THE SELECT STATEMENT IN AN SQL QUERY?
200
It is a very powerful operator that allows you to select only rows that are like what you specify.
What is LIKE operator?
200

What does SQL stand for?

What is Structured Query Language?

200
Returns all rows that have matching value in the field on which the 2 tables are joined
What is the INNER JOIN?
300

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter".

What is SELECT * FROM Persons WHERE FirstName='Peter'?

300
SELECT [ALL | DISTINCT] column1[,column2] FROM table1[,table2] [WHERE "conditions"] [GROUP BY "column-list"] [HAVING "conditions] [ORDER BY "column-list" [ASC | DESC] ]
What are the five main clauses of the SELECT STATEMENT?
300
"%"
What is wild card operator?
300
Used to trim characters from the right of a string?
What is the RTRIM?
300
Compound query operator used to combine the results of 2 select statement without duplicating rows
What is UNION?
400
It is a database that has a collection of tables of data items, all of which is formely described and organized.
What is A Relational Database?
400
The keyword used to retrieve unique records in specified Columns?
What is The "DISTINCT" Keyword?
400
Only one of the condition specified by this Operator must be true
WHAT IS "OR" OPERATOR?
400

This SQL keyword is used to sort the result-set.

What is Order By?

400
What columns to join on. More joins typically means increased time to retrieve data. Ensure all joins are performed correctly and logically.
What is considerations when joining columns?
500
It is used to rename a table or column. The renaming of the table or column is temporary and does not change the actual name of the table in the database. More efficient programming; less keystrokes required
What is Aliases?
500
This CLAUSE CANNOT BE USED WITH AGGREGATES FUNCTIONS
What is THE HAVING CLAUSE?
500
The operator used for PATTERN MATCHING String
THE "LIKE" OPERATOR?
500

This operator is used to select values within a range.

What is Between?

500

This type of query is a SQL query inside another SQL query.

What is a Nested Query?

M
e
n
u