Query Optimization Tips[Link]

http://blog.sqlauthority.com/2013/08/28/sql-server-tips-for-sql-query-optimization-by-analyzing-query-plan/

http://web.synametrics.com/top10performancetips.htm

http://beginner-sql-tutorial.com/sql-query-tuning.htm

http://www.mindfiresolutions.com/SqlServer-Query-Optimization-Tips-470.php

 

 

 

Six Important Types of Databases

http://www.yourarticlelibrary.com/database/database-six-important-types-of-databases-business-management/10375/

http://4840895.blogspot.in/2009/04/history-of-dbms.html

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)