SQL Basics
This clause specifies the fields you want to display.
What is SELECT?
This operator is used with wildcards to find patterns.
What is LIKE?
This type of key links a table to a primary key in another table.
What is a foreign key?
A value created during a query rather than stored in the database.
What is a computed/calculated value?
This clause groups rows with identical values into summary rows.
What is GROUP BY?
This clause tells SQL where the data comes from.
What is FROM?
This wildcard represents zero, one, or many characters.
What is *?
The process of linking multiple tables together.
What is a join?
This keyword gives a column a temporary name.
What is AS (alias)?
The rule stating that all non-aggregate fields must appear here.
What is the GROUP BY clause?
This clause filters records based on conditions.
What is WHERE?
This wildcard represents exactly one character.
What is ?
The number of joins needed when using 3 tables.
What is 2 joins?
This function returns the number of records.
What is COUNT?
The number of results returned by an aggregate function without grouping.
What is one result?
SQL is described as this type of language—you say what you want, not how to get it.
What is a declarative language?
The SQL condition to find all surnames ending in “son”.
What is WHERE Surname LIKE '*son'?
The problem caused when you forget to link tables correctly.
What is a Cartesian product/Referential Integrity?
This function calculates the mean value.
What is AVG?
The correct order: SELECT → FROM → WHERE → ___ → ___.
What is GROUP BY→ORDER BY?