{"course":{"productid":26072,"modality":1,"active":true,"language":"fr","title":"Master Class: Transact SQL \u2013 SQL Extensions for SQL Server and Azure SQL","productcode":"TSQL","vendorcode":"MT","vendorname":"Master Class","fullproductcode":"MT-TSQL","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/masterclass-tsql","objective":"<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>","essentials":"<p>Good knowledge of standard SQL (such as <span class=\"cms-link-marked\"><a class=\"fl-href-prod\" href=\"\/swisscom\/fr\/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>","contents":"<ul>\n<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>","summary":"<p>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.<\/p>","objective_plain":"You can use the very productive T-SQL extensions. Develop stored procedures and functions and use them successfully locally and\/or in the cloud.","essentials_plain":"Good knowledge of standard SQL (such as SQL Standard Intensive Training (SQL02))","contents_plain":"- Presentation of the most important functions and components of SQL Server and Azure SQL.\n- Repetition Select\n- SQL Server data types\n- More complex DML instructions\n- Write queries that use built-in functions.\n- Aggregate data.\n- Write subqueries.\n- Create and implement views and table valued functions.\n- Use set operators to combine query results.\n- Writing queries that enable windowing of the data.\n- Transform data by using pivot, unpivot, rollup and cube.\n- programming constructs such as variables, conditions and loops to T-SQL code.\n- Stored Procedures entwickeln\n- Integrate Python code","summary_plain":"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.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 jours"},"pricelist":{"List Price":{"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1940},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1690},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1690},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":5870},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1690},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":1690},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":1690},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":1720}}},"lastchanged":"2026-01-13T18:59:15+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/26072","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/masterclass-tsql"}}