Learn SQL Server
Detailed App Info:
Application Description
Learn SQL Server in a matter of hours. Our app provides 16 video tutorials and an interactive quiz that will help you understand easily and thoroughly Microsoft SQL Server 2012. Topics covered are:
1. New Programming Features in SQL Server 2012
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 2012 in the park, in the library or even on the subway!
1. New Programming Features in SQL Server 2012
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 2012 in the park, in the library or even on the subway!
Requirements
Your mobile device must have at least 1.75 GB of space to download and install Learn SQL Server app. Learn SQL Server is available on iTunes for $0.99
If you have any problems with installation or in-app purchase, found bugs, questions, comments about this application, you can visit the official website of Marma Media Inc. at http://www.sqlusa.com.
Copyright © 2013 Marma Media