T-SQL – advanced programming

Course objectives

The workshop aims to provide knowledge about the principles of proper implementation and use of T-SQL code.

Benefits

• Workshop participants will learn the principles of efficient use of the following T-SQL constructs:
  • Temporary tables
  • Scalar functions
  • Views
  • Tabular functions
  • Triggers
  • Window functions

Training scope

• Tabular expressions and views
• Tabular variables and temporary tables
• Window functions
• Scalar and tabular functions
• Stored procedures
• Case study part 1 – In how many ways can you write the selected functionality?
• Case study part 2 – Which T-SQL construct should be chosen?

Audience

Database developers with a minimum of 2 years of experience.