NEW
Font size
WorksheetsSQL Quiz
Total questions: 7
Worksheet time: 4mins
Primary Keys
almost like an SS number (unique indentifier column ) for rows in a table; define them
ignored in SQL
use for future reference to avoid confusion
used for queries within a specific range
AND Operator
conditional that needs to be met by all terms
converts a string to uppercase
explicitly group related operators with parenthesis
used for rows in tables that may not be related
LEFT JOIN
deletes all rows from a table
column rows NULL values are ignored by the min function
can be turned into a RIGHT JOIN if you switch the order of the "FROM" and "WHERE" clause.
Used for adding new info to a database , make sure to put column names with values.
TRUNCATE TABLE
Copy contents from one table into a brand new table
deletes all rows from a table
Allows for quick imports of data instead of one at a time
use CREATE VIEW to make a virtual table
EXTRACT ()
temporary name given to Table names
returns a column's lowest value
Used to extract part of a date with year
column rows NULL values are ignored by the min function
UNION
rows from first table * rows from second table
used to select multiple specific WHERE clauses, needs to have same columns, expressions or aggregate functions, and compatible (removes duplicate rows)unless you use ______ ALL
name of table + list of changes to be made
Sorts the data and then separates the data accordingly (by the group identifier)
Subqueries
Copy contents from one table into a brand new table
conditional that needs to be met by all terms
more powerful way to write queries (multiple for one combo); make sure to indent and color code each section
returns the string's soundex value (four character code that is based on how the string sounds when spoken in English
