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.

Prerequisites

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

Duración
2 días

Precio
  • Consulta precio y disponibilidad
Classroom training

Duración
2 días

Precio
  • Consulta precio y disponibilidad

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

Este es un curso FLEX, que es entregado tanto virtualmente como en el salón de clase.

Alemania

Munich Inscripción
Frankfurt Inscripción
Munich Inscripción

Suiza

Curso FLEX Zurich Inscripción
Entrenamiento en línea Zona Horaria: Hora central europea Inscripción
Curso FLEX Zurich Inscripción
Entrenamiento en línea Zona Horaria: Hora central europea Inscripción
Curso FLEX Zurich Inscripción
Entrenamiento en línea Zona Horaria: Hora central europea de verano Inscripción
Curso FLEX Zurich Inscripción
Entrenamiento en línea Zona Horaria: Hora central europea de verano Inscripción