Important information

This site uses cookies to store information on your computer. By continuing to use our site, you consent to Steel Media's privacy policy.

Steel Media websites use two types of cookie: (1) those that enable the site to function and perform as required; and (2) analytical cookies which anonymously track visitors only while using the site. If you are not happy with this use of these cookies please review our Privacy Policy to learn how they can be disabled. By disabling cookies some features of the site will not work.


Learn SQL Server


Learn SQL Server
Download on the AppStore Click here to request a review of this app

  • App Store Info

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

Screenshots

Screenshot 1 of 4 Screenshot 2 of 4 Screenshot 3 of 4 Screenshot 4 of 4