The download button opens the iTunes App Store, where you
may continue the download process. You must have iTunes installed with an
active iTunes account in order to download and install the software. This
download may not be available in some countries.
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 Server2. INNER JOIN, Self Join, Outer Join and Cross Join3. Basic SQL SELECT and SELECT INTO Statements4. Sorting SELECT Query Results with ORDER BY5. Exploring CTEs, Nested & Correlated Subqueries6. SELECT with UNION, UNION ALL, ROLLUP & CUBE7. Date & Time, String and Math System Functions8. Configuration & System Statistical Functions9. Dynamic SQL Query Building & Execution 10. The GROUP BY Clause & Aggregate Functions11. Working with Hierarchy ID & Metadata Functions 12. OVER Clause: Ranking, Aggregate & Analytic Fns 13. Review of Recursive Queries & Tree Processing14. TOP: Split Comma Delimited String with XML 15. Crosstab Queries Using PIVOT & CASE 16. Date Conversion to String & Vice VersaNo 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!