Query Optimization Tips[Link]





Six Important Types of Databases

What is Transaction in SQL???

A transaction is a single unit of work. If a transaction is successful, all of the data modifications made during the transaction are committed and become a permanent part of the database. If a transaction encounters errors and must be canceled or rolled back, then all of the data modifications are erased.

Functional Dependency in Database (Normalization)

Goal of Normalization is to reduce Redundancy.

Four Technique

  1. First Normal Form
  2. Second Normal Form
  3. Third Normal Form
  4. BCNF (Boyce and Codd Normal Form)

Create a free website or blog at

Up ↑