SQL Quiz #2 5/6/19
Syntax Rules
syntax refers to the rules that govern how a programming language must be written
Clause
a segment of an SQL statement combined to form a complete SQL statement
SQL Defined
SQL is a non procedural language used to manipulate and retrieve data from relational DBMSs. The focus is on what to retrieve, delete, or insert.
Sorting Data Using the WHERE Clause
The ability to sort data further enhances the data-retrieval process. Sorting data involves filtering and arranging retrieved data in a customized fashion. In SQL, this is achieved by using the following clauses: GROUP BY HAVING ORDER BY STARTING WITH WHERE
Asterisk wildcard Character(*)
When used with the LIKE operator, you can match any number of occurrences of any character.
Brackets wildcard character ([])
When used with the LIKE operator, you can specify a set of characters that match a character in a specific position.
LIKE operator
a character operator. when used in conjunction with asterisks or brackets, matches parts of a value within a table.
NOT operator
a logical operator used to match any condition opposite of the one defined
IN operator
a miscellaneous operator that provides a shorter method for specifying a range of conditions
Query
a question or command you pose concerning data from the database
Statement
keywords and data supplied within an SQL query
Arithmetic Operators
plus(+) minus(-) divide(/) modulus(%) multiply(*)
Keywords
reserved words that allow you to communicate with a database
Comparison Operators
the comparison operators are used to compare expressions. An expression is any data type that returns a value.
SELECT
used to tell the database which column(s) to display
FROM
used to tell the database which table to retrieve the columns from