SELECT

INSERT

GRANT : DQL

CREATE : DDL

DROP :DML

TRUNCATE :DDL

UPDATE :

RENAME : DCL

The command is completed with a … at the end of the statement.

Creating a table by you assign a name and data type to each column (field or attribute)

SQL ensures data integrity via column’s description

SQL commands cannot retrieve and examine the data stored in a table

ensure that required columns are filled with data and that we do not enter duplicate entries by accident

for inserting rows into table The easiest technique is to import data from a text file or another database.

Text and dates require quotation marks

Numbers, including integers and decimals, require quotation marks

Formatting SQL For readability: SQL keywords, such as SELECT, are capitalized.

Whether the data is clean or dirty, whether it is complete

Data Querying

Selects all columns’ values from the table Using … the wildcard

…. to Find Unique Values