Querying Data with Microsoft Transact-SQL (DP-080T00) (replacing 20761)

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.

Module 1: Introduction to Transact-SQL

• Understand what SQL is for
• Identify database objects in schemas
• Identify SQL statement types
• Use the SELECT statement
• Work with data types
• Handle NULLs

Module 2: Sort and filter results in T-SQL

• Sort your results
• Limit the sorted results
• Return paged results
• Remove duplicates
• Filter data with predicates

Module 3: Combine multiple tables with JOINs in T-SQL

• Describe join concepts and syntax
• Write queries that use inner and outer joins
• Write queries that use cross joins
• Write queries that use self joins

Module 4: Write Subqueries in T-SQL

• Understand what subqueries are
• Use scalar or multi-valued subqueries
• Use self-contained or correlated subqueries

Module 5: Use built-in functions and GROUP BY in Transact-SQL

• Categorize built-in functions
• Use scalar functions
• Use ranking and rowset functions
• Use aggregate functions
• Summarize data with GROUP BY
• Filter groups with HAVING

Module 6: Modify data with T-SQL

• Insert data into a table
• Generate automatic values
• Update data in a table
• Delete data from a table
• Merge data based on multiple 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.