DP-080T00
DP-080T00: Query and modify data with Transact-SQL
Price:
Duration:
Please Call
2 Days
Prerequisites
Basic computer skills, familiarity with spreadsheet data, and
a basic understanding of relational database concepts like tables.
What you’ll learn in this course
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.
Course Outline
• 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-SQL
Further information
If you would like to know more about this course please contact us
