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
Used to combine Strings
What is the ||?
200
Returns all rows that have matching value in the field on which the 2 tables are joined
What is the INNER JOIN?
300
The process of arranging information in a way, which removes redundancy and ambiguity
What is Normalization?
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
The Symbol used for outer joins in ORACLE?
What is the (+)?
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
Considerations for joining tables in queries
what columns to Join on, Beware of cross joins(Cartesian Product), ensure all joins are performed correctly and logically.
500
it is the result of “no join” if you select from two or more tables without joining, the result is all possible rows from both tables
ADAM WILL COME SEE YOU IF YOU DO THIS IN ORACLE PROD!!