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, participants will be able to:

• Understand Transact-SQL Fundamentals: Explain T-SQL syntax, structure, and core concepts.

• Use SQL Server Query Tools: Work effectively with tools for writing and executing T-SQL queries.

• Retrieve Data with SELECT Statements: Construct queries to extract data from one or multiple tables.

• Sort and Filter Data: Apply ORDER BY, WHERE, and other filtering techniques to refine query results.

• Combine Data with JOINs and Subqueries: Use different JOIN types and subqueries for complex data retrieval.

• Leverage Built-in Functions: Apply scalar and aggregate functions for data manipulation and transformation.

• Group and Aggregate Data: Summarize datasets using GROUP BY with aggregate operations such as SUM, AVG, and COUNT.

• Modify Data with T-SQL: Insert, update, delete, and merge records to maintain and manage data.

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.

• No formal prerequisites – the course is beginner-friendly.

• Recommended knowledge:

  • Basic understanding of relational database concepts.

  • General familiarity with IT systems and data storage.