Database Concept
DBMS ER Model
DBMS Relational model
- DBMS Codd’s 12 rule
- DBMSBasic Concepts
- DBMS Relational Algebra
- DBMS Relational Calculus
- DBMS ER Model to Relational Model
- DBMS Types of Database key
DBMS Normalization
- DBMS Introduction to Normalization
- DBMS First Normal Form (1NF)
- DBMS Second Normal Form (1NF)
- DBMS Third Normal Form (3NF)
- DBMS Boyce-Codd Normal Form (BCNF)
- DBMS Fourth Normal Form (4NF)
- DBMS Fifth Normal Form (5NF)
DBMS Basic SQL
DBMS DML Command
DBMS DCL Command
- All DCL Command
- SELECT query
- WHERE clause
- LIKE clause
- ORDER BY clause
- Group BY clause
- Having clause
- DISTINCT keyword
- AND & OR operator
- DIVISION operator
Advanced SQL
Fifth Normal Form in Database Normalization is generally not implemented in real life database design. But you should know what it it.