Microsoft SQL Server - Rewrite your queries for better performance

Duration: 1 days | Price: 300 €
Dates Rome: 26-06-2019, 31-07-2019, 28-08-2019, 25-09-2019, 30-10-2019, 27-11-2019, 25-12-2019


Requirements:


Description:

Compared to other programming language, T-SQL it's not an hard language to learn, and excluding some syntactic errors cane be really tolerant. There is a tendency to learn only the fundamental statements of the language: SELECT, INSERT, UPDATE and DELETE; only who invest more time, uncovers the declarative nature of this language and can obtain the best performance and power from own query. This workshop provides an introduction to the Execution Plan and the DMV in SQL Server, deals with set-based statement present in the language T-SQL. Execution Plan helps us to answer to the questions: "Why this query is so slow?", "Which index shall be utilized, and in wich way?". The DMV (view and system functions) provides information of SQL Server istance's health state, as well as feedback of the query's performance. The arguments processed on T-SQL language will allow to improve the code's writing, using set-based statement present in SQL Server, as well as those implemented in the last versions, particularly window functions.


Contents:

  • Introduction to Execution Plan in SQL Server
  • Introduction to DMV (Dynamic Management Views and Functions)
  • T-SQL Language
  • MERGE command
  • Common Table Expressions (CTE)
  • CTE multiple
  • CTE recursive
  • APPLY operator
  • OVER clause
  • Exstensions
  • Window functions
  • PIVOT and UNPIVOT
  • OFFSET/FETCH options
  • Trigger'development