Shared Flashcard Set

Details

Intro to Database Management
CH 6 Understanding the SQL Language
36
Computer Science
Undergraduate 4
07/17/2012

Additional Computer Science Flashcards

 


 

Cards

Term
SQL
Definition
Structured Query Language
Term
Interactive SQL
Definition
SQL Statements that you run directly, interacting with the database server
Term
Embedded SQL
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
SELECT
Definition
list the columns and expressions that should be returned from the query
Term
FROM
Definition
list the table(s) or view(s) from which data will be obtained
Term
WHERE
Definition
indicate the conditions under which a row will be included in the result
Term
GROUP BY
Definition
indicate categorization of results
Term
HAVING
Definition
indicate the conditions under which a category (group) will be included
Term
ORDER BY
Definition
sort the result according to specified criteria
Term
=
Definition
equal to
Term
>
Definition
greater than
Term
>=
Definition
greater than or equal to
Term
<
Definition
less than
Term
<=
Definition
less than r equal to
Term
<> or !
Definition
not equal to
Term
BETWEEN
Definition
is between the values specified
Term
IN
Definition
is in a list of specified values
Term
LIKE
Definition
matches a pattern (may include wild cards)
Term
IS NULL
Definition
is a null value
Term
%
Definition
Wildcard character that stands for zero to many characters you are searching for contain the character
Term
AND
Definition
joins two or more conditions and returns results only when all conditions are true
Term
OR
Definition
joins two or more conditions and returns results when any condition is true
Term
NOT
Definition
negates an expression
Term
+
Definition
addition
Term
-
Definition
subtraction
Term
*
Definition
multiplication or with SELECT statement means to select all
Term
/
Definition
division
Term
COUNT
Definition
number of occurrences
Term
MIN
Definition
minimum value
Term
MAX
Definition
maximum value
Term
SUM
Definition
sum of values
Term
AVG
Definition
average of values
Term
DESC
Definition
sorts the order in descending order (Highest to lowest)
Supporting users have an ad free experience!