SQL iRef


4.0 ( 290 ratings )
Håndbøger Uddannelse
Forfatter: mkiapps
0.99 USD

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]