SQL iRef at App Store analyse

App power index: 420 (based on ranks around App Stores today)
Reference Education
Developer: mkiapps
Price: 0 free
Current version: 1.0, last update: 7 years ago
First release : 11 Jan 2010
App size: 420.21 Kb
4.0 ( 290 ratings )
follow app

Estimation application downloads and cost

> 9.24k
Monthly downloads
~ $ 3.78k
Estimation App Cost


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]
Read more
No search terms founded
Available in countries
Country Price
USA 0.99 USD
Available for 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,