DAY 02: More SELECT keywords and WHERE Clause In SQL

• NULL (use by IS NULL or IS NOT NULL)
• LIKE operators( % or _ )(not case sensitive) -Relational Operators(< > <= >= )
• BETWEEN AND keyword
• ORDER BY ( ASC OR DESC -Aggregate Functions(COUNT, AVG,SUM,MAX, MIN ) -->**

Relational Databases in SQL

**
-One to One relationships
-One to Many relationships
-Many to Many relationships

• ER Diagram (Crow's foot notation) -KEYS ( PRIMARY KEY AND FOREIGN KEY)