Querying Data with Microsoft Transact-SQL Training (DP-080)

Course Overview

This course will teach the basics of Microsofts 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.

This course is delivered over 2 full days.

Key Information

Course Length
16 hours

Learning Method(s)
Online materials
Online assessment

For Individuals

Full Cost Price
£1,245.00

Get in touch with us today to register your interest

Register interest

Buy the course today and begin your journey to qualification

Use SQL Server query tools
Write SELECT statements to retrieve columns from one or more tables
Sort and filter selected data
Use built-in functions to returned data values
Create groups of data and aggregate the results
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE