Term
|
Definition
Structured Query Language |
|
|
Term
|
Definition
SQL Statements that you run directly, interacting with the database server |
|
|
Term
|
Definition
SQL functionality embedded in a procedure or as part of an application program written in a different programming language. |
|
|
Term
DDL Data Definition Language |
|
Definition
statements that define a database, including creating, altering, and dropping tables and establishing constraints. CREATE, ALTER, DROP |
|
|
Term
DML Data Manipulation Language |
|
Definition
Statements that maintain and query data in a database. SELECT, INSERT, UPDATE, DELETE |
|
|
Term
DCL Data Control Language |
|
Definition
statements that control a database, including administering privileges and committing data |
|
|
Term
|
Definition
list the columns and expressions that should be returned from the query |
|
|
Term
|
Definition
list the table(s) or view(s) from which data will be obtained |
|
|
Term
|
Definition
indicate the conditions under which a row will be included in the result |
|
|
Term
|
Definition
indicate categorization of results |
|
|
Term
|
Definition
indicate the conditions under which a category (group) will be included |
|
|
Term
|
Definition
sort the result according to specified criteria |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
is between the values specified |
|
|
Term
|
Definition
is in a list of specified values |
|
|
Term
|
Definition
matches a pattern (may include wild cards) |
|
|
Term
|
Definition
|
|
Term
|
Definition
Wildcard character that stands for zero to many characters you are searching for contain the character |
|
|
Term
|
Definition
joins two or more conditions and returns results only when all conditions are true |
|
|
Term
|
Definition
joins two or more conditions and returns results when any condition is true |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
multiplication or with SELECT statement means to select all |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
sorts the order in descending order (Highest to lowest) |
|
|