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.
Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
Prerequisites
Good knowledge of standard SQL (such as !)
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
Anglais
Allemand
Allemagne
Suisse
Moyens Pédagogiques :