{"course":{"productid":23940,"modality":1,"active":true,"language":"en","title":"Query and modify data with Transact-SQL","productcode":"DP-080T00","vendorcode":"MS","vendorname":"Microsoft","fullproductcode":"MS-DP-080T00","courseware":{"has_ekit":true,"has_printkit":false,"language":""},"url":"https:\/\/portal.flane.ch\/course\/microsoft-dp-080t00","audience":"<p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.<\/p>","contents":"<ul>\n<li>Introduction to Transact-SQL<\/li><li>Sort and filter results in T-SQL<\/li><li>Combine multiple tables with JOINs in T-SQL<\/li><li>Write Subqueries in T-SQL<\/li><li>Use built-in functions and GROUP BY in Transact-SQL<\/li><li>Modify data with T-SQL<\/li><\/ul>","summary":"<p>This course will teach the basics of Microsoft&#039;s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.<\/p>","audience_plain":"This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.","contents_plain":"- Introduction to Transact-SQL\n- Sort and filter results in T-SQL\n- Combine multiple tables with JOINs in T-SQL\n- Write Subqueries in T-SQL\n- Use built-in functions and GROUP BY in Transact-SQL\n- Modify data with T-SQL","summary_plain":"This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.","skill_level":"Intermediate","version":"A","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1390},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1390},"UA":{"country":"UA","currency":"USD","taxrate":20,"price":500},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":4820},"MK":{"country":"MK","currency":"EUR","taxrate":null,"price":500},"GR":{"country":"GR","currency":"EUR","taxrate":null,"price":500},"HU":{"country":"HU","currency":"EUR","taxrate":20,"price":500},"IN":{"country":"IN","currency":"USD","taxrate":12.36,"price":899},"SG":{"country":"SG","currency":"USD","taxrate":8,"price":1119},"AU":{"country":"AU","currency":"USD","taxrate":10,"price":1390},"AE":{"country":"AE","currency":"USD","taxrate":5,"price":1500},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":950},"BE":{"country":"BE","currency":"EUR","taxrate":21,"price":950},"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":980},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":1545},"US":{"country":"US","currency":"USD","taxrate":null,"price":1545},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":1695},"RU":{"country":"RU","currency":"RUB","taxrate":18,"price":31800},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1870},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":1390},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":1590}}},"lastchanged":"2026-03-31T18:37:00+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/23940","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/microsoft-dp-080t00"}}