Mindmap-Galerie database ibm
A mind map about database ibm.
40k classes
Cisco IOS interface
application development and deployment
Data Sanitization Tools
DATA COLLECTION MEASURES
Android
Java Training
Active reading techniques
Classification of visual languages
Game Theory
Database
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
Mapping entity Diagrams to tables
Wondershare EdrawMind
