Please enable JavaScript.
Coggle requires JavaScript to display documents.
Structured Query Language (SQL) (SQL DDL (ISO SQL data types (boolean,…
Structured Query Language (SQL)
Database language
DDL
For defining the DB structure and controlling access to data
DML
For retrieving and updating data
SQL commands
consists of reserved words and user-defined words
literals
non-numerical - enclosed in single quotes
numerical - not enclosed in quotes
SQL DDL
Data definition
Create schema
Create table
Drop table
Alter table
ISO SQL data types
boolean
varchar
integer
date
float
Integrity enhancement feature
Required data
Domain constraint
Entity integrity
Referential integrity
General/enterprise constraint
Views
Transactions
Discretionary access control
SQL DML
SELECT
INSERT
UPDATE
DELETE