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