BASIC DATABASE
Two-dimensional structure with rows and columns.
What is a table?
Specifies how data is sorted in a results set.
What is the ORDER BY clause?
'Invented' the relational database.
Who is E.F. Codd?
This type of join returns only matching records from both tables
What is INNER JOIN?
This clause groups data by one or more columns.
What is GROUP BY?
A type of database that 'relates' tables to each other.
What is a relational database?
In a SQL query, specifies the table that data is selected from.
What is the FROM clause?
Use the syntax /* */ or --
How do you add comments to SQL?
This type of join returns all records from the right table and matching records from the left table.
What is RIGHT JOIN or RIGHT OUTER JOIN?
This clause filters grouped data based on conditions.
What is HAVING?
This uniquely identifies a row in a table.
What is a primary key?
Selects everything from the PERSON table.
What does the following query do? SELECT * FROM PERSON;
Click the 'EXECUTE' command on the toolbar.
How do you 'run' a SQL Query?
This type of join returns all records from the left table and matching records from the right table.
What is LEFT JOIN or LEFT OUTER JOIN?
A query within a query, used for complex conditions.
What is SUBQUERY?
Contains the smallest unit of meaningful information in a row/record.
What is a field?
Allows you to specify pattern matches for data retrieval values.
What does IN allow you to do in SQL?
This SQL function returns the number of rows in a result set.
What is COUNT()?
This type of join returns all records from both tables, with null values in unmatched rows.
What is FULL OUTER JOIN?
This type of subquery is used with the IN or NOT IN operators.
What is Multiple-Row Subquery?
Processing is divided between client and server.
What is a client-server system?
WHERE Weight is between 2000 and 3000 OR Where Weight is > 1999 and < 3001 OR WHERE Weight is >= to 2000 and <=3000
What WHERE clause will select weight values between 2000 and 3000?
This SQL keyword is used to filter data based on a specified condition
What is WHERE?
This clause is used to specify the join condition in a SQL query.
What is ON?
This is a BONUS questions
Is this a BONUS?