Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

DeepDive T-SQL – Analytic Functions (Grouping, Pivoting and Windowing and more)

Master these powerful functions!

}

Duration: 8 hours

 

Level: 300

 

What does this course cover?

Windowing functions are one of the most powerful and at the same under-utilized time features of the T-SQL language. Apparently the reason is that developers often are simply not aware of it. Using windowing functions developers can create powerful, simplified code with awesome results.

Pre-requisites: What do you need to know?

Experience with SQL Server Administration and Development

“Learned a lot I wasn’t aware of”

Karl Kraus

Developer, Graz

Course outline

Grouping, Pivoting and Windowing

  • Window Functions
  • Pivoting and Unpivoting Data
  • Custom Aggregations
  • Grouping Sets

TOP and OFFSET-FETCH

  • TOP
  • OFFSET-FETCH
  • Top N Per Groupfication

Data Modification

  • Inserting Data
  • Sequences
  • Deleting Data
  • Updating Data
  • Merging Data
  • The OUTPUT Clause

All our courses can be offered as a private delivery and tailored for your team's specific needs