database ibm

Database
Relational DB
Atrributes (Columns)
Sub Topic
Tuples (rows )
SQL
SQL Statement Types
Sub Topic
DDL: Data Definition Language
DML: Data Manipulation Language
Common DDL Statements
Create
Alter
Truncate
Drop
Define, change, drop data
Read and modify
CRUD Operations (Create, Read, Update, Delete Rows)
Sub Topic
Common DML
Insert
select
update
delete
Entity relationship data model (ER data model)
used as a tool to design Relational DB
Relational Data Model
Entities (Rectangle)
Attributes (Oval)
Colums in table
Table
Mapping entity Diagrams to tables
Primary Key
Foreign Key
Predicate
Retrieve
WHERE
count
distinct
limit
Add
insert rows
Add colums
sorting result
String patterns
where firstname LIKE R%
operators
OR
IN
BETWEEN AND
LIKE
order by
ascending (default)
descending (DESC)
order by 2 (column 2)
grouping result
select country, count (contntry) from Author GROUP BY Country
HAVING (filtering result of the grouping)
GROUP BY
AS COUNT keyword?
92 1