{"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":"<h4>Introduction to Transact-SQL<\/h4><ul>\n<li>Introduction<\/li><li>Work with schemas<\/li><li>Explore the structure of SQL statements<\/li><li>Examine the SELECT statement<\/li><li>Work with data types<\/li><li>Handle NULLs<\/li><li>Exercise - Work with SELECT statements<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Sort and filter results in T-SQL<\/h4><ul>\n<li>Introduction<\/li><li>Sort your results<\/li><li>Limit the sorted results<\/li><li>Page results<\/li><li>Remove duplicates<\/li><li>Filter data with predicates<\/li><li>Exercise - Sort and filter query results<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Combine multiple tables with JOINs in T-SQL<\/h4><ul>\n<li>Introduction<\/li><li>Understand joins concepts and syntax<\/li><li>Use inner joins<\/li><li>Use outer joins<\/li><li>Use cross joins<\/li><li>Use self joins<\/li><li>Exercise - Query multiple tables with joins<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Write Subqueries in T-SQL<\/h4><ul>\n<li>Introduction<\/li><li>Understand subqueries<\/li><li>Use scalar or multi-valued subqueries<\/li><li>Use self-contained or correlated subqueries<\/li><li>Exercise - Use subqueries<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Use built-in functions and GROUP BY in Transact-SQL<\/h4><ul>\n<li>Introduction<\/li><li>Categorize built-in functions<\/li><li>Use scalar functions<\/li><li>Use ranking and rowset functions<\/li><li>Use aggregate functions<\/li><li>Summarize data with GROUP BY<\/li><li>Filter groups with HAVING<\/li><li>Exercise - Use built-in functions<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>\n<h4>Modify data with T-SQL<\/h4><ul>\n<li>Introduction<\/li><li>Insert data<\/li><li>Generate automatic values<\/li><li>Update data<\/li><li>Delete data<\/li><li>Merge data based on multiple tables<\/li><li>Exercise - Modify data<\/li><li>Module assessment<\/li><li>Summary<\/li><\/ul>","summary":"<p>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.<\/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\n\n- Introduction\n- Work with schemas\n- Explore the structure of SQL statements\n- Examine the SELECT statement\n- Work with data types\n- Handle NULLs\n- Exercise - Work with SELECT statements\n- Module assessment\n- Summary\n\nSort and filter results in T-SQL\n\n\n- Introduction\n- Sort your results\n- Limit the sorted results\n- Page results\n- Remove duplicates\n- Filter data with predicates\n- Exercise - Sort and filter query results\n- Module assessment\n- Summary\n\nCombine multiple tables with JOINs in T-SQL\n\n\n- Introduction\n- Understand joins concepts and syntax\n- Use inner joins\n- Use outer joins\n- Use cross joins\n- Use self joins\n- Exercise - Query multiple tables with joins\n- Module assessment\n- Summary\n\nWrite Subqueries in T-SQL\n\n\n- Introduction\n- Understand subqueries\n- Use scalar or multi-valued subqueries\n- Use self-contained or correlated subqueries\n- Exercise - Use subqueries\n- Module assessment\n- Summary\n\nUse built-in functions and GROUP BY in Transact-SQL\n\n\n- Introduction\n- Categorize built-in functions\n- Use scalar functions\n- Use ranking and rowset functions\n- Use aggregate functions\n- Summarize data with GROUP BY\n- Filter groups with HAVING\n- Exercise - Use built-in functions\n- Module assessment\n- Summary\n\nModify data with T-SQL\n\n\n- Introduction\n- Insert data\n- Generate automatic values\n- Update data\n- Delete data\n- Merge data based on multiple tables\n- Exercise - Modify data\n- Module assessment\n- Summary","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"}}