TSQLMTMaster ClassMT-TSQL1.0<p>You can use the very productive T-SQL extensions. Develop stored procedures and functions and use them successfully locally and/or in the cloud.</p><p>Good knowledge of standard SQL (such as <span class="cms-link-marked"><a class="fl-href-prod" href="/swisscom/en/course/training-sql02"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>SQL Standard Intensive Training <span class="fl-prod-pcode">(SQL02)</span></a></span>)</p><ul> <li>Presentation of the most important functions and components of SQL Server and Azure SQL.</li><li>Repetition Select</li><li>SQL Server data types</li><li>More complex DML instructions</li><li>Write queries that use built-in functions.</li><li>Aggregate data.</li><li>Write subqueries.</li><li>Create and implement views and table valued functions.</li><li>Use set operators to combine query results.</li><li>Writing queries that enable windowing of the data.</li><li>Transform data by using pivot, unpivot, rollup and cube.</li><li>programming constructs such as variables, conditions and loops to T-SQL code.</li><li>Stored Procedures entwickeln</li><li>Integrate Python code</li></ul>You can use the very productive T-SQL extensions. Develop stored procedures and functions and use them successfully locally and/or in the cloud.Good knowledge of standard SQL (such as SQL Standard Intensive Training (SQL02))- 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 code2 days1940.001690.001690.005870.001690.001690.001690.001720.00