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