App Detail » Learn SQL Server

What's New

- Updated for iOS 8
- Improved graphics
- Removed ads

App Description

Learn SQL Server in a matter of hours. Our app provides 16 video tutorials with narration and an interactive quiz that will help you understand easily and thoroughly Microsoft SQL Server. Topics covered are:


1. New Programming Features in SQL Server

2. INNER JOIN, Self Join, Outer Join and Cross Join

3. Basic SQL SELECT and SELECT INTO Statements

4. Sorting SELECT Query Results with ORDER BY

5. Exploring CTEs, Nested & Correlated Subqueries

6. SELECT with UNION, UNION ALL, ROLLUP & CUBE

7. Date & Time, String and Math System Functions

8. Configuration & System Statistical Functions

9. Dynamic SQL Query Building & Execution 

10. The GROUP BY Clause & Aggregate Functions

11. Working with Hierarchy ID & Metadata Functions 

12. OVER Clause: Ranking, Aggregate & Analytic Fns

13. Review of Recursive Queries & Tree Processing

14. TOP: Split Comma Delimited String with XML 

15. Crosstab Queries Using PIVOT & CASE

16. Date Conversion to String & Vice Versa

No internet connection is needed to view these tutorials which means you can learn Microsoft SQL Server in the park, in the library or even on the subway!

App Changes

• August 26, 2013 Initial release
• September 07, 2013 Price decrease: $49.99 -> $24.99
• September 11, 2013 Price decrease: $24.99 -> $9.99
• September 17, 2013 Price increase: $9.99 -> $49.99
• October 11, 2013 Price decrease: $49.99 -> $14.99
• November 02, 2013 Price increase: $14.99 -> $24.99
• November 06, 2013 Price decrease: $24.99 -> $4.99
• November 11, 2013 Price increase: $4.99 -> $24.99
• November 13, 2013 Price decrease: $24.99 -> $9.99
• November 16, 2013 Price decrease: $9.99 -> $0.99
• November 22, 2013 Price increase: $0.99 -> $9.99
• November 23, 2013 Price decrease: $9.99 -> $2.99
• December 01, 2013 Price increase: $2.99 -> $4.99
• December 02, 2013 Price increase: $4.99 -> $14.99
• December 05, 2013 Price decrease: $14.99 -> $4.99
• December 07, 2013 Price decrease: $4.99 -> $0.99
• December 10, 2013 Price increase: $0.99 -> $2.99
• February 11, 2014 Price increase: $2.99 -> $4.99
• February 12, 2014 Price decrease: $4.99 -> $0.99
• February 15, 2014 Price increase: $0.99 -> $2.99
• February 17, 2014 Price increase: $2.99 -> $4.99
• March 01, 2014 Price decrease: $4.99 -> $2.99
• March 09, 2014 Price increase: $2.99 -> $4.99
• March 18, 2014 Price decrease: $4.99 -> $1.99
• March 21, 2014 Price increase: $1.99 -> $29.99
• March 22, 2014 New version 1.1
• March 22, 2014 Price decrease: $29.99 -> $4.99
• April 03, 2014 Price decrease: $4.99 -> $2.99
• June 29, 2014 Price decrease: $2.99 -> $0.99
• July 14, 2014 Price increase: $0.99 -> $3.99
• July 21, 2014 Price decrease: $3.99 -> $2.99
• December 04, 2014 Price increase: $2.99 -> $3.99
• December 07, 2014 Price decrease: $3.99 -> $2.99
• February 06, 2015 Price decrease: $2.99 -> $1.99
• February 15, 2015 Price decrease: $1.99 -> $0.99
• March 08, 2015 Price increase: $0.99 -> $9.99
• May 06, 2015 Price decrease: $9.99 -> $8.99
• May 14, 2015 Price increase: $8.99 -> $11.99
• May 18, 2015 Price decrease: $11.99 -> $9.99
• July 11, 2015 New version 1.2.3
• October 05, 2015 Price increase: $9.99 -> $11.99
• October 13, 2015 Price decrease: $11.99 -> $9.99
• November 22, 2015 Price increase: $9.99 -> $19.99
• November 28, 2015 Price decrease: $19.99 -> $9.99
• December 13, 2015 Price decrease: $9.99 -> $4.99
• January 02, 2016 Price increase: $4.99 -> $9.99
• January 04, 2016 Price decrease: $9.99 -> $4.99
• January 11, 2016 Price increase: $4.99 -> $9.99
• January 19, 2016 Price decrease: $9.99 -> $0.99
• January 27, 2016 Price increase: $0.99 -> $9.99
• February 04, 2016 Price decrease: $9.99 -> $2.99
• July 05, 2016 Price increase: $2.99 -> $9.99
• November 09, 2016 Price decrease: $9.99 -> $7.99
• January 05, 2017 Price decrease: $7.99 -> $4.99