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

Prices & Delivery methods

Online Training
Modality: L

Duration 2 days

Price
  • Eastern Europe: 1,690.— €
Classroom Training
Modality: C

Duration 2 days

Price
  • Eastern Europe: 1,690.— €

Schedule

English

Time zone: Central European Summer Time (CEST)

Online Training This is a FLEX course. Time zone: Central European Time (CET)
Online Training This is a FLEX course. Time zone: Central European Time (CET)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Europe

Germany

Munich Enroll

Switzerland

Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Europe/Zurich Enroll:
for online training
for classroom training
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).