SQL Clauses
Key Terms
Aggregate Functions
Regular Expressions
SQL Statements
100
SQL statement to display data from a table
What is "SELECT"?
100
A real world thing in the environment about which we wish to store information.
What is an "entity"?
100
SQL aggregate function to compute the minimum of the values in a column of numeric data.
What is "MIN"?
100

MySQL keyword to include regular expressions in the WHERE clause of a SELECT statement

What is "REGEXP"?

100
SQL statement to define a table
What is "CREATE" or "CREATE TABLE"?
200
clause for the SQL SELECT statement to specify the table(s) to display data from
What is "FROM"?
200
A query nested within the WHERE clause of another query
What is a "subquery"?
200
SQL aggregate function to compute the sum (total) of the values in a column of numeric data.
What is "SUM"?
200

Regular expression operator to match a string / pattern to a string / substring within a field value.

What are quotation marks ' '?

200

SQL statement to add one row to a table

What is "INSERT" or "INSERT INTO"?

300
clause for the SQL SELECT, UPDATE, or DELETE statements that specifies the conditions for the query.
What is "WHERE"?
300
This is used to temporarily rename a table or column heading with the SQL keyword AS.
What is an "alias"?
300
SQL aggregate function to compute the average of the values in a column of numeric data.
What is "AVG"?
300
Regular expression operator that is the alternation symbol to specify an OR within a regular expression.
What is the pipe "|"?
300

Used to change the database context to the specified database or database snapshot in SQL Server.

What is "USE"?

400
clause for the SQL CREATE TABLE statement specifying that a column value is required to have a value for each record
What is "NOT NULL"?
400
A two-dimensional table arranged in rows and columns.
What is a "relation"?
400
SQL aggregate function to compute the number of rows in a given table.
What is COUNT(*)?
400

Regular expression operator used to match the pattern after the symbol to the beginning of the field value

What is the caret symbol '^'?

400
SQL statement to edit / modify data in a table
What is "UPDATE"?
500
clause for the SELECT statement specifying that duplicate rows should be eliminated in the results.
What is "DISTINCT"?
500
A collection of relations
What is a "relational database"?
500
SQL aggregate function to compute the number of values in a given column in a table (not including NULL values).
What is "COUNT"
500

The regular expression operator to match the pattern before the symbol to the end of the field value

What is the dollar sign '$'?

500
SQL Statement to delete rows from a table
What is "DELETE"?
M
e
n
u