Databases
Concepts
Entities
Attributes
Simple Vs Composite
Single Vs Multi Valued
Keys:
Super Key
Candidate Key
Primary Key
Relationships❤
Cardinality
Optionality
Normalzation
SQL
DDL
DML
Create
Alter
Delete
Add Primary key
Creating Tables
Attributes,
(+) Primary Key,
(+)Foreign Key
Add Foreign Key
Add column
select
Complex WHERE
JOIN
Inner join
Outer Join
Right outer join
Simple Select
Left outer join
GROUP BY
AVG , COUNT, MAX, MIN