T-SQL Querying: Advanced Techniques

Info Support B.V.

Extend your T-SQL knowledge to write optimal queries

Price

from €1,450

Level

Bachelor

Kind

Training

Subject

Automation and IT, Internet and media

More information and registration at Info Support B.V.

Description

You learn to use advanced features of Transact-SQL. This will enable you to consider different solution strategies to solve business questions, leading to a more optimal solution. - Refresher - Table Expressions - Set Operators - Window Ranking, Offset and Aggregate Functions - Pivot Tables and Grouping Sets - Programming with T-SQL In this module we will make sure everyone remembers the basics of querying and we can continue at the same level. Goals: - Standard elements of a SELECT query - Joins - Grouping & Aggregating - Subqueries Table expressions are SQL elements that are not a table but can (mostly) be used as if they were in fact a table. Goals: - Views - Table Valued Functions - Derived Tables - Common Table Expressions (CTE) - Apply - When to pick which option? Set Operators allow you to vertically combine and compare two similar result sets. This contrasts joins, where you are horizontally combining data. Goals: - UNION (ALL) - EXCEPT / INTERSECT Window functions are ideal for many analytics scenarios like running totals and moving averages. They also allow you to 'time travel' to previous or following values in your result set. Goals:…