DP-080T00MSMicrosoftMS-DP-080T00A<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><ul> <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>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.- Introduction to Transact-SQL - Sort and filter results in T-SQL - Combine multiple tables with JOINs in T-SQL - Write Subqueries in T-SQL - Use built-in functions and GROUP BY in Transact-SQL - Modify data with T-SQL2 days1390.001390.00500.004820.00500.00500.00500.00899.001119.001390.001500.00950.00950.00980.001545.001545.001695.0031800.001870.001390.001590.004.00