database ibm | Mind Map

Entity relationship data model (ER data model)used as a tool to design Relational DB

Entities (Rectangle)

Table

Primary Key

Foreign Key

Attributes (Oval)

Colums in table

Relational Data Model

Relational DB

Atrributes (Columns)

Sub Topic

Tuples (rows )

SQL

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

Mapping entity Diagrams to tables