DP-080T00 Query and modify data with Transact-SQL

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 and, Azure Synapse Analytics.

By the end of this course, students will be able to:

• Understand T-SQL fundamentals: Basics of the language, relational concepts, and SELECT statements.

• Query and filter data: Retrieve, sort, filter, and page results; manage duplicates.

• Combine data: Use INNER, OUTER, CROSS, and self-joins; apply subqueries.

• Use functions and grouping: Apply built-in functions, aggregate data with GROUP BY, and filter with HAVING.

• Modify data: Insert, update, delete, and merge data in relational tables.

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.

• Basic knowledge of the Microsoft Windows operating system

• Working knowledge of relational databases