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.

This text was automatically translated. Please click here to read the original German version.

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

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • 1,690.— €

Courseware language: English

Classroom Training

Duration
2 days

Price
  • Germany: 1,690.— €
  • Switzerland: CHF 1,940.—

Courseware language: English

Find out more in our course video

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

English

Time zone: Central European Summer Time (CEST)   ±1 hour

Online Training
Classroom option: Zurich, Switzerland
Time zone: Central European Summer Time (CEST)
Online Training
Classroom option: Zurich, Switzerland
Time zone: Central European Summer Time (CEST)
Online Training
Classroom option: Zurich, Switzerland
Time zone: Central European Summer Time (CEST)
Online Training
Classroom option: Zurich, Switzerland
Time zone: Central European Time (CET)

7 hours difference

Online Training Time zone: Eastern Standard Time (EST)
Online Training Time zone: Eastern Standard Time (EST)
Online Training Time zone: Eastern Standard Time (EST)
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Berlin
Hamburg
Stuttgart
Munich

Switzerland

Zurich
Zurich
Zurich
Zurich
Zurich
Zurich
Zurich
Zurich

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.