iTunes

Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator
Opening the iBooks Store.If iBooks doesn't open, click the iBooks app in your Dock.Progress Indicator
iTunes

iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To buy and download Learn SQL Server by Marma Media Inc., get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

I Have iTunes Free Download
iTunes for Mac + PC

Learn SQL Server

By Marma Media Inc.

Open iTunes to buy and download apps.

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!

What's New in Version 1.1

- improved graphics
- minor bug fixes

iPad Screenshots

iPad Screenshot 1
iPad Screenshot 2
iPad Screenshot 3
iPad Screenshot 4

Customer Reviews

Terrible Terrible!!

Are you serious? You sell this 9:00$. Very bad application, for those of who have landed on this app by accident like me here is what happen.. When you open up the app it gives you list of topics to choose which is good but when you click on each topic it is so amazing .. It takes you directly to the terrible recorded video clip ( the video recorded from his website screen The quality of the video is so bad you can not even see the codes, and you can see the whole website in the video shot as well and distract you so bad!)
The other amazing thing is there is ads displays on the top of the app, are you serious? After I have paid 9 for this terrible disorganized app and I still see ads on the top! Guys pls don't even try this! The video you can find on YouTube is way better than this crapy uneducated disorganized video! Bad bad bad!

Learn SQL Server
View In iTunes
  • $9.99
  • Category: Education
  • Updated:
  • Version: 1.1
  • Size: 1.88 GB
  • Language: English
  • Seller:

Compatibility: Requires iOS 4.3 or later. Compatible with iPad.

Customer Ratings

We have not received enough ratings to display an average for the current version of this application.
All Versions: