10 terms

Advanced SQL

STUDY
PLAY

Terms in this set (...)

Data Definition Language
-define database schemas (creating, altering dropping tables and constraints)
-used by database developers
Data Manipulation Language
-query and maintain a database (selecting inserting, updating, and deleting data
-used by database users
Data Control Language
-controls database security and access (administering privileges and committing transactions)
-used by DBAs
DML Statements
-Select (query existing data)
-Insert (add new data)
-Update (modify existing data)
-Delete (remove existing data)
Select statement keyword order
Select, from, where, group by, having, order by
AND
two or more conditions hold at the same time (intersection)
OR
and of the conditions hold (union)
NOT
negates condition, reverses logical expression
BETWEEN
inclusive AND for ranges
Why are views beneficial?
-Programmatic benefit because reduces processing
-Restricts what users can access the base tables (Security)
-Avoids data redundancy
-Handles derived data