Apply for Short Course - SQL 5: Advanced Queries ...
This short course covers advanced querying techniques using Microsoft T-SQL 2012.
• PIVOT / UNPIVOT
• Analytic functions: LEAD, TAG etc.
• Grouping Sets ,ROLLUP and CUBE
• Filtering with the TOP and OFFSET-FETCH
• Writing Correlated Subqueries
• Using the EXISTS Predicate with Subqueries
• Using Temporary Tables
• Table Variables and Table Types
• Dynamic SQL
• How to Query and Manage XML dataApply for this Evening / Short Course »