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