Master Class: Transact SQL – SQL Extensions for SQL Server and Azure SQL (TSQL)


Course Overview

In this workshop you will learn the basics and how to use the Transact SQL (T-SQL) extensions. These additions to the standard (SQL02) bring enormous productivity, performance and security to your applications. You can then apply the acquired knowledge in local (on-prem) as well as in the Azure Cloud.


Good knowledge of standard SQL (such as SQL Standard Intensive Training (SQL02))

Course Objectives

You can use the very productive T-SQL extensions. Develop stored procedures and functions and use them successfully locally and/or in the cloud.

Course Content

  • Presentation of the most important functions and components of SQL Server and Azure SQL.
  • Repetition Select
  • SQL Server data types
  • More complex DML instructions
  • Write queries that use built-in functions.
  • Aggregate data.
  • Write subqueries.
  • Create and implement views and table valued functions.
  • Use set operators to combine query results.
  • Writing queries that enable windowing of the data.
  • Transform data by using pivot, unpivot, rollup and cube.
  • programming constructs such as variables, conditions and loops to T-SQL code.
  • Stored Procedures entwickeln
  • Integrate Python code

Precios & Delivery methods

Entrenamiento en línea

2 días

  • Consulta precio y disponibilidad
Classroom training

2 días

  • Consulta precio y disponibilidad

Click on town name or "Online Training" to book Calendario

Instructor-led Online Training:   Este es un curso en línea Guiado por un Instructor
Este es un curso FLEX, que es entregado tanto virtualmente como en el salón de clase.

Costa Rica

Entrenamiento en línea Zona Horaria: America/Costa_Rica Inscripción