SQL iRef is an application which provides you with information about the concepts with a detailed description.
This application provides you with a wide range of frequently asked questions and answers.
Following are some of the concepts described in this application are,
Basics of SQL
- ACID Properties
- Collation
- Connection Pooling
- Cursors
- Deadlocks
- Delete Vs Truncate Vs Drop
- DTS
- Replication
- SQL Injection
- RDBMS
- SQL PRofiler
- Stored PRocedures
- Triggers
- Transactions
- Try...Catch
- Functions
- View
- Locks
- Errors
Keys & Constraints
- Entity Integrity
- Domain Integrity
- Referential Integrity
- User-Defined Integrity
- Primary Key
- Foreign Key
- Unique Key
- Check
- Not Null
- Candidate Key
- Composite Key
Joins
- Inner Join
- Equi Join
- Natural Join
- Cross Join
- Self Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
Indexes
- Clustered
- Non Clustered
Normalization & Denormalization
- 1NF
- 2NF
- 3NF
- BCNF
- 4NF
- 5NF
- ONF
- DKNF
- Denormalization
and also various optimization techniques
Please, fell free to drop in your suggestions at [email protected]