database ibm
A mind map about database ibm.
Tags:
Similar Mind Maps
Outline


Entities (Rectangle)
Table
Primary Key
Foreign Key
Attributes (Oval)
Colums in table

Relational DB
Atrributes (Columns)
Sub Topic
Tuples (rows )

SQL Statement Types
DDL: Data Definition Language
Common DDL Statements
Create
Alter
Truncate
Drop
Define, change, drop data
DML: Data Manipulation Language
Read and modify
CRUD Operations (Create, Read, Update, Delete Rows)
Common DML
select
Retrieve
count
distinct
limit
Predicate
WHERE
operators
OR
IN
BETWEEN AND
LIKE
String patterns
where firstname LIKE R%
sorting result
order by
ascending (default)
descending (DESC)
order by 2 (column 2)
grouping result
GROUP BY
select country, count (contntry) from Author GROUP BY Country
HAVING (filtering result of the grouping)
AS COUNT keyword?
Insert
insert rows
Add
Add colums
update
delete
Sub Topic
Sub Topic
