Home / Courses / AI, Data & Analytics / Query and modify data with Transact-SQL

Query and modify data with Transact-SQL

Name: Query and modify data with Transact-SQL
Availability: InStock
Rating: 4.6 (5878 reviews)

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.

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Enquire Now

Download Overview

Duration:

16.00 hours

13.0 CPD hours

Overview:

Description:

- 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

Available Delivery Options for Query and modify data with Transact-SQL

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does Query and modify data with Transact-SQL provide?

The 2 day Query and modify data with Transact-SQL course gives you up to 13.0 CPD hours/structured learning hours.

Who is the correct audience for Query and modify data with Transact-SQL?

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.

Do you provide training for Query and modify data with Transact-SQL?

Yes, we provide corporate training, dedicated training and closed classes for Query and modify data with Transact-SQL. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Query and modify data with Transact-SQL?

The Query and modify data with Transact-SQL training takes place over 2 day(s), with each day lasting approximately 16.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Query and modify data with Transact-SQL, AI, Copilot, Power BI & Data Analytics, DP-080T00

Why are Nexus Human the best provider for Query and modify data with Transact-SQL?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for Query and modify data with Transact-SQL?

Yes, the discount code PENPAL5 is currently available for Query and modify data with Transact-SQL training. Only one discount code can be used per booking.

DURATION 16.00 Hours

No scheduled classes available at this time.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.