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) |
|
|
