Show:
TABLE BASICS
STATEMENTS
CONDITIONAL OPERATORS
Normalization
JOINS
100
A unique identifier(employee id, or SSN, etc..)
What is A PRIMARY KEY?
100
This statement is used to specify a 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
A table that does not contain a repeating group in which multiple entries exist on a single row.
What is the First Normal Form?
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
This follows directly after writing the SELECT statement in an SQL query?
What are COLUMN NAMES OR "*"?
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
A table in the second normal form and the only determinants it contains are candidate keys.
What is Third Normal Form?
200
Returns all rows that have matching value in the field on which the 2 tables are joined
What is the INNER JOIN?
300
Operator that specifies a range of values in a condition
What is BETWEEN?
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
The process of arranging information in a way, which removes redundancy and ambiguity
What is Normalization?
300
Compound query operator used to combine the results of 2 select statement without duplicating rows
What is UNION?
400
A question represented in a way that the DBMS can understand
What is a query?
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 the "OR" operator?
400
A table that has no nonkey column that is dependent on only a portion of the primary key.
What is second normal form?
400
When you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in a second table.
What is an OUTER JOIN?
500
yyyy/mm/dd
What is the date format in MySQL?
500
This clause cannot be used with aggregate functions.
What is THE HAVING clause?
500
The operator used for PATTERN MATCHING String
What is the "LIKE" operator?
500
It is a database that has a collection of tables of data items, all of which is formerly described and organized.
What is A Relational Database?
500
The product of two tables is the combination of all rows in the first table and all rows in the second table.
What is a Cartesian Product?