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

DM-SQLDDGPW-EN

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

WHEN and WHERE is this course running?

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

Contact us

WHEN and WHERE is this course running next?

Check dates