Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
DDL (Data Definition Language) |
Statements used for creating tables, relationships, and other structures. |
|
DML (Data Manipulation Language) |
Statements used for querying, inserting, modifying, and deleting data. |
|
SQL / PSM (Persistent Stored Modules) |
Extend sql by adding procedural programming capabilities. |
|
TCL (Transaction Control Language) |
Statements used to mark transaction boundaries and control transaction behavior. |
|
DCL (Data Control Language) |
Statements used to grant database permissions to users and groups, or to revoke them. |
|
CREATE TABLE NewTableName ( |
Command for creating tables structures. |
|
CONSTRAINT |
Keyword to identify table constraints and primary keys. |
|
SQL INSERT |
A command for adding data to a relation. |
|
SQL SELECT |
Specifies which columns are to be listed in a query. |
|
SQL FROM |
Specifies which tables are to be used in a query. |
|
SQL WHERE |
Specifies which rows are to be listed in the query results. |
|
DISTINCT |
A keyword that tells DBMS to check for and eliminate duplicate rows. |
|
SQL asterisk (✳) after the keyword SELECT |
Another way to specify all the columns of a table. |
|
ASC / DESC |
Keywords specifying ascending and descending order when necessary. |
|
GROUP BY |
A clause that allows to group rows by common values. |
|
SQL UPDATE... SET |
Statement that allows to modify the values of existing data. |
|
SQL MERGE |
Statement that combines the INSERT and UPDATE statements. |
|
SQL DELETE |
Statement that allows to eliminate rows. |
|
SQL DROP TABLE |
A statement that drops the table structure along with all of its data. |
|
ALTER TABLE |
Statement that allows you to add, modify, and drop columns and constraints. |
|
TRUNCATE TABLE |
Statement that allows you to remove all data from a table while leaving its structure in the database. |