Short Course - SQL 5: Advanced Queries

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 data

Apply for this Evening / Short Course »