Is this your app? Claim this page to add your own description, links and contact info. It's free. →
Screenshots
Description
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]
Estimates
Availability
Devices
iPhoneFirstGen
iPodTouchSecondGen
iPhone3G
iPhone3GS
iPadWifi
iPad3G
iPhone4
iPodTouchThirdGen
iPodTouchFourthGen
iPad2Wifi
iPad23G
iPhone4S
iPadThirdGen
iPadThirdGen4G
iPhone5
iPodTouchFifthGen
iPadFourthGen
iPadFourthGen4G
iPadMini
iPadMini4G
iPhone5c
iPhone5s
iPadAir
iPadAirCellular
iPadMiniRetina
iPadMiniRetinaCellular
iPhone6
iPhone6Plus
iPadAir2
iPadAir2Cellular
iPadMini3
iPadMini3Cellular
iPodTouchSixthGen
iPhone6s
iPhone6sPlus
iPadMini4
iPadMini4Cellular
iPadPro
iPadProCellular
iPadPro97
iPadPro97Cellular
iPhoneSE
Pricing by country
| Country | Price |
|---|---|
| USA | 0.99 USD |
