T-SQL Querying: Advanced Techniques

Info Support B.V.

Extend your T-SQL knowledge to write optimal queries

Prijs

vanaf € 1.450

Niveau

Bachelor

Soort

Training

Thema

Automatisering en ICT, Internet en media

Meer informatie en aanmelden bij Info Support B.V.

Beschrijving

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:…